//名稱包含關鍵字
Expression< Func< Models.Product, bool>> productNameContainsKeyword =
c => c.Name.Contains(input.Keyword);
//價格大於多少
Expression< Func< Models.Product, bool>> productPriceMoreThan =
c => c.Price >= priceFrom.Value;
//兩個條件And
var result = (from s in contex.ProductSet.Where(
productDecriptContainsKeyword.And(productPriceMoreThan)
)
SELECT [Id]
,[MemberId]
FROM [TestSet]
Where [MemberId] IS NULL
GO
int? memberid= null;
var reasult = contex.TestSet.Where(s => s.MemberId == memberid);
var reasult = contex.TestSet.Where(s => s.MemberId == null);
$(document).ready(function() {
$("someTableSelector").find("tr:gt(0)").remove();
});
function uploadStart(file) {
try {
this.addFileParam(file.id, "pId", "2");
var progress = new FileProgress(file, this.customSettings.progressTarget);
progress.setStatus("上傳中...");
progress.toggleCancel(true, this);
}
catch (ex) { }
return true;
}
[HttpPost]
public ActionResult PrintBarcode( List< Models.test > cmd)
{
...
}
class Test{
public long ProductId { get; set; }
public int Quantity { get; set; }
}
//檢查Ext副檔名
function CheckExtensionMusic() {
var type = /(.mp3|.MP3|.mP3|.Mp3)$/i;
if (!type.test($(".fileToUploadMusic").val())) {
$(".fileToUploadMusic").replaceWith("");
}
else {
}
}
//使用Ajax取得Json格式的資料 格式為 List
$.ajax({
type: 'GET',
url: GetUrl,
data: { id: id },
dataType: "json",
success: function (data) {
$("#selectId").fillSelect(data);
}
});
//清除選取的下拉清單
$.fn.clearSelect = function() {
return this.each(function() {
if (this.tagName == 'SELECT')
this.options.length = 0;
});
}
//將下拉選項加入下拉清單
$.fn.fillSelect = function (data, selectId) {
return this.clearSelect().each(function () {
if (this.tagName == 'SELECT') {
var dropdownList = this;
$.each(data, function (index, optionData) {
var option = new Option(optionData.Text, optionData.Value);
if ($.browser.msie) {
dropdownList.add(option);
}
else {
dropdownList.add(option, null);
}
});
}
});
}
var items = from c in contacts
select new ListItem
{
Value = SqlFunctions.StringConvert((double)c.ContactId),
Text = c.Name
};
Dim sh As Worksheet
Dim Message, Title, Default, MyValue
Message = "輸入查詢工作表名稱" ' 設定提示訊息。
Title = "查詢工作表名稱" ' 設定標題。
'Default = "1" ' 設定預設值。
ShSearch = InputBox(Message, Title, Default)
If ShSearch = "" Then Exit Sub
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each sh In Sheets
If sh.Name <> "控制" Then
If InStr(1, sh.Name, ShSearch, 1) = 0 Then
' MsgBox sh.Name & " - " & InStr(1, sh.Name, ShSeek, 1)
' sh.Visible = xlSheetVeryHidden
'隱藏工作表: Sheet1.Visible = xlSheetVeryHidden
'顯示工作表: Sheet1.Visible = xlSheetVisible
Else
Msg = "你要到該工作表嗎? - " & sh.Name ' 定義訊息。
Style = vbYesNo + vbCritical + vbDefaultButton2 ' 定義按鈕。
Title = "查詢工作表名稱" ' 定義標題。
' Help = "DEMO.HLP" ' 定義說明檔。
' Ctxt = 1000 ' 定義內容代碼。
' 顯示訊息。
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then ' 若使用者按下 [是]。
MyString = "Yes" ' 產生相對回應。
Sheets(sh.Name).Select
Exit Sub
Else ' 若使用者按下 [否]。
MyString = "No" ' 產生相對回應。
End If
End If
End If
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True
'MsgBox "完成"
< title>
< asp:ContentPlaceHolder ID="TitleContent" runat="server" />
<%: System.Web.Configuration.WebConfigurationManager.AppSettings["SiteTile"] %>
< /title>
< title>
< asp:ContentPlaceHolder ID="TitleContent" runat="server" />
< asp:Literal ID="ltlTitleBack" runat="server" Text='<%: System.Web.Configuration.WebConfigurationManager.AppSettings["SiteTile"] %>' >
< /title>
< title>
< asp:ContentPlaceHolder ID="TitleContent" runat="server" />
< asp:Literal ID="ltlTitleBack" runat="server" Text='<%$ Code: System.Web.Configuration.WebConfigurationManager.AppSettings["SiteTile"] %>' >
< /title>
using System.Web.Compilation;
using System.CodeDom;
using System.Web.UI;
//修正Literal
[System.Web.Compilation.ExpressionPrefix("Code")]
public class CodeExpressionBuilder : ExpressionBuilder
{
public override CodeExpression GetCodeExpression(BoundPropertyEntry entry,
object parsedData, ExpressionBuilderContext context)
{
return new CodeSnippetExpression(entry.Expression);
}
}
ViewContext.Controller.ValueProvider.GetValue("action").RawValue
ViewContext.Controller.ValueProvider.GetValue("controller").RawValue
ViewContext.Controller.ValueProvider.GetValue("id").RawValueViewContext.Controller.ValueProvider["controller"].RawValue
ViewContext.Controller.ValueProvider["id"].RawValue