/// <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);
}
}
