/// <summary> /// 插入产品基本信息 /// </summary> /// <returns>The insert.</returns> public int Insert(Model.SysProductBase Model) { StringBuilder strSql = new StringBuilder(); strSql.Append(" if not exists(select Title from SysProductBase where Title =@Title ) begin "); strSql.Append(" insert into SysProductBase("); strSql.Append(" FirCategoryID,SecCategoryID,ThiCategoryID,StoreID,Title,KeyWords,MainPic,GroupID,UnitID,UserID,State,EntryDate)"); strSql.Append(" values ("); strSql.Append(" @FirCategoryID,@SecCategoryID,@ThiCategoryID,@StoreID,@Title,@KeyWords,@MainPic,@GroupID,@UnitID,@UserID,@State,@EntryDate)"); strSql.Append(" ; select @@IDENTITY; "); strSql.Append(" end ELSE begin SELECT -1 END"); SqlParameter[] parameters = { new SqlParameter("@FirCategoryID", SqlDbType.Int, 4), new SqlParameter("@SecCategoryID", SqlDbType.Int, 4), new SqlParameter("@ThiCategoryID", SqlDbType.Int, 4), new SqlParameter("@StoreID", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 50), new SqlParameter("@KeyWords", SqlDbType.NVarChar, 200), new SqlParameter("@MainPic", SqlDbType.NVarChar, 200), new SqlParameter("@GroupID", SqlDbType.Int, 4), new SqlParameter("@UnitID", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@EntryDate", SqlDbType.DateTime) }; parameters[0].Value = Model.FirCategoryID; parameters[1].Value = Model.SecCategoryID; parameters[2].Value = Model.ThiCategoryID; parameters[3].Value = Model.StoreID; parameters[4].Value = Model.Title; parameters[5].Value = Model.KeyWords; parameters[6].Value = Model.MainPic; parameters[7].Value = Model.GroupID; parameters[8].Value = Model.UnitID; parameters[9].Value = Model.UserID; parameters[10].Value = Model.State; parameters[11].Value = Model.EntryDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 修改产品基础 /// </summary> /// <returns>返回影响行数</returns> /// <param name="Model">产品基础实体</param> public int ModifyModel(Model.SysProductBase Model) { StringBuilder strSql = new StringBuilder(); strSql.Append("Update SysProductBase "); strSql.Append("Set FirCategoryID=@FirCategoryID,SecCategoryID=@SecCategoryID,ThiCategoryID=@ThiCategoryID,Title=@Title,KeyWords=@KeyWords,MainPic=@MainPic,GroupID=@GroupID,UnitID=@UnitID,UserID=@UserID,State=@State,EntryDate=@EntryDate "); strSql.Append("Where ProductID=@ProductID "); SqlParameter[] parameters = { new SqlParameter("@ProductID", SqlDbType.Int, 4), new SqlParameter("@FirCategoryID", SqlDbType.Int, 4), new SqlParameter("@SecCategoryID", SqlDbType.Int, 4), new SqlParameter("@ThiCategoryID", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 50), new SqlParameter("@KeyWords", SqlDbType.NVarChar, 200), new SqlParameter("@MainPic", SqlDbType.NVarChar, 200), new SqlParameter("@GroupID", SqlDbType.Int, 4), new SqlParameter("@UnitID", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@EntryDate", SqlDbType.DateTime) }; parameters[0].Value = Model.ProductID; parameters[1].Value = Model.FirCategoryID; parameters[2].Value = Model.SecCategoryID; parameters[3].Value = Model.ThiCategoryID; parameters[4].Value = Model.Title; parameters[5].Value = Model.KeyWords; parameters[6].Value = Model.MainPic; parameters[7].Value = Model.GroupID; parameters[8].Value = Model.UnitID; parameters[9].Value = Model.UserID; parameters[10].Value = Model.State; parameters[11].Value = Model.EntryDate; return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters)); }
/// <summary> /// 修改产品基础 /// </summary> /// <returns>返回影响行数</returns> /// <param name="Model">产品基础实体</param> public int ModifyModel(Model.SysProductBase Model) { return(dal.ModifyModel(Model)); }
/// <summary> /// 插入产品基本信息 /// </summary> /// <returns>The insert.</returns> public int Insert(Model.SysProductBase Model) { return(dal.Insert(Model)); }
/// <summary> /// 设置实体 /// </summary> /// <returns>返回对象实体</returns> /// <param name="dr">行</param> private Model.SysProductBase SetEntity(DataRow dr) { Model.SysProductBase model = new Model.SysProductBase(); if (dr != null) { if (dr["ProductID"].ToString() != "") { model.ProductID = int.Parse(dr["ProductID"].ToString()); } if (dr["FirCategoryID"].ToString() != "") { model.FirCategoryID = int.Parse(dr["FirCategoryID"].ToString()); } if (dr.Table.Columns.Contains("FirCategoryName")) { if (dr["FirCategoryName"].ToString() != "") { model.FirCategoryName = dr["FirCategoryName"].ToString(); } } if (dr["SecCategoryID"].ToString() != "") { model.SecCategoryID = int.Parse(dr["SecCategoryID"].ToString()); } if (dr.Table.Columns.Contains("SecCategoryName")) { if (dr["SecCategoryName"].ToString() != "") { model.SecCategoryName = dr["SecCategoryName"].ToString(); } } if (dr["ThiCategoryID"].ToString() != "") { model.ThiCategoryID = int.Parse(dr["ThiCategoryID"].ToString()); } if (dr.Table.Columns.Contains("ThiCategoryName")) { if (dr["ThiCategoryName"].ToString() != "") { model.ThiCategoryName = dr["ThiCategoryName"].ToString(); } } if (dr["StoreID"].ToString() != "") { model.StoreID = int.Parse(dr["StoreID"].ToString()); } if (dr["Title"].ToString() != "") { model.Title = dr["Title"].ToString(); } if (dr["KeyWords"].ToString() != "") { model.KeyWords = dr["KeyWords"].ToString(); } if (dr["MainPic"].ToString() != "") { model.MainPic = dr["MainPic"].ToString(); } if (dr["GroupID"].ToString() != "") { model.GroupID = int.Parse(dr["GroupID"].ToString()); } if (dr.Table.Columns.Contains("GroupName")) { if (dr["GroupName"].ToString() != "") { model.GroupName = dr["GroupName"].ToString(); } } if (dr["UnitID"].ToString() != "") { model.UnitID = int.Parse(dr["UnitID"].ToString()); } if (dr.Table.Columns.Contains("UnitName")) { if (dr["UnitName"].ToString() != "") { model.UnitName = dr["UnitName"].ToString(); } } if (dr["UserID"].ToString() != "") { model.UnitID = int.Parse(dr["UserID"].ToString()); } if (dr.Table.Columns.Contains("UserName")) { if (dr["UserName"].ToString() != "") { model.UserName = dr["UserName"].ToString(); } } if (dr["State"].ToString() != "") { if ((dr["State"].ToString() == "1") || (dr["State"].ToString().ToLower() == "true")) { model.State = true; } else { model.State = false; } } if (dr["EntryDate"].ToString() != "") { model.EntryDate = DateTime.Parse(dr["EntryDate"].ToString()); } return(model); } else { return(null); } }