protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtName_Search.Text))
{
es.AddSearchCodition("Name", txtName_Search.Text, "like");
}
if (ddlArea_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Area", ddlArea_Search.SelectedItem.Text, "like");
}
if (ddlFactory_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Factory", ddlFactory_Search.SelectedItem.Text, "like");
}
if (ddlSection_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Section", ddlSection_Search.SelectedItem.Text, "like");
}
if (!String.IsNullOrEmpty(txtJobDate_begin.Text))
{
String endDate = DateTime.Today.ToString();
if (!String.IsNullOrEmpty(txtJobDate_end.Text))
{
endDate = txtJobDate_end.Text;
}
String dateFilter = String.Format(@"jobDate between '{0}' and '{1}'", txtJobDate_begin.Text, endDate);
String filter = es.Where;
if (filter != "")
{
filter = filter + " and " + dateFilter;
}
else
{
filter = dateFilter;
}
Filter = filter;
}
else
{
Filter = es.Where;
}
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtcode_Search.Text))
{
es.AddSearchCodition("code", txtcode_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtdescription_Search.Text))
{
es.AddSearchCodition("description", txtdescription_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtno1_Search.Text))
{
es.AddSearchCodition("no1", txtno1_Search.Text, "=");
}
Filter = es.Where;
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtJobDate_Search.Text))
{
es.AddSearchCodition("JobDate", txtJobDate_Search.Text, "like");
}
if (!String.IsNullOrEmpty(txtTrainCode_Search.Text))
{
es.AddSearchCodition("TrainCode", txtTrainCode_Search.Text, "like");
}
if (!String.IsNullOrEmpty(txtName_Search.Text))
{
es.AddSearchCodition("Name", txtName_Search.Text, "like");
}
if (ddlCheckType_Search.SelectedIndex > 0)
{
es.AddSearchCodition("CheckType", ddlCheckType_Search.SelectedValue, "like");
}
if (ddlArea_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Area", ddlArea_Search.SelectedValue, "like");
}
if (ddlFactory_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Factory", ddlFactory_Search.SelectedValue, "like");
}
if (ddlSection_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Section", ddlSection_Search.SelectedValue, "like");
}
Filter = es.Where;
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtUserName_Search.Text))
{
es.AddSearchCodition("UserName", txtUserName_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtUserNo_Search.Text))
{
es.AddSearchCodition("UserNo", txtUserNo_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtName_Search.Text))
{
es.AddSearchCodition("Name", txtName_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtDepartment_Search.Text))
{
es.AddSearchCodition("Department", txtDepartment_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtPassword_Search.Text))
{
es.AddSearchCodition("Password", txtPassword_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtIsActive_Search.Text))
{
es.AddSearchCodition("IsActive", txtIsActive_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtExpirtationDate_Search.Text))
{
es.AddSearchCodition("ExpirtationDate", txtExpirtationDate_Search.Text, "=");
}
Filter = es.Where;
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtArea_Search.Text))
{
es.AddSearchCodition("Area", txtArea_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtFactory_Search.Text))
{
es.AddSearchCodition("Factory", txtFactory_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtSection_Search.Text))
{
es.AddSearchCodition("Section", txtSection_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtCode_Search.Text))
{
es.AddSearchCodition("Code", txtCode_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtTrainCode_Search.Text))
{
es.AddSearchCodition("TrainCode", txtTrainCode_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtAlias_Search.Text))
{
es.AddSearchCodition("Alias", txtAlias_Search.Text, "=");
}
Filter = es.Where;
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtName_Search.Text))
{
es.AddSearchCodition("Name", txtName_Search.Text, "like");
}
if (ddlArea_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Area", ddlArea_Search.SelectedItem.Text, "like");
}
if (ddlFactory_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Factory", ddlFactory_Search.SelectedItem.Text, "like");
}
if (ddlSection_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Section", ddlSection_Search.SelectedItem.Text, "like");
}
if (!String.IsNullOrEmpty(txtJobDate_begin.Text))
{
String endDate = DateTime.Today.ToString();
if (!String.IsNullOrEmpty(txtJobDate_end.Text))
{
endDate = txtJobDate_end.Text;
}
String dateFilter=String.Format(@"jobDate between '{0}' and '{1}'",txtJobDate_begin.Text,endDate);
String filter = es.Where;
if (filter != "")
{
filter = filter+" and " + dateFilter;
}
else {
filter = dateFilter;
}
Filter = filter;
}
else
{
Filter = es.Where;
}
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtArea_Search.Text))
{
es.AddSearchCodition("Area", txtArea_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtFactory_Search.Text))
{
es.AddSearchCodition("Factory", txtFactory_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtSection_Search.Text))
{
es.AddSearchCodition("Section", txtSection_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtCode_Search.Text))
{
es.AddSearchCodition("Code", txtCode_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtTrainCode_Search.Text))
{
es.AddSearchCodition("TrainCode", txtTrainCode_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtAlias_Search.Text))
{
es.AddSearchCodition("Alias", txtAlias_Search.Text, "=");
}
Filter = es.Where;
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtCheckDetail_Search.Text))
{
es.AddSearchCodition("CheckDetail",txtCheckDetail_Search.Text,"=");
}
if (!String.IsNullOrEmpty(txtCheckMethod_Search.Text))
{
es.AddSearchCodition("CheckMethod",txtCheckMethod_Search.Text,"=");
}
if (!String.IsNullOrEmpty(txtSpecifiedSizeHeight_Search.Text))
{
es.AddSearchCodition("SpecifiedSizeHeight",txtSpecifiedSizeHeight_Search.Text,"=");
}
if (!String.IsNullOrEmpty(txtKnockPosition_Search.Text))
{
es.AddSearchCodition("KnockPosition",txtKnockPosition_Search.Text,"=");
}
Filter = es.Where;
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtcode_Search.Text))
{
es.AddSearchCodition("code", txtcode_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtdescription_Search.Text))
{
es.AddSearchCodition("description", txtdescription_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtno1_Search.Text))
{
es.AddSearchCodition("no1", txtno1_Search.Text, "=");
}
Filter = es.Where;
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtUserName_Search.Text))
{
es.AddSearchCodition("UserName", txtUserName_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtUserNo_Search.Text))
{
es.AddSearchCodition("UserNo", txtUserNo_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtName_Search.Text))
{
es.AddSearchCodition("Name", txtName_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtDepartment_Search.Text))
{
es.AddSearchCodition("Department", txtDepartment_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtPassword_Search.Text))
{
es.AddSearchCodition("Password", txtPassword_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtIsActive_Search.Text))
{
es.AddSearchCodition("IsActive", txtIsActive_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtExpirtationDate_Search.Text))
{
es.AddSearchCodition("ExpirtationDate", txtExpirtationDate_Search.Text, "=");
}
Filter = es.Where;
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtJobDate_Search.Text))
{
es.AddSearchCodition("JobDate", txtJobDate_Search.Text, "like");
}
if (!String.IsNullOrEmpty(txtTrainCode_Search.Text))
{
es.AddSearchCodition("TrainCode", txtTrainCode_Search.Text, "like");
}
if (!String.IsNullOrEmpty(txtName_Search.Text))
{
es.AddSearchCodition("Name", txtName_Search.Text, "like");
}
if (ddlCheckType_Search.SelectedIndex > 0)
{
es.AddSearchCodition("CheckType", ddlCheckType_Search.SelectedValue, "like");
}
if (ddlArea_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Area", ddlArea_Search.SelectedValue, "like");
}
if (ddlFactory_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Factory", ddlFactory_Search.SelectedValue, "like");
}
if (ddlSection_Search.SelectedIndex > 0)
{
es.AddSearchCodition("Section", ddlSection_Search.SelectedValue, "like");
}
Filter = es.Where;
BindData();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
EntitySearch es = new EntitySearch(_Entity);
if (!String.IsNullOrEmpty(txtSection_Search.Text))
{
es.AddSearchCodition("Section", txtSection_Search.Text, "like");
}
if (!String.IsNullOrEmpty(txtSequence_Search.Text))
{
es.AddSearchCodition("Sequence", txtSequence_Search.Text, "=");
}
if (!String.IsNullOrEmpty(txtCheckPosition_Search.Text))
{
es.AddSearchCodition("CheckPosition", txtCheckPosition_Search.Text, "like");
}
if (!String.IsNullOrEmpty(txtCheckMethod_Search.Text))
{
es.AddSearchCodition("CheckMethod", txtCheckMethod_Search.Text, "like");
}
if (!String.IsNullOrEmpty(txtBarCode_Search.Text))
{
es.AddSearchCodition("BarCode", txtBarCode_Search.Text, "like");
}
Filter = es.Where;
BindData();
}