public int Insert(SOSizeTypeSetListInfo oParam)
{
string sql = @"INSERT INTO SO_SizeType_SetList
(
ItemID, CreateUserSysNo, CreateTime, SizeType
)
VALUES (
@ItemID, @CreateUserSysNo, @CreateTime, @SizeType
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramItemID = new SqlParameter("@ItemID", SqlDbType.NVarChar, 50);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramSizeType = new SqlParameter("@SizeType", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.ItemID != AppConst.StringNull)
paramItemID.Value = oParam.ItemID;
else
paramItemID.Value = System.DBNull.Value;
if (oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
if (oParam.CreateTime != AppConst.DateTimeNull)
paramCreateTime.Value = oParam.CreateTime;
else
paramCreateTime.Value = System.DBNull.Value;
if (oParam.SizeType != AppConst.IntNull)
paramSizeType.Value = oParam.SizeType;
else
paramSizeType.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramItemID);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramSizeType);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
public void InsertSOSizeType(SOSizeTypeSetListInfo oParam)
{
new SOSizeTypeSetListDac().Insert(oParam);
}
