/// <summary> /// 更新一条数据 /// </summary> public void Update(Hownet.Model.AmountInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AmountInfo set "); strSql.Append("MainID=@MainID,"); strSql.Append("TableTypeID=@TableTypeID,"); strSql.Append("ColorID=@ColorID,"); strSql.Append("ColorOneID=@ColorOneID,"); strSql.Append("ColorTwoID=@ColorTwoID,"); strSql.Append("SizeID=@SizeID,"); strSql.Append("MListID=@MListID,"); strSql.Append("Amount=@Amount,"); strSql.Append("NotAmount=@NotAmount,"); strSql.Append("NotDepAmount=@NotDepAmount,"); strSql.Append("Remark=@Remark"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@MainID", SqlDbType.Int, 4), new SqlParameter("@TableTypeID", SqlDbType.Int, 4), new SqlParameter("@ColorID", SqlDbType.Int, 4), new SqlParameter("@ColorOneID", SqlDbType.Int, 4), new SqlParameter("@ColorTwoID", SqlDbType.Int, 4), new SqlParameter("@SizeID", SqlDbType.Int, 4), new SqlParameter("@MListID", SqlDbType.Int, 4), new SqlParameter("@Amount", SqlDbType.Int, 4), new SqlParameter("@NotAmount", SqlDbType.Int, 4), new SqlParameter("@NotDepAmount", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.ID; parameters[1].Value = model.MainID; parameters[2].Value = model.TableTypeID; parameters[3].Value = model.ColorID; parameters[4].Value = model.ColorOneID; parameters[5].Value = model.ColorTwoID; parameters[6].Value = model.SizeID; parameters[7].Value = model.MListID; parameters[8].Value = model.Amount; parameters[9].Value = model.NotAmount; parameters[10].Value = model.NotDepAmount; parameters[11].Value = model.Remark; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.AmountInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AmountInfo("); strSql.Append("MainID,TableTypeID,ColorID,ColorOneID,ColorTwoID,SizeID,MListID,Amount,NotAmount,NotDepAmount,Remark)"); strSql.Append(" values ("); strSql.Append("@MainID,@TableTypeID,@ColorID,@ColorOneID,@ColorTwoID,@SizeID,@MListID,@Amount,@NotAmount,@NotDepAmount,@Remark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MainID", SqlDbType.Int, 4), new SqlParameter("@TableTypeID", SqlDbType.Int, 4), new SqlParameter("@ColorID", SqlDbType.Int, 4), new SqlParameter("@ColorOneID", SqlDbType.Int, 4), new SqlParameter("@ColorTwoID", SqlDbType.Int, 4), new SqlParameter("@SizeID", SqlDbType.Int, 4), new SqlParameter("@MListID", SqlDbType.Int, 4), new SqlParameter("@Amount", SqlDbType.Int, 4), new SqlParameter("@NotAmount", SqlDbType.Int, 4), new SqlParameter("@NotDepAmount", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.MainID; parameters[1].Value = model.TableTypeID; parameters[2].Value = model.ColorID; parameters[3].Value = model.ColorOneID; parameters[4].Value = model.ColorTwoID; parameters[5].Value = model.SizeID; parameters[6].Value = model.MListID; parameters[7].Value = model.Amount; parameters[8].Value = model.NotAmount; parameters[9].Value = model.NotDepAmount; parameters[10].Value = model.Remark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
public static DataTable ShowPSInfo(int PSOID, int TableTypeID) { string bllAI = "Hownet.BLL.ProduceSellInfo"; Hownet.Model.AmountInfo modAI = new Hownet.Model.AmountInfo(); DataTable dtInfo = new DataTable(); // if(AmountTypeID<4) dtInfo = BasicClass.GetDataSet.GetDS(bllAI, "GetList", new object[] { "(PSOID=" + PSOID + ")" }).Tables[0]; DataTable dtColor = BasicClass.GetDataSet.GetDS(bllAI, "GetSumColor", new object[] { PSOID }).Tables[0]; DataTable dtSize = BasicClass.GetDataSet.GetDS(bllAI, "GetSize", new object[] { PSOID }).Tables[0]; DataTable dt = new DataTable(); dt.Columns.Add("Color", typeof(string)); dt.Rows.Add(dt.NewRow()); dt.Rows[0]["Color"] = "颜色\\尺码"; int i = 1; ArrayList ColorList = new ArrayList(); ArrayList SizeList = new ArrayList(); ArrayList ColorOneList = new ArrayList(); ArrayList ColorTwoList = new ArrayList(); ColorList.Clear(); ColorOneList.Clear(); ColorTwoList.Clear(); SizeList.Clear(); ColorList.Add(0); SizeList.Add(0); ColorOneList.Add(0); ColorTwoList.Add(0); for (int n = 0; n < dtSize.Rows.Count; n++) { dt.Columns.Add("Columns" + i); dt.Rows[0][i] = dtSize.Rows[n]["SizeName"].ToString(); SizeList.Add(int.Parse(dtSize.Rows[n]["SizeID"].ToString())); i++; } for (int c = dt.Columns.Count; c < 13; c++) { dt.Columns.Add("Columns" + c); } dt.Columns.Add("SumNum"); dt.Rows[0]["SumNum"] = "合计"; dt.Columns.Add("ColorOne", typeof(string)); dt.Columns.Add("ColorTwo", typeof(string)); dt.Columns.Add("MainID", typeof(int)); dt.Rows[0]["ColorOne"] = "位置颜色一"; dt.Rows[0]["ColorTwo"] = "位置颜色二"; dt.Rows[0]["MainID"] = PSOID; i = 1; for (int n = 0; n < dtColor.Rows.Count; n++) { dt.Rows.Add(dt.NewRow()); dt.Rows[i][0] = dtColor.Rows[n]["ColorName"].ToString(); dt.Rows[i][dt.Columns.Count - 3] = dtColor.Rows[n]["ColorOneName"].ToString(); dt.Rows[i][dt.Columns.Count - 2] = dtColor.Rows[n]["ColorTwoName"].ToString(); dt.Rows[i]["MainID"] = PSOID; ColorList.Add(int.Parse(dtColor.Rows[n]["ColorID"].ToString())); ColorOneList.Add(int.Parse(dtColor.Rows[n]["ColorOneID"].ToString())); ColorTwoList.Add(int.Parse(dtColor.Rows[n]["ColorTwoID"].ToString())); i++; } for (int r = 1; r < SizeList.Count; r++) { modAI.SizeID = int.Parse(SizeList[r].ToString()); for (int c = 1; c < ColorList.Count; c++) { modAI.ColorID = int.Parse(ColorList[c].ToString()); modAI.ColorOneID = int.Parse(ColorOneList[c].ToString()); modAI.ColorTwoID = int.Parse(ColorTwoList[c].ToString()); modAI.MainID = PSOID; string sql = "(SizeID=" + modAI.SizeID + ") and (ColorID=" + modAI.ColorID + ") and (ColorOneID=" + modAI.ColorOneID + ") and (ColorTwoID=" + modAI.ColorTwoID + ")"; DataRow[] drs = dtInfo.Select(sql); if (drs.Length > 0) { dt.Rows[c][r] = drs[0]["Amount"]; } } } return(dt); }
/// <summary> /// 得到一个对象实体 /// </summary> public Hownet.Model.AmountInfo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,MainID,TableTypeID,ColorID,ColorOneID,ColorTwoID,SizeID,MListID,Amount,NotAmount,NotDepAmount,Remark from AmountInfo "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Hownet.Model.AmountInfo model = new Hownet.Model.AmountInfo(); 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]["MainID"].ToString() != "") { model.MainID = int.Parse(ds.Tables[0].Rows[0]["MainID"].ToString()); } if (ds.Tables[0].Rows[0]["TableTypeID"].ToString() != "") { model.TableTypeID = int.Parse(ds.Tables[0].Rows[0]["TableTypeID"].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]["ColorOneID"].ToString() != "") { model.ColorOneID = int.Parse(ds.Tables[0].Rows[0]["ColorOneID"].ToString()); } if (ds.Tables[0].Rows[0]["ColorTwoID"].ToString() != "") { model.ColorTwoID = int.Parse(ds.Tables[0].Rows[0]["ColorTwoID"].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]["MListID"].ToString() != "") { model.MListID = int.Parse(ds.Tables[0].Rows[0]["MListID"].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]["NotAmount"].ToString() != "") { model.NotAmount = int.Parse(ds.Tables[0].Rows[0]["NotAmount"].ToString()); } if (ds.Tables[0].Rows[0]["NotDepAmount"].ToString() != "") { model.NotDepAmount = int.Parse(ds.Tables[0].Rows[0]["NotDepAmount"].ToString()); } model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); model.A = 1; return(model); } else { return(null); } }