/// <summary> /// 更新数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Update(WH_Storage model) { bool result = false; var e = new ModelExceptions(); int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } return(result); }
/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public WH_Storage GetModel(string strCondition) { List <WH_Storage> list = instance.GetListByWhere(strCondition); WH_Storage model = new WH_Storage(); if (list != null && list.Count > 0) { model = list[0]; } else { model = null; } return(model); }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <param name='model'>是否完成验证</param> /// <returns>bool</returns> public bool Insert(WH_Storage model, bool IsValid) { var e = new ModelExceptions(); bool result = false; if (e.IsValid && IsValid) { //完成了验证,开始更新数据库了 int _result = instance.Add(model); if (_result > 0) { result = true; } } return(result); }
/// <summary> /// 逻辑删除数据 /// </summary> /// <param name='model'>model</param> /// <returns>bool</returns> public bool Delete(string Condition) { bool result = false; List <WH_Storage> list = instance.GetListByWhere(Condition); if (list.Count > 0) { WH_Storage model = list[0]; model.Stat = 1; int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } } return(result); }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Insert(WH_Storage model) { bool result = false; try { int _result = instance.Add(model); if (_result > 0) { result = true; } } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public WH_Storage GetModel(int id) { WH_Storage model = instance.GetByKey(id); return(model); }
public List <WH_Storage> GetListByWhereEx(string strCondition) { List <WH_Storage> ret = new List <WH_Storage>(); //string sql = "SELECT WH_Storage.*,WH_Material.MD_Name FROM WH_Storage,WH_Material WHERE 1=1 AND ((WH_Material.Stat is null) or (WH_Material.Stat=0) ) AND WH_Storage.Storage_MaterielCode= WH_Material.MD_MCode "; string sql = @"SELECT a.Storage_ID,a.Storage_WarehouseCode,a.Storage_WarehouseNo, a.Storage_Company,a.Storage_CompanyCode,a.Storage_MaterielCode, b.MD_Name,c.WP_Price as Storage_Price,a.Storage_Code,a.Storage_Count,a.Storage_Available,a.Storage_LNum,a.Storage_TNum, a.Storage_PromiseCount,a.Storage_Dvalue,a.Storage_OrderCount,a.Storage_Remark from WH_Storage a INNER JOIN WH_Material b on a.Storage_MaterielCode=b.MD_MCode Inner JOIN WH_Price c on a.Storage_MaterielCode=c.WP_MCode where a.Storage_CompanyCode=c.WP_CCode and isnull(a.Stat,0)=0 and isnull(b.Stat,0)=0 and isnull(c.Stat,0)=0"; if (!string.IsNullOrEmpty(strCondition)) { strCondition.Replace('\'', '"'); //防sql注入 sql += strCondition; } sql += " ORDER BY a.Storage_ID DESC "; SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { WH_Storage wH_Storage = new WH_Storage(); if (dr["Storage_ID"] != DBNull.Value) { wH_Storage.Storage_ID = Convert.ToDecimal(dr["Storage_ID"]); } if (dr["Storage_Code"] != DBNull.Value) { wH_Storage.Storage_Code = Convert.ToString(dr["Storage_Code"]); } if (dr["Storage_MaterielCode"] != DBNull.Value) { wH_Storage.Storage_MaterielCode = Convert.ToString(dr["Storage_MaterielCode"]); } if (dr["Storage_WarehouseCode"] != DBNull.Value) { wH_Storage.Storage_WarehouseCode = Convert.ToString(dr["Storage_WarehouseCode"]); } if (dr["Storage_WarehouseNo"] != DBNull.Value) { wH_Storage.Storage_WarehouseNo = Convert.ToString(dr["Storage_WarehouseNo"]); } if (dr["Storage_Count"] != DBNull.Value) { wH_Storage.Storage_Count = Convert.ToInt64(dr["Storage_Count"]); } if (dr["Storage_PromiseCount"] != DBNull.Value) { wH_Storage.Storage_PromiseCount = Convert.ToInt64(dr["Storage_PromiseCount"]); } if (dr["Storage_OrderCount"] != DBNull.Value) { wH_Storage.Storage_OrderCount = Convert.ToInt64(dr["Storage_OrderCount"]); } if (dr["Storage_Available"] != DBNull.Value) { wH_Storage.Storage_Available = Convert.ToDecimal(dr["Storage_Available"]); } if (dr["Storage_TNum"] != DBNull.Value) { wH_Storage.Storage_TNum = Convert.ToInt64(dr["Storage_TNum"]); } if (dr["Storage_LNum"] != DBNull.Value) { wH_Storage.Storage_LNum = Convert.ToInt64(dr["Storage_LNum"]); } if (dr["Storage_Remark"] != DBNull.Value) { wH_Storage.Storage_Remark = Convert.ToString(dr["Storage_Remark"]); } //if (dr["Stat"] != DBNull.Value) wH_Storage.Stat = Convert.ToInt32(dr["Stat"]); //if (dr["CreateDate"] != DBNull.Value) wH_Storage.CreateDate = Convert.ToDateTime(dr["CreateDate"]); //if (dr["UpdateDate"] != DBNull.Value) wH_Storage.UpdateDate = Convert.ToDateTime(dr["UpdateDate"]); //if (dr["DeleteDate"] != DBNull.Value) wH_Storage.DeleteDate = Convert.ToDateTime(dr["DeleteDate"]); if (dr["MD_Name"] != DBNull.Value) { wH_Storage.MD_Name = Convert.ToString(dr["MD_Name"]); } if (dr["Storage_Company"] != DBNull.Value) { wH_Storage.Storage_Company = Convert.ToString(dr["Storage_Company"]); } if (dr["Storage_CompanyCode"] != DBNull.Value) { wH_Storage.Storage_CompanyCode = Convert.ToString(dr["Storage_CompanyCode"]); } if (dr["Storage_Price"] != DBNull.Value) { wH_Storage.Storage_Price = Convert.ToDecimal(dr["Storage_Price"]); } ret.Add(wH_Storage); } } catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return(ret); }