本文整理汇总了C#中Criteria.And方法的典型用法代码示例。如果您正苦于以下问题:C# Criteria.And方法的具体用法?C# Criteria.And怎么用?C# Criteria.And使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Criteria
的用法示例。
在下文中一共展示了Criteria.And方法的8个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: QuickSearch
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<ActionLog>(session).Page(pagesize, pageno)
.Asc(m => m.CreatedAt).AddOrder(collection, ViewData);
if (collection != null)
{
if (collection.AllKeys.Contains("starttime"))
{
var dtStr = (collection["starttime"] + string.Empty).Trim();
if (!string.IsNullOrEmpty(dtStr))
{
DateTime startAt;
if (DateTime.TryParse(dtStr, out startAt))
{
q.And(m => m.CreatedAt >= startAt);
}
}
}
if (collection.AllKeys.Contains("endtime"))
{
var dtStr = (collection["endtime"] + string.Empty).Trim();
if (!string.IsNullOrEmpty(dtStr))
{
DateTime endAt;
if (DateTime.TryParse(dtStr, out endAt))
{
q.And(m => m.CreatedAt <= endAt);
}
}
}
if (collection.AllKeys.Contains("keywords"))
{
var keywords = (collection["keywords"] + string.Empty).Trim();
if (!string.IsNullOrEmpty(keywords))
{
q.And(m => m.Actor.Include(keywords), m => m.Category.Include(keywords),
m => m.Title.Include(keywords), m => m.Description.Include(keywords),
m => m.Result.Include(keywords));
}
}
}
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
示例2: AllSchoolSectionList
public static SelectList AllSchoolSectionList()
{
var q = new Criteria<Department>();
q.And(m => m.Type.Equals(DeparmentTypeList.Section));
var d = q.Find();
d.Insert(0, new Department { Id = 0, Name = "全部" });
return new SelectList(d, "Id", "Name");
}
示例3: QuickSearch
public ActionResult QuickSearch(FormCollection collection, long id = 0, uint pagesize = DefaultPageSize, uint pageno = 1)
{
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<PunishmentDossierFiles>(session).Page(pagesize, pageno).Asc(m => m.Id).AddOrder(collection, ViewData);
q.And(m => m.ParentId == id);
if (collection != null && collection.AllKeys.Contains("keywords"))
{
var keywords = (collection["keywords"] + string.Empty).Trim();
if (!string.IsNullOrEmpty(keywords))
{
}
}
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
示例4: QuickSearch
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<School>(session).Page(pagesize, pageno).Asc(m => m.Id).AddOrder(collection, ViewData);
if (collection != null && collection.AllKeys.Contains("keywords"))
{
var keywords = (collection["keywords"] + string.Empty).Trim();
if (!string.IsNullOrEmpty(keywords))
{
q.And(m => m.Name.Include(keywords), m => m.Address.Include(keywords), m => m.LeaderName.Include(keywords));
}
}
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
示例5: btnRegister_Click
protected void btnRegister_Click(object sender, EventArgs e)
{
mvMessage.CheckRequired(txtUserName, "Tên Người Dùng(User Name): Mục Bắt Buộc");
mvMessage.CheckRequired(txtFullName, "Họ Tên: ): Mục Bắt Buộc");
//mvMessage.CheckRequired(txtEmail, "Emailを正しく入力してください。");
if (!mvMessage.IsValid) return;
if (btnRegister.CommandName == "Edit")
{
//if (txtConfirm.Text != String.Empty || txtPassword.Text != String.Empty)
//{
// if (txtPassword.Text != txtConfirm.Text)
// {
// mvMessage.AddError("パスワードが一致していません。");
// return;
// }
// if (!mvMessage.IsValid) return;
//}
aspnet_MembershipData data = new aspnet_MembershipData();
Criteria cri = new Criteria();
MembershipUser user = Membership.GetUser(UserName);
cri.And("UserId", "=", user.ProviderUserKey.ToString());
ITransaction tran = factory.GetSearchObject(data, cri);
Execute(tran);
data = (aspnet_MembershipData)(((System.Collections.ArrayList)tran.Result)[0]);
user.IsApproved = chkActive.Checked;
user.Email = txtEmail.Text.ToString().Trim();
try
{
string[] roles = Roles.GetRolesForUser(UserName);
bool isExist = false;
for (int i = 0; i < roles.Length; i++)
{
if (ddlRolesList.SelectedValue == roles[i])
{
isExist = true;
break;
}
}
if (!isExist)
{
if (roles.Length > 0)
{
Roles.RemoveUserFromRoles(UserName, roles);
}
Roles.AddUserToRole(UserName, ddlRolesList.SelectedValue);
}
}
catch (Exception ex)
{
ApplicationLog.WriteError(ex);
}
//if (txtPassword.Text != String.Empty)
//{
// try
// {
// string pass = user.ResetPassword();
// txtPassReset.Text = pass;
// //if (!user.ChangePassword(pass, txtPassword.Text))
// //{
// // mvMessage.AddError("エラーが発生しました。");
// // return;
// //}
// }
// catch
// {
// mvMessage.AddError("変更パスワード中エラーが発生しました。");
// }
//}
user.IsApproved = chkActive.Checked;
user.Email = txtEmail.Text.ToString().Trim();
Membership.UpdateUser(user);
//if( cbManagement.Checked == true)
// data.SaleUserFlag = "1";
//else
// data.SaleUserFlag = "0";
//if (cbInputer.Checked == true)
// data.InChargeUserFlag = "1";
//else
// data.InChargeUserFlag = "0";
string plainQuery = String.Format("UPDATE [aspnet_Membership] SET [FullName] = '{0}', BuildingId = '{1}' WHERE [UserID] = '{2}';", txtFullName.Text.Trim(), Func.ParseString(Session["__BUILDINGID__"]), user.ProviderUserKey.ToString());
SqlDatabase db = new SqlDatabase();
int Modifieditem = db.ExecuteNonQuery(plainQuery);
if (Modifieditem == 0)
{
Membership.DeleteUser(txtUserName.Text.Trim());
OperationLogger.WriteError(Constants.LogOperationUserId, Constants.LogActionUpdateId, "Lỗi Phát Sinh", Page.User.Identity.Name);
mvMessage.AddError("Lỗi Phát Sinh");
}
//.........这里部分代码省略.........
示例6: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
UserName = Request["UserName"];
Action = Request["Action"];
if (!IsPostBack)
{
if (Action == "Edit")
{
lblHeader.Text = "Thông Tin Người Dùng";
btnRegister.Text = "Cập Nhật";
btnRegister.CommandName = "Edit";
ltrNotice.Visible = false;
trPassReset.Visible = true;
trPass.Visible = false;
trPassConfirm.Visible = false;
btnReset.Attributes.Add("onclick", "return confirm('Phát sinh lại Mật Khẩu');");
lblOldPassword.Text = "Mật Khẩu Mới";
lblPassword.Text = "Xác Nhận Mật Khẩu";
if (!IsPostBack)
{
txtUserName.Text = UserName;
txtUserName.ReadOnly = true;
aspnet_MembershipData data = new aspnet_MembershipData();
Criteria cri = new Criteria();
MembershipUser user = Membership.GetUser(UserName);
cri.And("UserId", "=", user.ProviderUserKey.ToString());
ITransaction tran = factory.GetSearchObject(data, cri);
Execute(tran);
if (tran.Result != null)
if (((System.Collections.ArrayList)tran.Result).Count > 0)
data = (aspnet_MembershipData)(((System.Collections.ArrayList)tran.Result)[0]);
txtFullName.Text = data.FullName;
txtEmail.Text = user.Email;
//ddlRolesList.DataSource = Roles.GetAllRoles();
//ddlRolesList.DataBind();
DbHelper.FillList(ddlRolesList, "Select * from Mst_Roles Where delFlag = '0'", "RoleName", "RoleId");
//DbHelper.FillList(drpBuilding, "Select Name as BD_Name, BuildingId from Mst_Building", "BD_Name", "BuildingId");
//if (data.SaleUserFlag == "1")
// cbManagement.Checked = true;
//if (data.InChargeUserFlag == "1")
// cbInputer.Checked = true;
//if(Roles.GetRolesForUser(UserName).Length != 0)
DbHelper.FillList(ddlRolesList, "Select * from Mst_Roles Where RoleId not in (Select RoleId from Mst_UserInRoles Where Username = '" + txtUserName.Text + "')", "RoleName", "RoleId");
DbHelper.FillList(lstSelectedRole, "Select * from Mst_Roles Where RoleId in (Select RoleId from Mst_UserInRoles Where Username = '" + txtUserName.Text + "')", "RoleName", "RoleId");
chkActive.Checked = user.IsApproved;
}
}
else // Add new case
{
//DbHelper.FillList(drpBuilding, "Select Name as BD_Name, BuildingId from Mst_Building Where delFlag = '0'and BuildingId in ('" + Func.ParseString(Session["__BUILDINGID__"]) + "')", "BD_Name", "BuildingId");
//DbHelper.FillList(ddlRolesList, "Select * from Mst_Roles Where delFlag = '0'", "RoleName", "RoleId");
DbHelper.FillList(ddlRolesList, "Select * from Mst_Roles Where RoleId not in (Select RoleId from Mst_UserInRoles Where Username = '" + txtUserName.Text + "')", "RoleName", "RoleId");
lblHeader.Text = "Thông Tin Người Dùng";
trPassReset.Visible = false;
trPass.Visible = true;
trPassConfirm.Visible = true;
btnRegister.Text = "Thêm Mới";
ltrNotice.Visible = true;
ltrNotice.Text = "";
//if (!IsPostBack)
//{
// ddlRolesList.DataSource = Roles.GetAllRoles();
// ddlRolesList.DataBind();
//}
}
}
}
示例7: QuickSearch
public ActionResult QuickSearch(FormCollection collection, uint pagesize = DefaultPageSize, uint pageno = 1)
{
var keywords = GetDbQueryPara();
using (var session = new SessionFactory().OpenSession())
{
var q = new Criteria<StandardFile>(session).Page(pagesize, pageno).Asc(m => m.Id).AddOrder(collection, ViewData);
if (!IsAdmin() && IsInchargeLeader())
{
q.And(m => m.State.Equals(StandardFileStateConst.分管领导审批));
}
else if (!IsAdmin() && IsLeader())
{
q.And(m => m.State.Equals(StandardFileStateConst.法规部门负责人审核));
}
q.AndUnless(string.IsNullOrEmpty(keywords),
m => m.OriginName.Include(keywords),
m => m.FileType.Include(keywords),
m => m.Creator.Include(keywords),
m => m.Description.Include(keywords),
m => m.Memo.Include(keywords),
m => m.State.Include(keywords),
m => m.ApproveState.Include(keywords))
;
var models = q.Find().PartPage(pageno, pagesize, q.Count());
return View(models);
}
}
示例8: SchoolSectionList
/// <summary>
/// 选择校区
/// </summary>
/// <returns></returns>
public static SelectList SchoolSectionList(SelectMode mode = SelectMode.Default)
{
var q = new Criteria<Department>();
q.And(m => m.Type.Equals(DeparmentTypeList.Section));
var d = q.Find();
return SelectList(d, "Id", "Name", mode);
}