public void AddWare_Bill_Count_Extend(int lgIndex, SqlCommand cmd, MWare_Bill_Count_Extend model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Ware_Bill_Count_Extend("); strSql.Append("ID,SumQty1,SumQty2,SumQty)"); strSql.Append(" values ("); strSql.Append("@ID,@SumQty1,@SumQty2,@SumQty)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 25), new SqlParameter("@SumQty1", SqlDbType.Int, 4), new SqlParameter("@SumQty2", SqlDbType.Int, 4), new SqlParameter("@SumQty", SqlDbType.Int, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.SumQty1; parameters[2].Value = model.SumQty2; parameters[3].Value = model.SumQty; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }
public void UpdateWare_Bill_Count_Extend(int lgIndex, SqlCommand cmd, MWare_Bill_Count_Extend model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Ware_Bill_Count_Extend set "); strSql.Append("SumQty1=@SumQty1,"); strSql.Append("SumQty2=@SumQty2,"); strSql.Append("SumQty=@SumQty"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@SumQty1", SqlDbType.Int, 4), new SqlParameter("@SumQty2", SqlDbType.Int, 4), new SqlParameter("@SumQty", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = model.SumQty1; parameters[1].Value = model.SumQty2; parameters[2].Value = model.SumQty; parameters[3].Value = model.ID; cmd.ExecuteMyQuery(strSql.ToString(), parameters); }