internal int Editguigetype(B2b_com_pro_Specitype mguigetype)
{
string sql = "select id from b2b_com_pro_Specitype where proid=" + mguigetype.proid + " and type_name='" + mguigetype.type_name + "'";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
var typeid = 0;
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
typeid = reader.GetValue <int>("id");
}
}
#region 编辑
if (typeid > 0)
{
string sql1 = "update b2b_com_pro_Specitype set type_name='" + mguigetype.type_name + "' where id=" + typeid;
var cmd1 = sqlHelper.PrepareTextSqlCommand(sql1);
cmd1.ExecuteNonQuery();
return(typeid);
}
#endregion
#region 添加
else
{
string sql2 = "INSERT INTO [b2b_com_pro_Specitype] ([comid] ,[proid] ,[type_name]) VALUES (" + mguigetype.comid + "," + mguigetype.proid + ",'" + mguigetype.type_name + "');select @@identity;";
var cmd2 = sqlHelper.PrepareTextSqlCommand(sql2);
object o = cmd2.ExecuteScalar();
return(int.Parse(o.ToString()));
}
#endregion
}
public int Editguigetype(B2b_com_pro_Specitype mguigetype)
{
using (var helper = new SqlHelper())
{
int typeid = new Internalb2b_com_pro_Specitype(helper).Editguigetype(mguigetype);
return(typeid);
}
}
