/// <summary> /// 更新快件状态 /// </summary> /// <param name="dt"></param> /// <returns></returns> private int GetOrderState(DataTable dt, ref Express.Model.OrderInfo model) { if (null == dt || dt.Rows.Count < 1) { model.Remark = "未签收"; return(3);//未签收 } switch (dt.Rows[dt.Rows.Count - 1][2].ToString()) { case "签收": case "代签收扫描": return(1); break; case "异常签收": string exmsg = dt.Rows[dt.Rows.Count - 1][3].ToString(); if (exmsg.IndexOf("备注:") > 0) { model.Remark = exmsg.Substring(exmsg.IndexOf("备注:") + 3); } return(2); break; default: break; } return(3); }
private void btnOk_Click(object sender, EventArgs e) { if (ddlCustomer.SelectedIndex >= 0) { string[] infos = txtOrderNumber.Text.Trim().Replace(" ", "").Replace("\r", "").Split('\n'); List <string> orders = new List <string>(); for (int i = 0; i < infos.Length; i++) { if (!CheckIsExistsOrder(orders, infos[i])) { orders.Add(infos[i]); } } for (int i = 0; i < orders.Count; i++) { Express.Model.OrderInfo orderInfo = new Express.Model.OrderInfo(); orderInfo.CustomerID = Convert.ToInt32(ddlCustomer.SelectedValue); orderInfo.SalesmanID = Convert.ToInt32(ddlSaleMan.SelectedValue); orderInfo.OrderNo = orders[i]; orderInfo.Daterecived = dtpReciveDate.Value; orderInfo.Contractdate = orderInfo.Daterecived; orderInfo.OperUser = ClientInfo.Sys_UserInfo.username; orderInfo.UserDate = DateTime.Now; new Express.BLL.OrderInfo().Add(orderInfo); } txtOrderNumber.Text = ""; } else { MessageBox.Show("没有客户信息,请先增加客户!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } this.DialogResult = System.Windows.Forms.DialogResult.OK; }
private void SetOrderInfo(Express.Model.OrderInfo model) { for (int i = 0; i < gvInfo.Rows.Count; i++) { if (gvInfo.Rows[i].Cells[0].Value.ToString() == model.Id.ToString()) { TotalProcessRecord++; gvInfo.Rows[i].Cells[6].Value = model.Reciver; gvInfo.Rows[i].Cells[7].Value = model.Tel; gvInfo.Rows[i].Cells[8].Value = model.Provice; gvInfo.Rows[i].Cells[9].Value = model.City; gvInfo.Rows[i].Cells[10].Value = model.Area; gvInfo.Rows[i].Cells[11].Value = model.Address; gvInfo.Rows[i].Cells[12].Value = model.Remark; Color foreColor = Color.Black; gvInfo.Rows[i].Cells[13].Value = ConvertOrderState(model.OState, ref foreColor); gvInfo.Rows[i].Cells[14].Value = model.OState; if (model.OState > 0 && model.OState < 3) { gvInfo.Rows[i].Cells[15].Value = model.Contractdate.Value; gvInfo.Rows[i].Cells[16].Value = model.Contractor; } gvInfo.Rows[i].Cells[17].Value = GetORSate(model.ORState); this.gvInfo.Rows[i].DefaultCellStyle.ForeColor = foreColor; if (preRow != null) { preRow.Selected = false; } gvInfo.Rows[i].Selected = true; preRow = gvInfo.Rows[i]; gvInfo.FirstDisplayedScrollingRowIndex = i; Express.Model.SendOrderInfo newModel = new Express.BLL.SendOrderInfo().GetModel(model.Id); newModel.Tel = model.Tel; newModel.Provice = model.Provice; newModel.City = model.City; newModel.Area = model.Area; newModel.Address = model.Address; newModel.Reciver = model.Reciver; newModel.Remark = model.Remark; newModel.OState = model.OState; newModel.ORState = model.ORState; newModel.Merchandiser = model.Merchandiser; if (model.OState > 0 && model.OState < 3) { newModel.Contractor = model.Contractor; newModel.Contractdate = model.Contractdate; } new Express.BLL.SendOrderInfo().Update(newModel); break; } } if (anpageinfo.PageIndex == int.Parse(anpageinfo.Tag.ToString()) && RowIndex == gvInfo.Rows.Count && btnQuickSearch.Tag.ToString() == "1") { StopAutoCheck(); } }
/// <summary> /// 初始化订单信息 /// </summary> /// <param name="model"></param> public void InitialOrderPageInfo(Express.Model.OrderInfo model) { try { nowOrder = model; } catch (Exception) { } }
private void gvInfo_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0 && e.ColumnIndex >= 0) { Express.Model.OrderInfo model = new Express.Model.OrderInfo(); model.OrderNo = gvInfo.Rows[e.RowIndex].Cells[2].Value.ToString(); model.Id = Convert.ToInt32(gvInfo.Rows[e.RowIndex].Cells[0].Value); processmodel.Process(model); processmodel.OpenView(model); } }
private void CommiteInfo() { if (null != dele_GetOrder) { nowOrder = dele_GetOrder(); if (nowOrder != null) { InitialOrderPageInfo(nowOrder); } } }
private void gvInfo_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1 && e.ColumnIndex != -1) { Express.Model.OrderInfo model = new Express.Model.OrderInfo(); model.OrderNo = gvInfo.Rows[e.RowIndex].Cells[2].Value.ToString(); model.Id = Convert.ToInt32(gvInfo.Rows[e.RowIndex].Cells[0].Value); OrderPageForm.ThisForm.uc_CatchInfo1.dele_SetOrder = SetOrderInfo; OrderPageForm.ThisForm.uc_CatchInfo1.InitialOrderPageInfo(model); OrderPageForm.ThisForm.Show(); } }
private void ProcessData() { DataTable dt = new Express.BLL.OrderView().GetList(autosearch).Tables[0]; TotalProcessRecord = dt.Rows.Count; foreach (DataRow item in dt.Rows) { Express.Model.OrderInfo model = new Express.Model.OrderInfo(); model.OrderNo = item["orderno"].ToString(); model.Id = int.Parse(item["id"].ToString()); processmodel.Process(model); SetprocessState(); } StopAutoCheck(); }
private void SetOrderInfo(Express.Model.OrderInfo model) { //for (int i = 0; i < gvInfo.Rows.Count; i++) //{ // if(gvInfo.Rows[i].Cells[0].Value.ToString()==model.Id.ToString()) // { // TotalProcessRecord++; // gvInfo.Rows[i].Cells[6].Value = model.Reciver; // gvInfo.Rows[i].Cells[7].Value = model.Tel; // gvInfo.Rows[i].Cells[8].Value = model.Provice; // gvInfo.Rows[i].Cells[9].Value = model.City; // gvInfo.Rows[i].Cells[10].Value = model.Area; // gvInfo.Rows[i].Cells[11].Value = model.Address; // gvInfo.Rows[i].Cells[12].Value = model.Remark; // Color foreColor = Color.Black; // gvInfo.Rows[i].Cells[13].Value = ConvertOrderState(model.OState, ref foreColor); // gvInfo.Rows[i].Cells[14].Value = model.OState; // if (model.OState > 0 && model.OState < 3) // { // gvInfo.Rows[i].Cells[15].Value = model.Contractdate.Value; // gvInfo.Rows[i].Cells[16].Value = model.Contractor; // } // gvInfo.Rows[i].Cells[17].Value = GetORSate(model.ORState); // gvInfo.Rows[i].Cells[18].Value =model.Paream1; // gvInfo.Rows[i].Cells[20].Value = model.Paream8 * 1m / 100M; // this.gvInfo.Rows[i].DefaultCellStyle.ForeColor = foreColor; // if (preRow != null) // preRow.Selected = false; // gvInfo.Rows[i].Selected = true; // preRow = gvInfo.Rows[i]; // gvInfo.FirstDisplayedScrollingRowIndex = i; // break; // } //} //if (anpageinfo.PageIndex == int.Parse(anpageinfo.Tag.ToString()) && RowIndex == gvInfo.Rows.Count && btnQuickSearch.Tag.ToString() == "1") //{ // StopAutoCheck(); //} //else //{ // processmodel.Process(GetOrderInfo()); //} }
/// <summary> /// 获取订单信息 /// </summary> /// <returns></returns> private Express.Model.OrderInfo GetOrderInfo() { try { CheckSelectedRow(); if (gvInfo.Rows.Count > RowIndex)//达到一页数据的最大 { Express.Model.OrderInfo model = new Express.Model.OrderInfo(); model.OrderNo = gvInfo.Rows[RowIndex].Cells[2].Value.ToString(); model.Id = Convert.ToInt32(gvInfo.Rows[RowIndex].Cells[0].Value); RowIndex++; return(model); } } catch (Exception) { } return(null); }
/// <summary> /// 得到一个对象实体 /// </summary> public Express.Model.OrderInfo GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from OrderInfo "); strSql.Append(" where Id=@Id"); OleDbParameter[] parameters = { new OleDbParameter("@Id", OleDbType.Integer, 4) }; parameters[0].Value = Id; Express.Model.OrderInfo model = new Express.Model.OrderInfo(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Express.Model.OrderInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrderInfo("); strSql.Append("OrderNo,Daterecived,SalesmanID,CustomerID,Tel,Provice,City,Area,Address,Reciver,Remark,Contractor,Contractdate,OState,Merchandiser,UserDate,OperUser,ORState,Paream0,Paream1,Paream2,Paream3,Paream4,Paream5,Paream6,Paream7,Paream8,Paream9,Paream10,Paream11,Paream12,Paream13,Paream14,Paream15,Paream16,Paream17,Paream18,Paream19,Paream20)"); strSql.Append(" values ("); strSql.Append("@OrderNo,@Daterecived,@SalesmanID,@CustomerID,@Tel,@Provice,@City,@Area,@Address,@Reciver,@Remark,@Contractor,@Contractdate,@OState,@Merchandiser,@UserDate,@OperUser,@ORState,@Paream0,@Paream1,@Paream2,@Paream3,@Paream4,@Paream5,@Paream6,@Paream7,@Paream8,@Paream9,@Paream10,@Paream11,@Paream12,@Paream13,@Paream14,@Paream15,@Paream16,@Paream17,@Paream18,@Paream19,@Paream20)"); OleDbParameter[] parameters = { new OleDbParameter("@OrderNo", OleDbType.VarChar, 30), new OleDbParameter("@Daterecived", OleDbType.Date), new OleDbParameter("@SalesmanID", OleDbType.Integer, 4), new OleDbParameter("@CustomerID", OleDbType.Integer, 4), new OleDbParameter("@Tel", OleDbType.VarChar, 30), new OleDbParameter("@Provice", OleDbType.VarChar, 30), new OleDbParameter("@City", OleDbType.VarChar, 30), new OleDbParameter("@Area", OleDbType.VarChar, 30), new OleDbParameter("@Address", OleDbType.VarChar, 200), new OleDbParameter("@Reciver", OleDbType.VarChar, 10), new OleDbParameter("@Remark", OleDbType.VarChar, 100), new OleDbParameter("@Contractor", OleDbType.VarChar, 20), new OleDbParameter("@Contractdate", OleDbType.Date), new OleDbParameter("@OState", OleDbType.Integer, 4), new OleDbParameter("@Merchandiser", OleDbType.Integer, 4), new OleDbParameter("@UserDate", OleDbType.Date), new OleDbParameter("@OperUser", OleDbType.VarChar, 20), new OleDbParameter("@ORState", OleDbType.Integer, 4), new OleDbParameter("@Paream0", OleDbType.VarChar, 255), new OleDbParameter("@Paream1", OleDbType.VarChar, 255), new OleDbParameter("@Paream2", OleDbType.VarChar, 255), new OleDbParameter("@Paream3", OleDbType.VarChar, 0), new OleDbParameter("@Paream4", OleDbType.VarChar, 255), new OleDbParameter("@Paream5", OleDbType.Integer, 4), new OleDbParameter("@Paream6", OleDbType.Integer, 4), new OleDbParameter("@Paream7", OleDbType.Integer, 4), new OleDbParameter("@Paream8", OleDbType.Integer, 4), new OleDbParameter("@Paream9", OleDbType.VarChar, 0), new OleDbParameter("@Paream10", OleDbType.VarChar, 0), new OleDbParameter("@Paream11", OleDbType.VarChar, 0), new OleDbParameter("@Paream12", OleDbType.VarChar, 0), new OleDbParameter("@Paream13", OleDbType.VarChar, 0), new OleDbParameter("@Paream14", OleDbType.VarChar, 0), new OleDbParameter("@Paream15", OleDbType.VarChar, 0), new OleDbParameter("@Paream16", OleDbType.VarChar, 0), new OleDbParameter("@Paream17", OleDbType.VarChar, 0), new OleDbParameter("@Paream18", OleDbType.VarChar, 0), new OleDbParameter("@Paream19", OleDbType.VarChar, 0), new OleDbParameter("@Paream20", OleDbType.VarChar, 0) }; parameters[0].Value = model.OrderNo; parameters[1].Value = model.Daterecived; parameters[2].Value = model.SalesmanID; parameters[3].Value = model.CustomerID; parameters[4].Value = model.Tel; parameters[5].Value = model.Provice; parameters[6].Value = model.City; parameters[7].Value = model.Area; parameters[8].Value = model.Address; parameters[9].Value = model.Reciver; parameters[10].Value = model.Remark; parameters[11].Value = model.Contractor; parameters[12].Value = model.Contractdate; parameters[13].Value = model.OState; parameters[14].Value = model.Merchandiser; parameters[15].Value = model.UserDate; parameters[16].Value = model.OperUser; parameters[17].Value = model.ORState; parameters[18].Value = model.Paream0; parameters[19].Value = model.Paream1; parameters[20].Value = model.Paream2; parameters[21].Value = model.Paream3; parameters[22].Value = model.Paream4; parameters[23].Value = model.Paream5; parameters[24].Value = model.Paream6; parameters[25].Value = model.Paream7; parameters[26].Value = model.Paream8; parameters[27].Value = model.Paream9; parameters[28].Value = model.Paream10; parameters[29].Value = model.Paream11; parameters[30].Value = model.Paream12; parameters[31].Value = model.Paream13; parameters[32].Value = model.Paream14; parameters[33].Value = model.Paream15; parameters[34].Value = model.Paream16; parameters[35].Value = model.Paream17; parameters[36].Value = model.Paream18; parameters[37].Value = model.Paream19; parameters[38].Value = model.Paream20; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Express.Model.OrderInfo DataRowToModel(DataRow row) { Express.Model.OrderInfo model = new Express.Model.OrderInfo(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["OrderNo"] != null) { model.OrderNo = row["OrderNo"].ToString(); } if (row["Daterecived"] != null && row["Daterecived"].ToString() != "") { model.Daterecived = DateTime.Parse(row["Daterecived"].ToString()); } if (row["SalesmanID"] != null && row["SalesmanID"].ToString() != "") { model.SalesmanID = int.Parse(row["SalesmanID"].ToString()); } if (row["CustomerID"] != null && row["CustomerID"].ToString() != "") { model.CustomerID = int.Parse(row["CustomerID"].ToString()); } if (row["Tel"] != null) { model.Tel = row["Tel"].ToString(); } if (row["Provice"] != null) { model.Provice = row["Provice"].ToString(); } if (row["City"] != null) { model.City = row["City"].ToString(); } if (row["Area"] != null) { model.Area = row["Area"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["Reciver"] != null) { model.Reciver = row["Reciver"].ToString(); } if (row["Remark"] != null) { model.Remark = row["Remark"].ToString(); } if (row["Contractor"] != null) { model.Contractor = row["Contractor"].ToString(); } if (row["Contractdate"] != null && row["Contractdate"].ToString() != "") { model.Contractdate = DateTime.Parse(row["Contractdate"].ToString()); } if (row["OState"] != null && row["OState"].ToString() != "") { model.OState = int.Parse(row["OState"].ToString()); } if (row["Merchandiser"] != null && row["Merchandiser"].ToString() != "") { model.Merchandiser = int.Parse(row["Merchandiser"].ToString()); } if (row["UserDate"] != null && row["UserDate"].ToString() != "") { model.UserDate = DateTime.Parse(row["UserDate"].ToString()); } if (row["OperUser"] != null) { model.OperUser = row["OperUser"].ToString(); } if (row["ORState"] != null && row["ORState"].ToString() != "") { model.ORState = int.Parse(row["ORState"].ToString()); } if (row["Paream0"] != null) { model.Paream0 = row["Paream0"].ToString(); } if (row["Paream1"] != null) { model.Paream1 = row["Paream1"].ToString(); } if (row["Paream2"] != null) { model.Paream2 = row["Paream2"].ToString(); } if (row["Paream3"] != null) { model.Paream3 = row["Paream3"].ToString(); } if (row["Paream4"] != null) { model.Paream4 = row["Paream4"].ToString(); } if (row["Paream5"] != null && row["Paream5"].ToString() != "") { model.Paream5 = int.Parse(row["Paream5"].ToString()); } if (row["Paream6"] != null && row["Paream6"].ToString() != "") { model.Paream6 = int.Parse(row["Paream6"].ToString()); } if (row["Paream7"] != null && row["Paream7"].ToString() != "") { model.Paream7 = int.Parse(row["Paream7"].ToString()); } if (row["Paream8"] != null && row["Paream8"].ToString() != "") { model.Paream8 = int.Parse(row["Paream8"].ToString()); } if (row["Paream9"] != null) { model.Paream9 = row["Paream9"].ToString(); } if (row["Paream10"] != null) { model.Paream10 = row["Paream10"].ToString(); } if (row["Paream11"] != null) { model.Paream11 = row["Paream11"].ToString(); } if (row["Paream12"] != null) { model.Paream12 = row["Paream12"].ToString(); } if (row["Paream13"] != null) { model.Paream13 = row["Paream13"].ToString(); } if (row["Paream14"] != null) { model.Paream14 = row["Paream14"].ToString(); } if (row["Paream15"] != null) { model.Paream15 = row["Paream15"].ToString(); } if (row["Paream16"] != null) { model.Paream16 = row["Paream16"].ToString(); } if (row["Paream17"] != null) { model.Paream17 = row["Paream17"].ToString(); } if (row["Paream18"] != null) { model.Paream18 = row["Paream18"].ToString(); } if (row["Paream19"] != null) { model.Paream19 = row["Paream19"].ToString(); } if (row["Paream20"] != null) { model.Paream20 = row["Paream20"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Express.Model.OrderInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OrderInfo set "); strSql.Append("OrderNo=@OrderNo,"); strSql.Append("Daterecived=@Daterecived,"); strSql.Append("SalesmanID=@SalesmanID,"); strSql.Append("CustomerID=@CustomerID,"); strSql.Append("Tel=@Tel,"); strSql.Append("Provice=@Provice,"); strSql.Append("City=@City,"); strSql.Append("Area=@Area,"); strSql.Append("Address=@Address,"); strSql.Append("Reciver=@Reciver,"); strSql.Append("Remark=@Remark,"); strSql.Append("Contractor=@Contractor,"); strSql.Append("Contractdate=@Contractdate,"); strSql.Append("OState=@OState,"); strSql.Append("Merchandiser=@Merchandiser,"); strSql.Append("UserDate=@UserDate,"); strSql.Append("OperUser=@OperUser,"); strSql.Append("ORState=@ORState,"); strSql.Append("Paream0=@Paream0,"); strSql.Append("Paream1=@Paream1,"); strSql.Append("Paream2=@Paream2,"); strSql.Append("Paream3=@Paream3,"); strSql.Append("Paream4=@Paream4,"); strSql.Append("Paream5=@Paream5,"); strSql.Append("Paream6=@Paream6,"); strSql.Append("Paream7=@Paream7,"); strSql.Append("Paream8=@Paream8,"); strSql.Append("Paream9=@Paream9,"); strSql.Append("Paream10=@Paream10,"); strSql.Append("Paream11=@Paream11,"); strSql.Append("Paream12=@Paream12,"); strSql.Append("Paream13=@Paream13,"); strSql.Append("Paream14=@Paream14,"); strSql.Append("Paream15=@Paream15,"); strSql.Append("Paream16=@Paream16,"); strSql.Append("Paream17=@Paream17,"); strSql.Append("Paream18=@Paream18,"); strSql.Append("Paream19=@Paream19,"); strSql.Append("Paream20=@Paream20"); strSql.Append(" where Id=@Id"); OleDbParameter[] parameters = { new OleDbParameter("@OrderNo", OleDbType.VarChar, 30), new OleDbParameter("@Daterecived", OleDbType.Date), new OleDbParameter("@SalesmanID", OleDbType.Integer, 4), new OleDbParameter("@CustomerID", OleDbType.Integer, 4), new OleDbParameter("@Tel", OleDbType.VarChar, 30), new OleDbParameter("@Provice", OleDbType.VarChar, 30), new OleDbParameter("@City", OleDbType.VarChar, 30), new OleDbParameter("@Area", OleDbType.VarChar, 30), new OleDbParameter("@Address", OleDbType.VarChar, 200), new OleDbParameter("@Reciver", OleDbType.VarChar, 10), new OleDbParameter("@Remark", OleDbType.VarChar, 100), new OleDbParameter("@Contractor", OleDbType.VarChar, 20), new OleDbParameter("@Contractdate", OleDbType.Date), new OleDbParameter("@OState", OleDbType.Integer, 4), new OleDbParameter("@Merchandiser", OleDbType.Integer, 4), new OleDbParameter("@UserDate", OleDbType.Date), new OleDbParameter("@OperUser", OleDbType.VarChar, 20), new OleDbParameter("@ORState", OleDbType.Integer, 4), new OleDbParameter("@Paream0", OleDbType.VarChar, 255), new OleDbParameter("@Paream1", OleDbType.VarChar, 255), new OleDbParameter("@Paream2", OleDbType.VarChar, 255), new OleDbParameter("@Paream3", OleDbType.VarChar, 0), new OleDbParameter("@Paream4", OleDbType.VarChar, 255), new OleDbParameter("@Paream5", OleDbType.Integer, 4), new OleDbParameter("@Paream6", OleDbType.Integer, 4), new OleDbParameter("@Paream7", OleDbType.Integer, 4), new OleDbParameter("@Paream8", OleDbType.Integer, 4), new OleDbParameter("@Paream9", OleDbType.VarChar, 0), new OleDbParameter("@Paream10", OleDbType.VarChar, 0), new OleDbParameter("@Paream11", OleDbType.VarChar, 0), new OleDbParameter("@Paream12", OleDbType.VarChar, 0), new OleDbParameter("@Paream13", OleDbType.VarChar, 0), new OleDbParameter("@Paream14", OleDbType.VarChar, 0), new OleDbParameter("@Paream15", OleDbType.VarChar, 0), new OleDbParameter("@Paream16", OleDbType.VarChar, 0), new OleDbParameter("@Paream17", OleDbType.VarChar, 0), new OleDbParameter("@Paream18", OleDbType.VarChar, 0), new OleDbParameter("@Paream19", OleDbType.VarChar, 0), new OleDbParameter("@Paream20", OleDbType.VarChar, 0), new OleDbParameter("@Id", OleDbType.Integer, 4) }; parameters[0].Value = model.OrderNo; parameters[1].Value = model.Daterecived; parameters[2].Value = model.SalesmanID; parameters[3].Value = model.CustomerID; parameters[4].Value = model.Tel; parameters[5].Value = model.Provice; parameters[6].Value = model.City; parameters[7].Value = model.Area; parameters[8].Value = model.Address; parameters[9].Value = model.Reciver; parameters[10].Value = model.Remark; parameters[11].Value = model.Contractor; parameters[12].Value = model.Contractdate; parameters[13].Value = model.OState; parameters[14].Value = model.Merchandiser; parameters[15].Value = model.UserDate; parameters[16].Value = model.OperUser; parameters[17].Value = model.ORState; parameters[18].Value = model.Paream0; parameters[19].Value = model.Paream1; parameters[20].Value = model.Paream2; parameters[21].Value = model.Paream3; parameters[22].Value = model.Paream4; parameters[23].Value = model.Paream5; parameters[24].Value = model.Paream6; parameters[25].Value = model.Paream7; parameters[26].Value = model.Paream8; parameters[27].Value = model.Paream9; parameters[28].Value = model.Paream10; parameters[29].Value = model.Paream11; parameters[30].Value = model.Paream12; parameters[31].Value = model.Paream13; parameters[32].Value = model.Paream14; parameters[33].Value = model.Paream15; parameters[34].Value = model.Paream16; parameters[35].Value = model.Paream17; parameters[36].Value = model.Paream18; parameters[37].Value = model.Paream19; parameters[38].Value = model.Paream20; parameters[39].Value = model.Id; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }