//
// GET: /ProductConfigure/
public int save(string id,string LoveCount=null,string Count=null)
{
ProductConfigure info = new ProductConfigure();
ProductConfigureModel model = new ProductConfigureModel();
int i; string type = "";
List<ProductConfigure> list = model.SelProductConfigureById(id);
if (list != null && list.Count > 0)
{
info = list.First();
type = "Update";
}
else {
type = "Insert";
}
info.ProductId = new Guid(id);
if (!string.IsNullOrEmpty(LoveCount))
{
info.LoveCount = Convert.ToInt32(LoveCount);
}
if (!string.IsNullOrEmpty(Count))
{
info.Count = Convert.ToInt32(Count);
}
i = model.SaveProductConfigure(type, info);
return i;
}
public int SaveProductConfigure(string type, ProductConfigure info)
{
if (string.IsNullOrEmpty(type))
{
return 0;
}
if (info == null)
{
return 0;
}
string sql = "";
DbCommand cmd = null;
if (type.Equals("Insert"))
{
sql = "INSERT INTO ProductConfigure (ProductId,LoveCount,Count)"
+ " VALUES(@ProductId,@LoveCount,@Count)";
}
if (type.Equals("Update"))
{
sql = "UPDATE ProductConfigure SET LoveCount=@LoveCount,Count=@Count WHERE ProductId=@ProductId";
}
try
{
cmd = db.GetSqlStringCommand(sql);
db.AddInParameter(cmd, "ProductId", DbType.Guid, info.ProductId);
db.AddInParameter(cmd, "LoveCount", DbType.Int32, info.LoveCount);
db.AddInParameter(cmd, "Count", DbType.Int32, info.Count);
return ExecSql(cmd);
}
catch (Exception)
{
}
return 0;
}