/// <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);
}
}
