/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.PayInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PayInfo("); strSql.Append("EmployeeID,DateTime,MaterielID,WorkingID,Amount,Price,ProductWorkingID,WorkticketInfoID,IsSum,BreakID,ColorID,SizeID,BoxNum,OderNum,IsDay)"); strSql.Append(" values ("); strSql.Append("@EmployeeID,@DateTime,@MaterielID,@WorkingID,@Amount,@Price,@ProductWorkingID,@WorkticketInfoID,@IsSum,@BreakID,@ColorID,@SizeID,@BoxNum,@OderNum,@IsDay)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@EmployeeID", SqlDbType.Int, 4), new SqlParameter("@DateTime", SqlDbType.DateTime), new SqlParameter("@MaterielID", SqlDbType.Int, 4), new SqlParameter("@WorkingID", SqlDbType.Int, 4), new SqlParameter("@Amount", SqlDbType.Int, 4), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@ProductWorkingID", SqlDbType.Int, 4), new SqlParameter("@WorkticketInfoID", SqlDbType.Int, 4), new SqlParameter("@IsSum", SqlDbType.Bit, 1), new SqlParameter("@BreakID", SqlDbType.Int, 4), new SqlParameter("@ColorID", SqlDbType.Int, 4), new SqlParameter("@SizeID", SqlDbType.Int, 4), new SqlParameter("@BoxNum", SqlDbType.Int, 4), new SqlParameter("@OderNum", SqlDbType.NVarChar, 50), new SqlParameter("@IsDay", SqlDbType.Bit, 4) }; parameters[0].Value = model.EmployeeID; parameters[1].Value = model.DateTime; parameters[2].Value = model.MaterielID; parameters[3].Value = model.WorkingID; parameters[4].Value = model.Amount; parameters[5].Value = model.Price; parameters[6].Value = model.ProductWorkingID; parameters[7].Value = model.WorkticketInfoID; parameters[8].Value = model.IsSum; parameters[9].Value = model.BreakID; parameters[10].Value = model.ColorID; parameters[11].Value = model.SizeID; parameters[12].Value = model.BoxNum; parameters[13].Value = model.OderNum; parameters[14].Value = model.IsDay; try { object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } } catch (Exception ex) { return(0); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.PayInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PayInfo set "); strSql.Append("EmployeeID=@EmployeeID,"); strSql.Append("DateTime=@DateTime,"); strSql.Append("MaterielID=@MaterielID,"); strSql.Append("WorkingID=@WorkingID,"); strSql.Append("Amount=@Amount,"); strSql.Append("Price=@Price,"); strSql.Append("ProductWorkingID=@ProductWorkingID,"); strSql.Append("WorkticketInfoID=@WorkticketInfoID,"); strSql.Append("IsSum=@IsSum,"); strSql.Append("BreakID=@BreakID,"); strSql.Append("ColorID=@ColorID,"); strSql.Append("SizeID=@SizeID,"); strSql.Append("BoxNum=@BoxNum,"); strSql.Append("OderNum=@OderNum,"); strSql.Append("IsDay=@IsDay"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@EmployeeID", SqlDbType.Int, 4), new SqlParameter("@DateTime", SqlDbType.DateTime), new SqlParameter("@MaterielID", SqlDbType.Int, 4), new SqlParameter("@WorkingID", SqlDbType.Int, 4), new SqlParameter("@Amount", SqlDbType.Int, 4), new SqlParameter("@Price", SqlDbType.Decimal, 9), new SqlParameter("@ProductWorkingID", SqlDbType.Int, 4), new SqlParameter("@WorkticketInfoID", SqlDbType.Int, 4), new SqlParameter("@IsSum", SqlDbType.Bit, 1), new SqlParameter("@BreakID", SqlDbType.Int, 4), new SqlParameter("@ColorID", SqlDbType.Int, 4), new SqlParameter("@SizeID", SqlDbType.Int, 4), new SqlParameter("@BoxNum", SqlDbType.Int, 4), new SqlParameter("@OderNum", SqlDbType.NVarChar, 50), new SqlParameter("@IsDay", SqlDbType.Bit, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.EmployeeID; parameters[2].Value = model.DateTime; parameters[3].Value = model.MaterielID; parameters[4].Value = model.WorkingID; parameters[5].Value = model.Amount; parameters[6].Value = model.Price; parameters[7].Value = model.ProductWorkingID; parameters[8].Value = model.WorkticketInfoID; parameters[9].Value = model.IsSum; parameters[10].Value = model.BreakID; parameters[11].Value = model.ColorID; parameters[12].Value = model.SizeID; parameters[13].Value = model.BoxNum; parameters[14].Value = model.OderNum; parameters[15].Value = model.IsDay; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public Hownet.Model.PayInfo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,EmployeeID,DateTime,MaterielID,WorkingID,Amount,Price,ProductWorkingID,WorkticketInfoID,IsSum,BreakID,ColorID,SizeID,BoxNum,OderNum,IsDay from PayInfo "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Hownet.Model.PayInfo model = new Hownet.Model.PayInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["EmployeeID"].ToString() != "") { model.EmployeeID = int.Parse(ds.Tables[0].Rows[0]["EmployeeID"].ToString()); } if (ds.Tables[0].Rows[0]["DateTime"].ToString() != "") { model.DateTime = DateTime.Parse(ds.Tables[0].Rows[0]["DateTime"].ToString()); } if (ds.Tables[0].Rows[0]["MaterielID"].ToString() != "") { model.MaterielID = int.Parse(ds.Tables[0].Rows[0]["MaterielID"].ToString()); } if (ds.Tables[0].Rows[0]["WorkingID"].ToString() != "") { model.WorkingID = int.Parse(ds.Tables[0].Rows[0]["WorkingID"].ToString()); } if (ds.Tables[0].Rows[0]["Amount"].ToString() != "") { model.Amount = int.Parse(ds.Tables[0].Rows[0]["Amount"].ToString()); } if (ds.Tables[0].Rows[0]["Price"].ToString() != "") { model.Price = decimal.Parse(ds.Tables[0].Rows[0]["Price"].ToString()); } if (ds.Tables[0].Rows[0]["ProductWorkingID"].ToString() != "") { model.ProductWorkingID = int.Parse(ds.Tables[0].Rows[0]["ProductWorkingID"].ToString()); } if (ds.Tables[0].Rows[0]["WorkticketInfoID"].ToString() != "") { model.WorkticketInfoID = int.Parse(ds.Tables[0].Rows[0]["WorkticketInfoID"].ToString()); } if (ds.Tables[0].Rows[0]["IsSum"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsSum"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsSum"].ToString().ToLower() == "true")) { model.IsSum = true; } else { model.IsSum = false; } } if (ds.Tables[0].Rows[0]["BreakID"].ToString() != "") { model.BreakID = int.Parse(ds.Tables[0].Rows[0]["BreakID"].ToString()); } if (ds.Tables[0].Rows[0]["ColorID"].ToString() != "") { model.ColorID = int.Parse(ds.Tables[0].Rows[0]["ColorID"].ToString()); } if (ds.Tables[0].Rows[0]["SizeID"].ToString() != "") { model.SizeID = int.Parse(ds.Tables[0].Rows[0]["SizeID"].ToString()); } if (ds.Tables[0].Rows[0]["BoxNum"].ToString() != "") { model.BoxNum = int.Parse(ds.Tables[0].Rows[0]["BoxNum"].ToString()); } model.OderNum = ds.Tables[0].Rows[0]["OderNum"].ToString(); if (ds.Tables[0].Rows[0]["IsDay"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsDay"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsDay"].ToString().ToLower() == "true")) { model.IsDay = true; } else { model.IsDay = false; } } model.A = 1; return(model); } else { return(null); } }