示例#1
0
 public static bool AddCurve(string Code, WSV.Model.Weight.WeightModel value)
 {
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new DAL.MyLog.DL_WeightVisitor();
     bool retvalue = true;
     SqlParameter[] prams ={
         db.MakeInParam("@Code",SqlDbType.VarChar,50,Code)
     };
     SqlDataReader Reader = null;
     try
     {
         db.GetDataReader(visitor, prams, out Reader, "AddCurve");
         if (Reader.Read())
         {
             value.StateFun.Curve = (byte[])Reader["Curve"];
         }
         else
         {
             retvalue = false;
         }
     }
     catch (Exception e)
     {
         db.Dispose();
         return false;
     }
     finally
     {
         db.Dispose();
     }
     return retvalue;
 }
示例#2
0
 /// <summary>
 /// 添加数据
 /// </summary>
 /// <param name="Item">model</param>
 /// <returns></returns>
 public static string AddData(WSV.Model.Weight.WeightModel Weight)
 {
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new WSV.DAL.MyLog.OperData();
     bool bSuc = false;
     int nEffectRows = 0;
     SqlParameter[] prams ={
         db.MakeInParam("@ID", SqlDbType.Int,4, BLL.PublicFun.PublicFun.MaxId("D_Saver")),
         db.MakeInParam("@Code", SqlDbType.VarChar,50, Weight.Code),
         db.MakeInParam("@CarCode", SqlDbType.VarChar,50, Weight.Txt.CarCode),
         db.MakeInParam("@Item", SqlDbType.VarChar,50, Weight.Txt.Item),
         db.MakeInParam("@Specs", SqlDbType.VarChar,50, Weight.Txt.Specs),
         db.MakeInParam("@Place", SqlDbType.VarChar,50, Weight.Txt.Place),
         db.MakeInParam("@Send", SqlDbType.VarChar,50, Weight.Txt.Send),
         db.MakeInParam("@Accept", SqlDbType.VarChar,50, Weight.Txt.Accept),
         db.MakeInParam("@Carry", SqlDbType.VarChar,50, Weight.Txt.Carry),
         db.MakeInParam("@Model", SqlDbType.VarChar,50, Weight.Txt.Model),
         db.MakeInParam("@Driver", SqlDbType.VarChar,50, Weight.Txt.Driver),
         db.MakeInParam("@Spare", SqlDbType.VarChar,50, Weight.Txt.Spare),
         db.MakeInParam("@Type", SqlDbType.VarChar,50, Weight.Txt.Type),
         db.MakeInParam("@Card", SqlDbType.VarChar,50, Weight.Txt.Card),
         db.MakeInParam("@Plan_Code", SqlDbType.VarChar,50, Weight.Txt.Plan_Code),
         db.MakeInParam("@G_Table", SqlDbType.VarChar,50, Weight.StateFun.G_Table),
         db.MakeInParam("@T_Table", SqlDbType.VarChar,50, Weight.StateFun.T_Table),
         db.MakeInParam("@G_Oper", SqlDbType.VarChar,50, Weight.StateFun.G_Oper),
         db.MakeInParam("@T_Oper", SqlDbType.VarChar,50, Weight.StateFun.T_Oper),
         db.MakeInParam("@Gross", SqlDbType.Decimal, 10, Weight.Float.Gross),
         db.MakeInParam("@Tare", SqlDbType.Decimal, 10, Weight.Float.Tare),
         db.MakeInParam("@Net", SqlDbType.Decimal, 10, Weight.Float.Net),
         db.MakeInParam("@EndNet", SqlDbType.Decimal, 10, Weight.Float.EndNet),
         db.MakeInParam("@Impurity", SqlDbType.Decimal, 10, Weight.Float.Impurity),
         db.MakeInParam("@ImpurityRate", SqlDbType.Decimal, 10, Weight.Float.ImpurityRate),
         db.MakeInParam("@DeductWei", SqlDbType.Decimal, 10, Weight.Float.DeductWei),
         db.MakeInParam("@DeductRate", SqlDbType.Decimal, 10, Weight.Float.DeductRate),
         db.MakeInParam("@Cube", SqlDbType.Decimal, 10, Weight.Float.Cube),
         db.MakeInParam("@Cubety", SqlDbType.Decimal, 10, Weight.Float.Cubety),
         db.MakeInParam("@InhereWei", SqlDbType.Decimal, 10, Weight.Float.InhereWei),
         db.MakeInParam("@DifferWei", SqlDbType.Decimal, 10, Weight.Float.DifferWei),
         db.MakeInParam("@Price", SqlDbType.Decimal, 10, Weight.Float.Price),
         db.MakeInParam("@Money", SqlDbType.Decimal, 10, Weight.Float.Money),
         db.MakeInParam("@State", SqlDbType.Decimal, 10, Weight.StateFun.State),
         db.MakeInParam("@G_Time", SqlDbType.VarChar, 50, Weight.StateFun.G_Time),
         db.MakeInParam("@T_Time", SqlDbType.VarChar, 50, Weight.StateFun.T_Time),
         db.MakeInParam("@N_Time", SqlDbType.VarChar, 50, Weight.StateFun.N_Time),
     };
     try
     {
         bSuc = db.TransactSql(visitor, "AddData", prams, out nEffectRows);
     }
     catch (Exception ex) { throw new Exception(ex.Message); }
     finally
     {
         db.Dispose();
     }
     if (bSuc && nEffectRows > 0)
         return "0101";
     else
         return "0";
 }
示例#3
0
 /// <summary>
 /// 读取主表数据库数据
 /// </summary>
 /// <param name="Weight">model</param>
 public static void GetDate(ref WSV.Model.Weight.WeightModel Weight)
 {
     DataBase db = new DataBase();
     DataBaseVisitor visitor = new WSV.DAL.MyLog.OperData();
     SqlDataReader oddr = null;
     SqlParameter[] prams ={
         db.MakeInParam("@Code", SqlDbType.VarChar,50, Weight.Code),
     };
     try
     {
         db.GetDataReader(visitor, prams, out oddr, "SelectByCode");
         if (oddr.Read())
         {
             Weight.StateFun.Verify = Convert.ToBoolean(oddr["Verify"]);
             Weight.StateFun.Used = Convert.ToBoolean(oddr["Used"]);
             Weight.Txt.CarCode = oddr["CarCode"].ToString();
             Weight.Txt.Item = oddr["Item"].ToString();
             Weight.Txt.Specs = oddr["Specs"].ToString();
             Weight.Txt.Place = oddr["Place"].ToString();
             Weight.Txt.Send = oddr["Send"].ToString();
             Weight.Txt.Accept = oddr["Accept"].ToString();
             Weight.Txt.Carry = oddr["Carry"].ToString();
             Weight.Txt.Model = oddr["Model"].ToString();
             Weight.Txt.Driver = oddr["Driver"].ToString();
             Weight.Txt.Spare = oddr["Spare"].ToString();
             Weight.Txt.Card = oddr["Card"].ToString();
             Weight.Txt.Plan_Code = oddr["Plan_Code"].ToString();
             Weight.Txt.Type = oddr["Type"].ToString();
             Weight.StateFun.G_Oper = oddr["G_Oper"].ToString();
             Weight.StateFun.T_Oper = oddr["T_Oper"].ToString();
             Weight.StateFun.G_Table = oddr["G_Table"].ToString();
             Weight.StateFun.T_Table = oddr["T_Table"].ToString();
             Weight.Float.Gross = Convert.ToDecimal(oddr["Gross"]);
             Weight.Float.Tare = Convert.ToDecimal(oddr["Tare"]);
             Weight.Float.Net = Convert.ToDecimal(oddr["Net"]);
             Weight.Float.EndNet = Convert.ToDecimal(oddr["EndNet"]);
             Weight.Float.Impurity = Convert.ToDecimal(oddr["Impurity"]);
             Weight.Float.ImpurityRate = Convert.ToDecimal(oddr["ImpurityRate"]);
             Weight.Float.DeductWei = Convert.ToDecimal(oddr["DeductWei"]);
             Weight.Float.DeductRate = Convert.ToDecimal(oddr["DeductRate"]);
             Weight.Float.Cube = Convert.ToDecimal(oddr["Cube"]);
             Weight.Float.InhereWei = Convert.ToDecimal(oddr["InhereWei"]);
             Weight.Float.DifferWei = Convert.ToDecimal(oddr["DifferWei"]);
             Weight.Float.Price = Convert.ToDecimal(oddr["Price"]);
             Weight.Float.Money = Convert.ToDecimal(oddr["Money"]);
         }
     }
     catch (Exception ex) { throw new Exception(ex.Message); }
     finally
     {
         oddr.Close();
         db.Dispose();
     }
 }
示例#4
0
 private void Round(WSV.Control.MyComboBox.MyComboBox Cmb)
 {
     Cmb.Items.Add("四舍五入", 0);
     Cmb.Items.Add("抹除取整", 1);
 }
示例#5
0
 private void Digit(WSV.Control.MyComboBox.MyComboBox Cmb)
 {
     Cmb.Items.Add("一位小数", 1);
     Cmb.Items.Add("两位小数", 2);
     Cmb.Items.Add("三位小数", 3);
 }