void LoadComBox()
 {
     BaseData.Store store = new BaseData.Store();
     store.StoreDT = store.SelectAllStoreInfo();
     foreach (DataRow dr in store.StoreDT.Rows)
     {
         cbDeliverStore.Items.Add(dr["StoreName"].ToString());
     }
     if (cbDeliverStore.Items.Count > 0)
     {
         cbDeliverStore.SelectedIndex = 0;
     }
     foreach (DataRow dr in store.StoreDT.Rows)
     {
         cbRecieveStore.Items.Add(dr["StoreName"].ToString());
     }
     if (cbRecieveStore.Items.Count > 0)
     {
         cbRecieveStore.SelectedIndex = 0;
     }
     cboExchangeType.Items.Add("N/A");
     cboExchangeType.Items.Add("新店预留");
     cboExchangeType.Items.Add("Pull Back");
     cboExchangeType.SelectedIndex = 0;
 }
Пример #2
0
        private void BtnSubmitAddApp_Click(object sender, EventArgs e)
        {
            BaseData.Store store = new BaseData.Store();
            //if (store.SelectStoreInfoByStoreName(txtDeliverStore4.Text).Rows.Count == 0 || store.SelectStoreInfoByStoreName(txtReceiptStore4.Text).Rows.Count == 0)
            //{
            //    MessageBox.Show("收发店铺名错误");
            //}
            if (AddApplicationDT.Rows.Count == 0)
            {
                MessageBox.Show("表中未添加转货内容");
            }
            else if (txtCtrlID.Text == null || txtCtrlID.Text.Length == 0)
            {
                MessageBox.Show("请填写控制单号");
            }
            else
            {
                int       TotalCount   = 0;
                double    TotalPrice   = 0;
                DataTable AddAppInfoDT = applicationInfo.SelectApplicationByCtrlID(applicationInfo.CtrlID);

                AddAppInfoDT.Rows[0]["WuliuID"] = txtWuliuID.Text;
                if (DeliverOrReceipt == "Deliver")
                {
                    AddAppInfoDT.Rows[0]["DeliverDate"] = dtAppDate.Value; AddAppInfoDT.Rows[0]["DeliverCheck"] = txtStoreCheck.Text;
                }
                else
                {
                    AddAppInfoDT.Rows[0]["ReceiptDate"] = dtAppDate.Value; AddAppInfoDT.Rows[0]["ReceiptCheck"] = txtStoreCheck.Text;
                }

                try
                {
                    AddApplicationDT.AcceptChanges();
                    AddAppInfoDT.AcceptChanges();
                    if (DeliverOrReceipt == "Deliver")
                    {
                        applicationDetail.UpdateDeliverDetail(AddApplicationDT);
                        applicationInfo.UpdateApplicationInfo(AddAppInfoDT);
                    }
                    else
                    {
                        applicationDetail.UpdateReceiptDetail(AddApplicationDT);
                        applicationInfo.UpdateApplicationInfo(AddAppInfoDT);
                    }
                    MessageBox.Show("提交成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    DialogResult = DialogResult.OK;
                    this.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("提交失败,错误信息:" + ex.Message);
                }
            }
        }
Пример #3
0
 void LoadComBox()
 {
     BaseData.Store store = new BaseData.Store();
     store.StoreDT = store.SelectAllStoreInfo();
     foreach (DataRow dr in store.StoreDT.Rows)
     {
         cbDeliverStore.Items.Add(dr["StoreName"].ToString());
     }
     if (cbDeliverStore.Items.Count > 0)
     {
         //cbDeliverStore.SelectedItem = Login.LoginUser.Store;
         cbDeliverStore.SelectedIndex = 0;
     }
     //foreach (DataRow dr in store.StoreDT.Rows)
     //{
     //    cbRecieveStore.Items.Add(dr["StoreName"].ToString());
     //}
     //if (cbRecieveStore.Items.Count > 0)
     //{
     //    //cbRecieveStore.SelectedIndex = 0;
     //    cbRecieveStore.SelectedItem = Login.LoginUser.Store;
     //}
     string[] strStoreTemp = Login.LoginUser.Store.ToString().Split(',');
     if (strStoreTemp[0] != "" && strStoreTemp[0] != null && strStoreTemp.Length > 1)
     {
         for (int i = 0; i < strStoreTemp.Length; i++)
         {
             if (strStoreTemp[i].ToString() != null && strStoreTemp[i].ToString() != "")
             {
                 cbRecieveStore.Items.Add(strStoreTemp[i].ToString());
             }
         }
     }
     else
     {
         cbRecieveStore.Items.Add(strStoreTemp[0]);
     }
     if (cbRecieveStore.Items.Count > 0)
     {
         cbRecieveStore.SelectedIndex = 0;
     }
     cboExchangeType.Items.Add("N/A");
     cboExchangeType.Items.Add("新店预留");
     cboExchangeType.Items.Add("Pull Back");
     cboExchangeType.SelectedIndex = 0;
 }
Пример #4
0
        private void BtnSubmitAddApp_Click(object sender, EventArgs e)
        {
            BaseData.Store store = new BaseData.Store();
            //if (store.SelectStoreInfoByStoreName(txtDeliverStore4.Text).Rows.Count == 0 || store.SelectStoreInfoByStoreName(txtReceiptStore4.Text).Rows.Count == 0)
            //{
            //    MessageBox.Show("收发店铺名错误");
            //}
            if (AddApplicationDT.Rows.Count == 0)
            {
                MessageBox.Show("申请表中未添加转货内容");
            }
            else if (txtCtrlID.Text == null || txtCtrlID.Text.Length == 0)
            {
                MessageBox.Show("请填写控制单号");
            }
            else if (cbDeliverStore.SelectedItem.ToString() == cbRecieveStore.SelectedItem.ToString())
            {
                MessageBox.Show("收发店面相同,无法添加");
            }
            else
            {
                int       TotalCount   = 0;
                double    TotalPrice   = 0;
                DataTable AddAppInfoDT = applicationInfo.SelectApplicationByCtrlID("0");
                DataRow   dr           = AddAppInfoDT.NewRow();
                dr["CtrlID"]         = txtCtrlID.Text;
                dr["DeliverStore"]   = cbDeliverStore.SelectedItem.ToString();
                dr["ReceiptStore"]   = cbRecieveStore.SelectedItem.ToString();
                dr["ApplicantsDate"] = DateTime.Now;
                dr["ApplicantsName"] = txtApplicant.Text;
                dr["ApplicantsPos"]  = txtApplicantPos.Text;
                dr["Applicants"]     = Login.LoginUser.UID;
                dr["Alert_Approval"] = 0;
                dr["Alert_Deliver"]  = 0;
                dr["Alert_Receipt"]  = 0;
                dr["ExchangeType"]   = cboExchangeType.SelectedItem.ToString();
                foreach (DataRow addDr in AddApplicationDT.Rows)
                {
                    addDr["CtrlID"] = dr["CtrlID"];
                    TotalCount     += (int)addDr["App_Count"];
                    TotalPrice     += ((int)addDr["App_Count"]) * ((double.Parse(addDr["Price"].ToString())));
                }
                dr["TotalCount"] = TotalCount;
                dr["TotalPrice"] = TotalPrice;
                AddAppInfoDT.Rows.Add(dr);

                if (TotalPrice > EmailControl.config.UpperLimit)
                {
                    DialogResult dres = MessageBox.Show("超出限额,是否继续提交?", "消息", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
                    if (dres == DialogResult.OK)
                    {
                        try
                        {
                            applicationInfo.SubmitApplicationInfo(AddAppInfoDT);
                            applicationDetail.SubmitApplicationDetail(AddApplicationDT);
                            Thread thread = new Thread(new ThreadStart(SendEmail));
                            thread.Start();
                            MessageBox.Show("提交成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            this.Close();
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show("提交失败,错误信息:" + ex.Message);
                        }
                    }
                }
                else
                {
                    try
                    {
                        applicationInfo.SubmitApplicationInfo(AddAppInfoDT);
                        applicationDetail.SubmitApplicationDetail(AddApplicationDT);
                        Thread thread = new Thread(new ThreadStart(SendEmail));
                        thread.Start();
                        MessageBox.Show("提交成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.Close();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("提交失败,错误信息:" + ex.Message);
                    }
                }
            }
        }
 private void BtnSubmitAddApp_Click(object sender, EventArgs e)
 {
     BaseData.Store store = new BaseData.Store();
     //if (store.SelectStoreInfoByStoreName(txtDeliverStore4.Text).Rows.Count == 0 || store.SelectStoreInfoByStoreName(txtReceiptStore4.Text).Rows.Count == 0)
     //{
     //    MessageBox.Show("收发店铺名错误");
     //}
     if (txtWuliuID.Text.Length < 1 && DeliverOrReceipt == "待发货")
     {
         MessageBox.Show("请填写物流单号");
     }
     else if (AddApplicationDT.Rows.Count == 0)
     {
         MessageBox.Show("申请表中未添加转货内容");
     }
     else if (txtCtrlID.Text == null || txtCtrlID.Text.Length == 0)
     {
         MessageBox.Show("请填写控制单号");
     }
     else
     {
         DataTable AddAppInfoDT = applicationInfo.SelectApplicationByCtrlID(applicationInfo.CtrlID);
         if (AddAppInfoDT.Rows.Count > 0)
         {
             AddAppInfoDT.Rows[0]["WuliuID"] = txtWuliuID.Text;
             if (DeliverOrReceipt == "待发货")
             {
                 AddAppInfoDT.Rows[0]["DeliverDate"] = dtAppDate.Value; AddAppInfoDT.Rows[0]["DeliverCheck"] = txtStoreCheck.Text;
             }
             else if (DeliverOrReceipt == "待收货")
             {
                 AddAppInfoDT.Rows[0]["ReceiptDate"] = dtAppDate.Value; AddAppInfoDT.Rows[0]["ReceiptCheck"] = txtStoreCheck.Text;
             }
         }
         try
         {
             if (DeliverOrReceipt == "待发货")
             {
                 applicationDetail.UpdateDeliverDetail(AddApplicationDT);
                 applicationInfo.UpdateApplicationInfo(AddAppInfoDT);
                 applicationInfo.DeliverConfirm(applicationInfo.CtrlID, txtStoreCheck.Text, Login.LoginUser, 1);
                 Thread thread = new Thread(new ThreadStart(SendEmailtoReceipt));
                 thread.Start();
             }
             else if (DeliverOrReceipt == "待收货")
             {
                 applicationDetail.UpdateReceiptDetail(AddApplicationDT);
                 applicationInfo.UpdateApplicationInfo(AddAppInfoDT);
                 applicationInfo.ReceiptConfirm(applicationInfo.CtrlID, txtStoreCheck.Text, Login.LoginUser, 1);
                 Thread thread = new Thread(new ThreadStart(SendEmailtoWuliu));
                 thread.Start();
             }
             MessageBox.Show("提交成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
             DialogResult = DialogResult.OK;
             this.Close();
         }
         catch (Exception ex)
         {
             MessageBox.Show("提交失败,错误信息:" + ex.Message);
         }
     }
 }
Пример #6
0
        private void BtnSubmitAddApp_Click(object sender, EventArgs e)
        {
            BaseData.Store store = new BaseData.Store();
            //if (store.SelectStoreInfoByStoreName(txtDeliverStore4.Text).Rows.Count == 0 || store.SelectStoreInfoByStoreName(txtReceiptStore4.Text).Rows.Count == 0)
            //{
            //    MessageBox.Show("收发店铺名错误");
            //}
            if (AddApplicationDT.Rows.Count == 0)
            {
                MessageBox.Show("申请表中未添加转货内容");
            }
            else if (txtCtrlID.Text == null || txtCtrlID.Text.Length == 0)
            {
                MessageBox.Show("请填写控制单号");
            }
            else
            {
                frmEditReason fer = new frmEditReason(applicationInfo.EditReason);
                if (fer.ShowDialog() == DialogResult.OK)
                {
                    int       TotalCount   = 0;
                    double    TotalPrice   = 0;
                    DataTable AddAppInfoDT = applicationInfo.SelectApplicationByCtrlID(applicationInfo.CtrlID);
                    AddAppInfoDT.Rows[0]["EditReason"]     = fer.EditReasonString;
                    AddAppInfoDT.Rows[0]["CtrlID"]         = txtCtrlID.Text;
                    AddAppInfoDT.Rows[0]["DeliverStore"]   = cbDeliverStore.SelectedItem.ToString();
                    AddAppInfoDT.Rows[0]["ReceiptStore"]   = cbRecieveStore.SelectedItem.ToString();
                    AddAppInfoDT.Rows[0]["ApplicantsDate"] = dtAppDate.Value;
                    AddAppInfoDT.Rows[0]["ApplicantsName"] = txtApplicant.Text;
                    AddAppInfoDT.Rows[0]["ApplicantsPos"]  = txtApplicantPos.Text;
                    AddAppInfoDT.Rows[0]["Applicants"]     = Login.LoginUser.UID;
                    AddAppInfoDT.Rows[0]["ExchangeType"]   = cboExchangeType.SelectedItem.ToString();

                    foreach (DataGridViewRow addDr in dgvApplyProducts.Rows)
                    {
                        //addDr["CtrlID"] = AddAppInfoDT.Rows[0]["CtrlID"];
                        TotalCount += (int)addDr.Cells["numbers"].Value;
                        TotalPrice += ((int)addDr.Cells["numbers"].Value) * ((double.Parse(addDr.Cells["price"].Value.ToString())));
                    }
                    AddAppInfoDT.Rows[0]["TotalCount"] = TotalCount;
                    AddAppInfoDT.Rows[0]["TotalPrice"] = TotalPrice;

                    //foreach(DataRow dr in AddApplicationDT.Rows)
                    //{
                    //    dr["CtrlID"] = txtCtrlID.Text;
                    //}

                    if (Login.LoginUser.Character == 1)
                    {
                        if ((int)AddAppInfoDT.Rows[0]["ApprovalState"] != 1)
                        {
                            AddAppInfoDT.Rows[0]["ApprovalState"] = 0;
                        }
                        if ((int)AddAppInfoDT.Rows[0]["ApprovalState2"] != 1)
                        {
                            AddAppInfoDT.Rows[0]["ApprovalState2"] = 0;
                        }
                        if ((int)AddAppInfoDT.Rows[0]["DeliverState"] != 1)
                        {
                            AddAppInfoDT.Rows[0]["DeliverState"] = 0;
                        }
                        if ((int)AddAppInfoDT.Rows[0]["ReceiptState"] != 1)
                        {
                            AddAppInfoDT.Rows[0]["ReceiptState"] = 0;
                        }
                    }
                    if (TotalPrice > EmailControl.config.UpperLimit)
                    {
                        DialogResult dres = MessageBox.Show("超出限额,是否继续提交?", "消息", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
                        if (dres == DialogResult.OK)
                        {
                            try
                            {
                                applicationInfo.UpdateApplicationInfo(AddAppInfoDT);
                                applicationDetail.UpdateApplicationDetail(AddApplicationDT);
                                MessageBox.Show("提交成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                                DialogResult = DialogResult.OK;
                                this.Close();
                            }
                            catch (Exception ex)
                            {
                                MessageBox.Show("提交失败,错误信息:" + ex.Message);
                            }
                        }
                    }
                    else
                    {
                        try
                        {
                            applicationInfo.UpdateApplicationInfo(AddAppInfoDT);
                            applicationDetail.UpdateApplicationDetail(AddApplicationDT);
                            MessageBox.Show("提交成功", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            DialogResult = DialogResult.OK;
                            this.Close();
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show("提交失败,错误信息:" + ex.Message);
                        }
                    }
                }
            }
        }