Exemplo n.º 1
0
        public bool InsertData(string userID, ProductMonthData data)
        {
            bool ret = true;

            DALObj.PRODUCT = DALObj.doGetProduct(data.CODE);
            DALObj.M1 = data.Month[0];
            DALObj.M2 = data.Month[1];
            DALObj.M3 = data.Month[2];
            DALObj.M4 = data.Month[3];
            DALObj.M5 = data.Month[4];
            DALObj.M6 = data.Month[5];
            DALObj.M7 = data.Month[6];
            DALObj.M8 = data.Month[7];
            DALObj.M9 = data.Month[8];
            DALObj.M10 = data.Month[9];
            DALObj.M11 = data.Month[10];
            DALObj.M12 = data.Month[11];
         
            OracleDBObj obj = new OracleDBObj();
            obj.CreateConnection();
            obj.CreateTransaction();
            try
            {
                ret = DALObj.InsertCurrentData(userID, obj.zTrans);
                if (!ret)
                {
                    throw new ApplicationException(DALObj.ErrorMessage);
                }
                obj.zTrans.Commit();
                obj.CloseConnection();
            }
            catch (Exception ex)
            {
                obj.zTrans.Rollback();
                obj.CloseConnection();
                ret = false;
                throw new ApplicationException(ex.Message);
            }
            return ret;
        }
Exemplo n.º 2
0
        public ProductMonthData GetData(double PRODUCT)
        {
            ProductMonthData data = new ProductMonthData();
            if (DALObj.GetDataByPRODUCT(PRODUCT, null))
            {
                data.LOID = DALObj.LOID;
                data.PRODUCT = DALObj.PRODUCT;
                data.Month[0] = DALObj.M1;
                data.Month[1] = DALObj.M2;
                data.Month[2] = DALObj.M3;
                data.Month[3] = DALObj.M4;
                data.Month[4] = DALObj.M5;
                data.Month[5] = DALObj.M6;
                data.Month[6] = DALObj.M7;
                data.Month[7] = DALObj.M8;
                data.Month[8] = DALObj.M9;
                data.Month[9] = DALObj.M10;
                data.Month[10] = DALObj.M11;
                data.Month[11] = DALObj.M12;

            }
            return data;
        }
Exemplo n.º 3
0
 private void SetData2(ProductMonthData data2)
 {
     for (int i = 0; i < data2.Month.Length; i++)
     {
         if (data2.Month[i] == "1")
             chkMonth.Items[i].Selected = true;
         else
             chkMonth.Items[i].Selected = false;
     }
 }
Exemplo n.º 4
0
    private ProductMonthData GetData2()
    {
        ProductMonthData data2 = new ProductMonthData();
        string[] m = new string[12];

        foreach (ListItem item in chkMonth.Items)
        {
            if (item.Selected)
                m[int.Parse(item.Value) - 1] = "1";
            else
                m[int.Parse(item.Value) - 1] = "0";
        }
        data2.Month = m;
        data2.CODE = this.txtCode.Text.Trim();
        data2.PRODUCT = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);

        return data2;
    }