public int Insert(Size2Info oParam) { string sql = @"INSERT INTO Size2 ( Size1SysNo, Size2ID, Size2Name, Status ) VALUES ( @Size1SysNo, @Size2ID, @Size2Name, @Status )"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSize1SysNo = new SqlParameter("@Size1SysNo", SqlDbType.Int, 4); SqlParameter paramSize2ID = new SqlParameter("@Size2ID", SqlDbType.NVarChar, 20); SqlParameter paramSize2Name = new SqlParameter("@Size2Name", SqlDbType.NVarChar, 200); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); paramSize1SysNo.Value = oParam.Size1SysNo; paramSize2ID.Value = oParam.Size2ID; paramSize2Name.Value = oParam.Size2Name; paramStatus.Value = oParam.Status; cmd.Parameters.Add(paramSize1SysNo); cmd.Parameters.Add(paramSize2ID); cmd.Parameters.Add(paramSize2Name); cmd.Parameters.Add(paramStatus); return(SqlHelper.ExecuteNonQuery(cmd)); }
public int Update(Size2Info oParam) { string sql = @"UPDATE Size2 SET Size1SysNo=@Size1SysNo, Size2ID=@Size2ID, Size2Name=@Size2Name, Status=@Status WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSize1SysNo = new SqlParameter("@Size1SysNo", SqlDbType.Int, 4); SqlParameter paramSize2ID = new SqlParameter("@Size2ID", SqlDbType.NVarChar, 20); SqlParameter paramSize2Name = new SqlParameter("@Size2Name", SqlDbType.NVarChar, 200); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); paramSysNo.Value = oParam.SysNo; paramSize1SysNo.Value = oParam.Size1SysNo; paramSize2ID.Value = oParam.Size2ID; paramSize2Name.Value = oParam.Size2Name; paramStatus.Value = oParam.Status; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSize1SysNo); cmd.Parameters.Add(paramSize2ID); cmd.Parameters.Add(paramSize2Name); cmd.Parameters.Add(paramStatus); return(SqlHelper.ExecuteNonQuery(cmd)); }
private void map(Size2Info oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.Size1SysNo = Util.TrimIntNull(tempdr["Size1SysNo"]); oParam.Size2ID = Util.TrimNull(tempdr["Size2ID"]); oParam.Size2Name = Util.TrimNull(tempdr["Size2Name"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); oParam.Size2Img = Util.TrimNull(tempdr["Size2Img"]); }
public void UpdateSize2(Size2Info oParam) { string sql = "select * from size2 where Size2ID=" + oParam.Size2ID + " and SysNo<>" + oParam.SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { throw new BizException("相同ID编号的尺码已存在"); } new SizeDac().Update(oParam); }
public Size2Info LoadSize2(int SysNo) { string sql = "select * from size2 where sysno=" + SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (!Util.HasMoreRow(ds)) { return(null); } Size2Info oInfo = new Size2Info(); map(oInfo, ds.Tables[0].Rows[0]); return(oInfo); }
public void InsertSize2(Size2Info oParam) { new SizeDac().Insert(oParam); }