/// <summary>
/// Clear the Query and anything related
/// </summary>
public void Clear()
{
// reset all member vars to clean state
Builder.Clear();
SelectList.Clear();
WhereMap.Clear();
QueryName = string.Empty;
AliasName = string.Empty;
QueryComment = string.Empty;
RawQuery = string.Empty;
BatchQueryList.Clear();
}
/// <summary>
/// 更新按钮点击事件
/// </summary>
/// <param name="obj"></param>
public void UpdateBtnClick(object obj)
{
if (string.IsNullOrEmpty(StartLoop.Trim()) || string.IsNullOrEmpty(EndLoop.Trim()))
{
MessageBox.Show("请输入循环数范围!");
return;
}
int startLoop = 0;
int endLoop = 0;
try
{
startLoop = Convert.ToInt32(StartLoop);
endLoop = Convert.ToInt32(EndLoop);
}
catch (Exception ex)
{
MessageBox.Show("请输入正确的循环数,整数!");
return;
}
if (SelectList != null)
{
SelectList.Clear();
}
SelectList = DataManager.Instance.SelectModelList(CheckCount, CheckValueType, startLoop, endLoop, CheckHoleName);
//设置总个数
counts = selectList.Count;
if (counts == 0)
{
Pages = 0;
CurrentPage = 0;
}
else if (counts <= pageCount)
{
Pages = 1;
CurrentPage = 1;
}
else
{
//设置总页数
Pages = counts % pageCount == 0 ? counts / pageCount : counts / pageCount + 1;
CurrentPage = 1;
}
updateView();
}
public VideoViewModel()
{
InitData();
AssignCommands();
Messenger.Default.Register <int>(this, "DVM2VVM", msg =>
{
if (msg == 0 && VideoList != null)
{
foreach (var item in VideoList)
{
item.IsChoose = -1;
}
}
if (SelectList != null && SelectList.Count > 0)
{
SelectList.Clear();
}
});
}
private void AddLines()
{
//String Sql;
SelectList.Clear();
//int NumItems = (cItems > 0 ? cItems : 1);
int NumItems = cItems;
for (int iItem = 1; iItem <= NumItems; iItem++)
{
TableRow tr = BuildFoodTableRow(iItem.ToString());
tblFood.Rows.Add(tr);
// because the previous page values are still floating around and get matched up when the row is added to the table
// we need to blank the out here
Label lbl = (Label)tr.FindControl("lblIngredSel" + iItem);
lbl.ToolTip = string.Empty;
lbl.Attributes["style"] = string.Empty;
TextBox txt = (TextBox)tr.FindControl("txtCategory" + iItem);
txt.CssClass = "FoodCategory";
txt = (TextBox)tr.FindControl("txtMenuItem" + iItem);
txt.CssClass = "MenuItem";
lbl = (Label)tr.FindControl("lblQuote" + iItem);
lbl.Text = "$0.00";
lbl = (Label)tr.FindControl("lblPrice" + iItem);
lbl.Text = "$0.00";
lbl = (Label)tr.FindControl("lblInaccuratePrice" + iItem);
lbl.Text = "";
lbl = (Label)tr.FindControl("lblExtQuote" + iItem);
lbl.Text = "$0.00";
lbl = (Label)tr.FindControl("lblExtPrice" + iItem);
lbl.Text = "$0.00";
lbl = (Label)tr.FindControl("lblOverUnder" + iItem);
lbl.Text = "0% over";
}
}
public void Clear(bool ignoreItemList)
{
_ignoreItemList = ignoreItemList;
SelectList.Clear();
}
private void AddEditLines()
{
String Sql;
SelectList.Clear();
for (int iService = 1; iService <= cServices; iService++)
{
TableRow r = new TableRow();
for (int iCell = 0; iCell < 10; iCell++)
{
r.Cells.Add(new TableCell());
}
r.Cells[0].Text = "<b>" + iService + "</b>";
HtmlInputHidden txtServiceSeq = new HtmlInputHidden();
txtServiceSeq.ID = "txtServiceSeq" + iService;
r.Cells[1].Controls.Add(txtServiceSeq);
// Remove
CheckBox chkRemove = new CheckBox();
chkRemove.ID = "chkRemove" + iService;
chkRemove.Attributes.Add("onClick", "SetDirty();");
r.Cells[2].Controls.Add(chkRemove);
r.Cells[2].HorizontalAlign = HorizontalAlign.Center;
// ServiceItem
TextBox txtServiceItem = new TextBox();
txtServiceItem.ID = "txtServiceItem" + iService;
txtServiceItem.MaxLength = 50;
txtServiceItem.CssClass = "ServiceItem";
txtServiceItem.AutoPostBack = true;
txtServiceItem.Attributes.Add("onChange", "HideDirty();");
txtServiceItem.TextChanged += new System.EventHandler(this.btnUpdate_Click);
r.Cells[4].Controls.Add(txtServiceItem);
System.Web.UI.WebControls.Image imgServiceItem = new System.Web.UI.WebControls.Image();
imgServiceItem.ID = "ddServiceItem" + iService;
imgServiceItem.ImageUrl = "Images/DropDown.gif";
imgServiceItem.BorderWidth = 0;
imgServiceItem.ImageAlign = ImageAlign.AbsMiddle;
r.Cells[4].Controls.Add(imgServiceItem);
Sql = "Select Distinct ServiceItem From mcJobServices Order By ServiceItem";
SelectList slServiceItem = new SelectList("ServiceItem" + iService, ref txtServiceItem);
slServiceItem.ImageButton(imgServiceItem);
slServiceItem.AutoPostBack = true;
slServiceItem.ClearValues();
slServiceItem.AddDBValues(db, Sql);
txtServiceItem = new TextBox();
txtServiceItem.ID = "txtOrigServiceItem" + iService;
txtServiceItem.Visible = false;
r.Cells[4].Controls.Add(txtServiceItem);
// MCC Resp
CheckBox chkMCCResp = new CheckBox();
chkMCCResp.ID = "chkMCCResp" + iService;
chkMCCResp.Attributes.Add("onClick", "SetDirty();");
r.Cells[6].Controls.Add(chkMCCResp);
r.Cells[6].HorizontalAlign = HorizontalAlign.Center;
chkMCCResp = new CheckBox();
chkMCCResp.ID = "chkOrigMCCResp" + iService;
chkMCCResp.Visible = false;
r.Cells[6].Controls.Add(chkMCCResp);
// Customer Resp
CheckBox chkCustomerResp = new CheckBox();
chkCustomerResp.ID = "chkCustomerResp" + iService;
chkCustomerResp.Attributes.Add("onClick", "SetDirty();");
r.Cells[7].Controls.Add(chkCustomerResp);
r.Cells[7].HorizontalAlign = HorizontalAlign.Center;
chkCustomerResp = new CheckBox();
chkCustomerResp.ID = "chkOrigCustomerResp" + iService;
chkCustomerResp.Visible = false;
r.Cells[7].Controls.Add(chkCustomerResp);
// Note
TextBox txtNote = new TextBox();
txtNote.ID = "txtNote" + iService;
txtNote.MaxLength = 128;
txtNote.Style.Add("width", "150px");
if (iService == cServices)
{
//txtNote.AutoPostBack = true;
txtNote.Attributes.Add("onBlur", "this.value+=' ';ClearDirty();__doPostBack('" + txtNote.ID + "','');");
txtNote.Attributes.Add("onChange", "ClearDirty();");
txtNote.TextChanged += new System.EventHandler(this.btnUpdate_Click);
}
else
{
txtNote.Attributes.Add("onChange", "SetDirty();");
}
r.Cells[9].Controls.Add(txtNote);
txtNote = new TextBox();
txtNote.ID = "txtOrigNote" + iService;
txtNote.Visible = false;
r.Cells[9].Controls.Add(txtNote);
tblServices.Rows.Add(r);
}
}
private void AddEditLines()
{
String Sql;
SelectList.Clear();
try
{
for (int iDish = 1; iDish <= cDishes; iDish++)
{
TableRow r = new TableRow();
for (int iCell = 0; iCell < 9; iCell++)
{
r.Cells.Add(new TableCell());
}
r.Cells[0].Text = "<b>" + iDish + "</b>";
HtmlInputHidden txtDishSeq = new HtmlInputHidden();
txtDishSeq.ID = "txtDishSeq" + iDish;
r.Cells[1].Controls.Add(txtDishSeq);
// Remove
CheckBox chkRemove = new CheckBox();
chkRemove.ID = "chkRemove" + iDish;
chkRemove.Attributes.Add("onClick", "SetDirty();");
r.Cells[2].Controls.Add(chkRemove);
r.Cells[2].HorizontalAlign = HorizontalAlign.Center;
// DishItem
TextBox txtDishItem = new TextBox();
txtDishItem.ID = "txtDishItem" + iDish;
txtDishItem.MaxLength = 50;
txtDishItem.CssClass = "DishItem";
txtDishItem.AutoPostBack = true;
txtDishItem.Attributes.Add("onChange", "HideDirty();");
txtDishItem.TextChanged += new System.EventHandler(this.btnUpdate_Click);
r.Cells[4].Controls.Add(txtDishItem);
System.Web.UI.WebControls.Image imgDishItem = new System.Web.UI.WebControls.Image();
imgDishItem.ID = "ddDishItem" + iDish;
imgDishItem.ImageUrl = "Images/DropDown.gif";
imgDishItem.BorderWidth = 0;
imgDishItem.ImageAlign = ImageAlign.AbsMiddle;
r.Cells[4].Controls.Add(imgDishItem);
Sql = "Select Distinct DishItem From mcJobDishes Order By DishItem";
SelectList slDishItem = new SelectList("DishItem" + iDish, ref txtDishItem);
slDishItem.ImageButton(imgDishItem);
slDishItem.AutoPostBack = true;
slDishItem.Height = 400;
slDishItem.ClearValues();
slDishItem.AddDBValues(db, Sql);
txtDishItem = new TextBox();
txtDishItem.ID = "txtOrigDishItem" + iDish;
txtDishItem.Visible = false;
r.Cells[4].Controls.Add(txtDishItem);
// Qty
TextBox txtQty = new TextBox();
txtQty.ID = "txtQty" + iDish;
txtQty.Style.Add("width", "50px");
txtQty.Attributes.Add("onChange", "SetDirty();");
r.Cells[6].Controls.Add(txtQty);
txtQty = new TextBox();
txtQty.ID = "txtOrigQty" + iDish;
txtQty.Visible = false;
r.Cells[6].Controls.Add(txtQty);
// Note
TextBox txtNote = new TextBox();
txtNote.ID = "txtNote" + iDish;
txtNote.MaxLength = 128;
txtNote.Style.Add("width", "150px");
if (iDish == cDishes)
{
//txtNote.AutoPostBack = true;
txtNote.Attributes.Add("onBlur", "this.value+=' ';ClearDirty();__doPostBack('" + txtNote.ID + "','');");
txtNote.Attributes.Add("onChange", "ClearDirty();");
txtNote.TextChanged += new System.EventHandler(this.btnUpdate_Click);
}
else
{
txtNote.Attributes.Add("onChange", "SetDirty();");
}
r.Cells[8].Controls.Add(txtNote);
txtNote = new TextBox();
txtNote.ID = "txtOrigNote" + iDish;
txtNote.Visible = false;
r.Cells[8].Controls.Add(txtNote);
tblDishes.Rows.Add(r);
}
}
catch (Exception Ex)
{
Err Err = new Err(Ex);
Response.Write(Err.Html());
}
}
private void AddLines()
{
String Sql;
SelectList.Clear();
for (int iCrew = 1; iCrew <= cCrew; iCrew++)
{
TableRow r = new TableRow();
for (int iCell = 0; iCell < 11; iCell++)
{
r.Cells.Add(new TableCell());
}
r.Cells[0].Text = "<b>" + iCrew + "</b>";
HtmlInputHidden txtCrewSeq = new HtmlInputHidden();
txtCrewSeq.ID = "txtCrewSeq" + iCrew;
r.Cells[1].Controls.Add(txtCrewSeq);
// Remove
CheckBox chkRemove = new CheckBox();
chkRemove.ID = "chkRemove" + iCrew;
chkRemove.Attributes.Add("onClick", "SetDirty();");
r.Cells[2].Controls.Add(chkRemove);
r.Cells[2].HorizontalAlign = HorizontalAlign.Center;
// CrewMember
TextBox txtCrewMember = new TextBox();
txtCrewMember.ID = "txtCrewMember" + iCrew;
txtCrewMember.MaxLength = 50;
txtCrewMember.CssClass = "CrewMember";
txtCrewMember.Attributes.Add("onChange", "SetDirty();");
r.Cells[4].Controls.Add(txtCrewMember);
System.Web.UI.WebControls.Image imgCrewMember = new System.Web.UI.WebControls.Image();
imgCrewMember.ID = "ddCrewMember" + iCrew;
imgCrewMember.ImageUrl = "Images/DropDown.gif";
imgCrewMember.BorderWidth = 0;
imgCrewMember.ImageAlign = ImageAlign.AbsMiddle;
r.Cells[4].Controls.Add(imgCrewMember);
Sql = "Select Distinct CrewMember From mcJobCrew Order By CrewMember";
SelectList slCrewMember = new SelectList("CrewMember" + iCrew, ref txtCrewMember);
slCrewMember.ImageButton(imgCrewMember);
slCrewMember.ClearValues();
slCrewMember.AddDBValues(db, Sql);
txtCrewMember = new TextBox();
txtCrewMember.ID = "txtOrigCrewMember" + iCrew;
txtCrewMember.Visible = false;
r.Cells[4].Controls.Add(txtCrewMember);
// Assignment
TextBox txtAssignment = new TextBox();
txtAssignment.ID = "txtAssignment" + iCrew;
txtAssignment.MaxLength = 50;
txtAssignment.CssClass = "Assignment";
txtAssignment.Attributes.Add("onChange", "SetDirty();");
r.Cells[6].Controls.Add(txtAssignment);
System.Web.UI.WebControls.Image imgAssignment = new System.Web.UI.WebControls.Image();
imgAssignment.ID = "ddAssignment" + iCrew;
imgAssignment.ImageUrl = "Images/DropDown.gif";
imgAssignment.BorderWidth = 0;
imgAssignment.ImageAlign = ImageAlign.AbsMiddle;
r.Cells[6].Controls.Add(imgAssignment);
Sql = "Select Distinct CrewAssignment From mcJobCrew Order By CrewAssignment";
SelectList slAssignment = new SelectList("Assignment" + iCrew, ref txtAssignment);
slAssignment.ImageButton(imgAssignment);
slAssignment.ClearValues();
slAssignment.AddDBValues(db, Sql);
txtAssignment = new TextBox();
txtAssignment.ID = "txtOrigAssignment" + iCrew;
txtAssignment.Visible = false;
r.Cells[6].Controls.Add(txtAssignment);
// Report Time
TextBox txtReportTime = new TextBox();
txtReportTime.ID = "txtReportTime" + iCrew;
txtReportTime.CssClass = "JobTime";
txtReportTime.Attributes.Add("onChange", "ValidateTime(this);SetDirty();");
r.Cells[8].Controls.Add(txtReportTime);
txtReportTime = new TextBox();
txtReportTime.ID = "txtOrigReportTime" + iCrew;
txtReportTime.Visible = false;
r.Cells[8].Controls.Add(txtReportTime);
// Note
TextBox txtNote = new TextBox();
txtNote.ID = "txtNote" + iCrew;
txtNote.MaxLength = 128;
txtNote.Style.Add("width", "150px");
if (iCrew == cCrew)
{
//txtNote.AutoPostBack = true;
txtNote.Attributes.Add("onBlur", "this.value+=' ';ClearDirty();__doPostBack('" + txtNote.ID + "','');");
txtNote.Attributes.Add("onChange", "ClearDirty();");
txtNote.TextChanged += new System.EventHandler(this.btnUpdate_Click);
}
else
{
txtNote.Attributes.Add("onChange", "SetDirty();");
}
r.Cells[10].Controls.Add(txtNote);
txtNote = new TextBox();
txtNote.ID = "txtOrigNote" + iCrew;
txtNote.Visible = false;
r.Cells[10].Controls.Add(txtNote);
tblCrew.Rows.Add(r);
}
}
