/// <summary> /// 更新一条数据 /// </summary> public bool Update(AsrsStorDBAcc.Model.OutBatchSetModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OutBatchSet set "); strSql.Append("StoreHouseID=@StoreHouseID,"); strSql.Append("StoreHouseLogicAreaID=@StoreHouseLogicAreaID,"); strSql.Append("Batch=@Batch,"); strSql.Append("Resever1=@Resever1,"); strSql.Append("Resever2=@Resever2,"); strSql.Append("Resever3=@Resever3,"); strSql.Append("Resever4=@Resever4,"); strSql.Append("Resever5=@Resever5,"); strSql.Append("Resever6=@Resever6,"); strSql.Append("Resever7=@Resever7,"); strSql.Append("Resever8=@Resever8"); strSql.Append(" where OutBatchSetID=@OutBatchSetID"); SqlParameter[] parameters = { new SqlParameter("@StoreHouseID", SqlDbType.BigInt, 8), new SqlParameter("@StoreHouseLogicAreaID", SqlDbType.BigInt, 8), new SqlParameter("@Batch", SqlDbType.NVarChar, 200), new SqlParameter("@Resever1", SqlDbType.NVarChar, 50), new SqlParameter("@Resever2", SqlDbType.NVarChar, 50), new SqlParameter("@Resever3", SqlDbType.NVarChar, 50), new SqlParameter("@Resever4", SqlDbType.NVarChar, 50), new SqlParameter("@Resever5", SqlDbType.NVarChar, 50), new SqlParameter("@Resever6", SqlDbType.NVarChar, 50), new SqlParameter("@Resever7", SqlDbType.NVarChar, 50), new SqlParameter("@Resever8", SqlDbType.NVarChar, 50), new SqlParameter("@OutBatchSetID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.StoreHouseID; parameters[1].Value = model.StoreHouseLogicAreaID; parameters[2].Value = model.Batch; parameters[3].Value = model.Resever1; parameters[4].Value = model.Resever2; parameters[5].Value = model.Resever3; parameters[6].Value = model.Resever4; parameters[7].Value = model.Resever5; parameters[8].Value = model.Resever6; parameters[9].Value = model.Resever7; parameters[10].Value = model.Resever8; parameters[11].Value = model.OutBatchSetID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AsrsStorDBAcc.Model.OutBatchSetModel DataRowToModel(DataRow row) { AsrsStorDBAcc.Model.OutBatchSetModel model = new AsrsStorDBAcc.Model.OutBatchSetModel(); if (row != null) { if (row["OutBatchSetID"] != null && row["OutBatchSetID"].ToString() != "") { model.OutBatchSetID = long.Parse(row["OutBatchSetID"].ToString()); } if (row["StoreHouseID"] != null && row["StoreHouseID"].ToString() != "") { model.StoreHouseID = long.Parse(row["StoreHouseID"].ToString()); } if (row["StoreHouseLogicAreaID"] != null && row["StoreHouseLogicAreaID"].ToString() != "") { model.StoreHouseLogicAreaID = long.Parse(row["StoreHouseLogicAreaID"].ToString()); } if (row["Batch"] != null) { model.Batch = row["Batch"].ToString(); } if (row["Resever1"] != null) { model.Resever1 = row["Resever1"].ToString(); } if (row["Resever2"] != null) { model.Resever2 = row["Resever2"].ToString(); } if (row["Resever3"] != null) { model.Resever3 = row["Resever3"].ToString(); } if (row["Resever4"] != null) { model.Resever4 = row["Resever4"].ToString(); } if (row["Resever5"] != null) { model.Resever5 = row["Resever5"].ToString(); } if (row["Resever6"] != null) { model.Resever6 = row["Resever6"].ToString(); } if (row["Resever7"] != null) { model.Resever7 = row["Resever7"].ToString(); } if (row["Resever8"] != null) { model.Resever8 = row["Resever8"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(AsrsStorDBAcc.Model.OutBatchSetModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OutBatchSet("); strSql.Append("StoreHouseID,StoreHouseLogicAreaID,Batch,Resever1,Resever2,Resever3,Resever4,Resever5,Resever6,Resever7,Resever8)"); strSql.Append(" values ("); strSql.Append("@StoreHouseID,@StoreHouseLogicAreaID,@Batch,@Resever1,@Resever2,@Resever3,@Resever4,@Resever5,@Resever6,@Resever7,@Resever8)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@StoreHouseID", SqlDbType.BigInt, 8), new SqlParameter("@StoreHouseLogicAreaID", SqlDbType.BigInt, 8), new SqlParameter("@Batch", SqlDbType.NVarChar, 200), new SqlParameter("@Resever1", SqlDbType.NVarChar, 50), new SqlParameter("@Resever2", SqlDbType.NVarChar, 50), new SqlParameter("@Resever3", SqlDbType.NVarChar, 50), new SqlParameter("@Resever4", SqlDbType.NVarChar, 50), new SqlParameter("@Resever5", SqlDbType.NVarChar, 50), new SqlParameter("@Resever6", SqlDbType.NVarChar, 50), new SqlParameter("@Resever7", SqlDbType.NVarChar, 50), new SqlParameter("@Resever8", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.StoreHouseID; parameters[1].Value = model.StoreHouseLogicAreaID; parameters[2].Value = model.Batch; parameters[3].Value = model.Resever1; parameters[4].Value = model.Resever2; parameters[5].Value = model.Resever3; parameters[6].Value = model.Resever4; parameters[7].Value = model.Resever5; parameters[8].Value = model.Resever6; parameters[9].Value = model.Resever7; parameters[10].Value = model.Resever8; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AsrsStorDBAcc.Model.OutBatchSetModel GetModel(long OutBatchSetID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 OutBatchSetID,StoreHouseID,StoreHouseLogicAreaID,Batch,Resever1,Resever2,Resever3,Resever4,Resever5,Resever6,Resever7,Resever8 from OutBatchSet "); strSql.Append(" where OutBatchSetID=@OutBatchSetID"); SqlParameter[] parameters = { new SqlParameter("@OutBatchSetID", SqlDbType.BigInt) }; parameters[0].Value = OutBatchSetID; AsrsStorDBAcc.Model.OutBatchSetModel model = new AsrsStorDBAcc.Model.OutBatchSetModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }