/// <summary> /// 得到一个对象实体 /// </summary> public AsrsStorDBAcc.Model.View_Cell_OperateModel DataRowToModel(DataRow row) { AsrsStorDBAcc.Model.View_Cell_OperateModel model = new AsrsStorDBAcc.Model.View_Cell_OperateModel(); if (row != null) { if (row["WH_Cell_Oper_RecID"] != null) { model.WH_Cell_Oper_RecID = row["WH_Cell_Oper_RecID"].ToString(); } if (row["WareHouse_ID"] != null) { model.WareHouse_ID = row["WareHouse_ID"].ToString(); } if (row["WH_Cell_Code"] != null) { model.WH_Cell_Code = row["WH_Cell_Code"].ToString(); } if (row["WH_Cell_Oper_Type"] != null) { model.WH_Cell_Oper_Type = row["WH_Cell_Oper_Type"].ToString(); } if (row["WH_Cell_Oper_Detail"] != null) { model.WH_Cell_Oper_Detail = row["WH_Cell_Oper_Detail"].ToString(); } if (row["WH_Cell_Oper_Datetime"] != null && row["WH_Cell_Oper_Datetime"].ToString() != "") { model.WH_Cell_Oper_Datetime = DateTime.Parse(row["WH_Cell_Oper_Datetime"].ToString()); } if (row["WareHouse_Code"] != null) { model.WareHouse_Code = row["WareHouse_Code"].ToString(); } if (row["WareHouse_Name"] != null) { model.WareHouse_Name = row["WareHouse_Name"].ToString(); } if (row["WareHouse_Type"] != null) { model.WareHouse_Type = row["WareHouse_Type"].ToString(); } if (row["WareHouse_Flag"] != null) { model.WareHouse_Flag = row["WareHouse_Flag"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public AsrsStorDBAcc.Model.View_Cell_OperateModel GetModel(string WH_Cell_Oper_RecID, string WareHouse_ID, string WH_Cell_Code, string WH_Cell_Oper_Type, string WH_Cell_Oper_Detail, DateTime WH_Cell_Oper_Datetime, string WareHouse_Code, string WareHouse_Name, string WareHouse_Type, string WareHouse_Flag) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" WH_Cell_Oper_RecID,WareHouse_ID,WH_Cell_Code,WH_Cell_Oper_Type,WH_Cell_Oper_Detail,WH_Cell_Oper_Datetime,WareHouse_Code,WareHouse_Name,WareHouse_Type,WareHouse_Flag "); strSql.Append(" from View_Cell_Operate "); strSql.Append(" where WH_Cell_Oper_RecID='" + WH_Cell_Oper_RecID + "' and WareHouse_ID='" + WareHouse_ID + "' and WH_Cell_Code='" + WH_Cell_Code + "' and WH_Cell_Oper_Type='" + WH_Cell_Oper_Type + "' and WH_Cell_Oper_Detail='" + WH_Cell_Oper_Detail + "' and WH_Cell_Oper_Datetime='" + WH_Cell_Oper_Datetime + "' and WareHouse_Code='" + WareHouse_Code + "' and WareHouse_Name='" + WareHouse_Name + "' and WareHouse_Type='" + WareHouse_Type + "' and WareHouse_Flag='" + WareHouse_Flag + "' "); AsrsStorDBAcc.Model.View_Cell_OperateModel model = new AsrsStorDBAcc.Model.View_Cell_OperateModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(AsrsStorDBAcc.Model.View_Cell_OperateModel model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.WH_Cell_Oper_RecID != null) { strSql1.Append("WH_Cell_Oper_RecID,"); strSql2.Append("'" + model.WH_Cell_Oper_RecID + "',"); } if (model.WareHouse_ID != null) { strSql1.Append("WareHouse_ID,"); strSql2.Append("'" + model.WareHouse_ID + "',"); } if (model.WH_Cell_Code != null) { strSql1.Append("WH_Cell_Code,"); strSql2.Append("'" + model.WH_Cell_Code + "',"); } if (model.WH_Cell_Oper_Type != null) { strSql1.Append("WH_Cell_Oper_Type,"); strSql2.Append("'" + model.WH_Cell_Oper_Type + "',"); } if (model.WH_Cell_Oper_Detail != null) { strSql1.Append("WH_Cell_Oper_Detail,"); strSql2.Append("'" + model.WH_Cell_Oper_Detail + "',"); } if (model.WH_Cell_Oper_Datetime != null) { strSql1.Append("WH_Cell_Oper_Datetime,"); strSql2.Append("'" + model.WH_Cell_Oper_Datetime + "',"); } if (model.WareHouse_Code != null) { strSql1.Append("WareHouse_Code,"); strSql2.Append("'" + model.WareHouse_Code + "',"); } if (model.WareHouse_Name != null) { strSql1.Append("WareHouse_Name,"); strSql2.Append("'" + model.WareHouse_Name + "',"); } if (model.WareHouse_Type != null) { strSql1.Append("WareHouse_Type,"); strSql2.Append("'" + model.WareHouse_Type + "',"); } if (model.WareHouse_Flag != null) { strSql1.Append("WareHouse_Flag,"); strSql2.Append("'" + model.WareHouse_Flag + "',"); } strSql.Append("insert into View_Cell_Operate("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); int rows = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AsrsStorDBAcc.Model.View_Cell_OperateModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update View_Cell_Operate set "); if (model.WH_Cell_Oper_RecID != null) { strSql.Append("WH_Cell_Oper_RecID='" + model.WH_Cell_Oper_RecID + "',"); } if (model.WareHouse_ID != null) { strSql.Append("WareHouse_ID='" + model.WareHouse_ID + "',"); } if (model.WH_Cell_Code != null) { strSql.Append("WH_Cell_Code='" + model.WH_Cell_Code + "',"); } if (model.WH_Cell_Oper_Type != null) { strSql.Append("WH_Cell_Oper_Type='" + model.WH_Cell_Oper_Type + "',"); } else { strSql.Append("WH_Cell_Oper_Type= null ,"); } if (model.WH_Cell_Oper_Detail != null) { strSql.Append("WH_Cell_Oper_Detail='" + model.WH_Cell_Oper_Detail + "',"); } else { strSql.Append("WH_Cell_Oper_Detail= null ,"); } if (model.WH_Cell_Oper_Datetime != null) { strSql.Append("WH_Cell_Oper_Datetime='" + model.WH_Cell_Oper_Datetime + "',"); } if (model.WareHouse_Code != null) { strSql.Append("WareHouse_Code='" + model.WareHouse_Code + "',"); } else { strSql.Append("WareHouse_Code= null ,"); } if (model.WareHouse_Name != null) { strSql.Append("WareHouse_Name='" + model.WareHouse_Name + "',"); } else { strSql.Append("WareHouse_Name= null ,"); } if (model.WareHouse_Type != null) { strSql.Append("WareHouse_Type='" + model.WareHouse_Type + "',"); } else { strSql.Append("WareHouse_Type= null ,"); } if (model.WareHouse_Flag != null) { strSql.Append("WareHouse_Flag='" + model.WareHouse_Flag + "',"); } else { strSql.Append("WareHouse_Flag= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where WH_Cell_Oper_RecID='" + model.WH_Cell_Oper_RecID + "' and WareHouse_ID='" + model.WareHouse_ID + "' and WH_Cell_Code='" + model.WH_Cell_Code + "' and WH_Cell_Oper_Type='" + model.WH_Cell_Oper_Type + "' and WH_Cell_Oper_Detail='" + model.WH_Cell_Oper_Detail + "' and WH_Cell_Oper_Datetime='" + model.WH_Cell_Oper_Datetime + "' and WareHouse_Code='" + model.WareHouse_Code + "' and WareHouse_Name='" + model.WareHouse_Name + "' and WareHouse_Type='" + model.WareHouse_Type + "' and WareHouse_Flag='" + model.WareHouse_Flag + "' "); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }