예제 #1
0
        /// <summary>
        /// 新增資料
        /// </summary>
        protected void btn_add_Click(object sender, EventArgs e)
        {
            if (txt_ID.Text.Trim() != "")
            {
                RedGlovePermission.Model.Basic_Companies model = new RedGlovePermission.Model.Basic_Companies();

                model.Company = txt_ID.Text.Trim();
                model.Track = txt_Track.Text.Trim();
                model.Description = txt_Name.Text.Trim();
                UserSession user = SessionBox.GetUserSession();
                model.Creator = user.LoginName.ToString();
                model.Create_Date = DateTime.Now.ToString("yyyyMMdd");

                if (!bll.Exists(txt_ID.Text.Trim()))
                {
                    if (bll.CreateCompany(model))
                    {
                        ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_true") + "')", true);
                    }
                    else
                    {
                        ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "')", true);
                    }
                    txt_ID.Text = "";
                    txt_Track.Text = "";
                    txt_Name.Text = "";
                    BindOrder();
                }
                else
                {
                    ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_IsCustomer") + "')", true);
                }
            }
        }
예제 #2
0
        /// <summary>
        /// 更新資料
        /// </summary>
        protected void CompaniesLists_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            RedGlovePermission.Model.Basic_Companies model = new RedGlovePermission.Model.Basic_Companies();
            model.Company = CompaniesLists.DataKeys[e.RowIndex].Values[0].ToString();
            model.Track = ((TextBox)CompaniesLists.Rows[e.RowIndex].FindControl("txt_Track")).Text.Trim();
            model.Description = ((TextBox)CompaniesLists.Rows[e.RowIndex].FindControl("txt_Name")).Text.Trim();
            UserSession user = SessionBox.GetUserSession();
            model.Modifier = user.LoginName.ToString();
            model.Modi_Date = DateTime.Now.ToString("yyyyMMdd");

            if (!bll.UpdateCompany(model))
            {
                ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_false") + "')", true);
            }
            //返回瀏覽狀態
            CompaniesLists.EditIndex = -1;
            BindOrder2();
        }
예제 #3
0
        protected void gvMaster_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "InsertNewM")
            {
                //TextBox tbOrderID = (TextBox)gvMaster.Controls[0].Controls[0].FindControl("tbOrderID");
                TextBox tbMA001 = (TextBox)gvMaster.Controls[0].Controls[0].FindControl("tbMA001");
                TextBox tbCompany = (TextBox)gvMaster.Controls[0].Controls[0].FindControl("tbCompany");
                TextBox tbReturn_Date = (TextBox)gvMaster.Controls[0].Controls[0].FindControl("tbReturn_Date");
                TextBox tbCaseNo = (TextBox)gvMaster.Controls[0].Controls[0].FindControl("tbCaseNo");
                DropDownList ddlDepartment = (DropDownList)gvMaster.Controls[0].Controls[0].FindControl("ddl_Department");
                DropDownList ddlTaxRate = (DropDownList)gvMaster.Controls[0].Controls[0].FindControl("ddl_TaxRate");
                TextBox tbRemark = (TextBox)gvMaster.Controls[0].Controls[0].FindControl("tbRemark");

                //if (tbOrderID != null)
                //    dsMaster.InsertParameters["OrderID"].DefaultValue = tbOrderID.Text;
                RedGlovePermission.Model.Basic_Companies model = new RedGlovePermission.Model.Basic_Companies();
                model = bll.GetCCompanyModel(CompanyList.SelectedItem.ToString());
                dsMaster.InsertParameters["ReturnID"].DefaultValue = bllReturn.GetNewReturnID(model.Track + DateTime.Now.ToString("yyyyMMdd"));
                if (tbMA001 != null)
                    dsMaster.InsertParameters["MA001"].DefaultValue = tbMA001.Text;
                dsMaster.InsertParameters["COMPANY"].DefaultValue = CompanyList.SelectedItem.ToString();
                if (tbReturn_Date != null)
                    dsMaster.InsertParameters["Return_DATE"].DefaultValue = tbReturn_Date.Text;
                if (tbCaseNo != null)
                    dsMaster.InsertParameters["CaseNo"].DefaultValue = tbCaseNo.Text;
                dsMaster.InsertParameters["Department"].DefaultValue = ddlDepartment.SelectedValue;
                dsMaster.InsertParameters["TaxRate"].DefaultValue = ddlTaxRate.SelectedValue;
                if (tbRemark != null)
                    dsMaster.InsertParameters["Remark"].DefaultValue = tbRemark.Text;
                UserSession user = SessionBox.GetUserSession();
                dsMaster.InsertParameters["CREATOR"].DefaultValue = user.LoginName.ToString();
                dsMaster.InsertParameters["CREATE_DATE"].DefaultValue = DateTime.Now.ToString("yyyyMMdd");
                int aff_row = dsMaster.Insert();
                if (aff_row == 0)
                {
                    ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "');", true);
                    _hfSearch.Value = "";
                }
                else 
                //{
                //    ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_add_true") + dsMaster.InsertParameters["OrderID"].DefaultValue.ToString() + "');", true);
                //    _hfSearch.Value = "";
                //}
                    _hfSearch.Value = "ReturnID='" + dsMaster.InsertParameters["ReturnID"].DefaultValue.ToString() + "'";
                BindData();
            }
            if (e.CommandName == "InsertCancelM")
            {
                _hfSearch.Value = "";
                BindData();
            }
            //if (e.CommandName == "Prt")
            //{}
        }
예제 #4
0
        protected void gvChild_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            GridViewRow gvr = (GridViewRow)((GridView)sender).NamingContainer;
            HiddenField _hfChildSearch = (HiddenField)gvr.FindControl("_hfChildSearch");
            SqlDataSource dsChild = (SqlDataSource)gvr.FindControl("dsChild");

            if (e.CommandName == "InsertNew")
            {
                //TextBox tbSeq = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbSeq");
                TextBox tbMB001 = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbMB001");
                TextBox tbQty = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbQty");
                TextBox tbUnitPrice = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbUnitPrice");
                TextBox tbDiscount = (TextBox)((GridView)sender).Controls[0].Controls[0].FindControl("tbDiscount");
                //if (tbSeq != null)
                //    dsChild.InsertParameters["Seq"].DefaultValue = tbSeq.Text;
                RedGlovePermission.Model.Basic_Companies model = new RedGlovePermission.Model.Basic_Companies();
                model = bll.GetCCompanyModel(CompanyList.SelectedItem.ToString());
                dsChild.InsertParameters["Seq"].DefaultValue = bllReturn.GetNewReturnSeq(gvr.Cells[5].Text);
                if (tbMB001 != null)
                    dsChild.InsertParameters["MB001"].DefaultValue = tbMB001.Text;
                if (tbQty != null)
                    dsChild.InsertParameters["Qty"].DefaultValue = tbQty.Text;
                if (tbUnitPrice != null)
                    dsChild.InsertParameters["unitPrice"].DefaultValue = tbUnitPrice.Text;
                if (tbDiscount != null)
                    dsChild.InsertParameters["Discount"].DefaultValue = tbDiscount.Text;
                else
                    dsChild.InsertParameters["Discount"].DefaultValue = "1";
                dsChild.InsertParameters["ReturnId"].DefaultValue = gvr.Cells[5].Text;
                UserSession user = SessionBox.GetUserSession();
                dsChild.InsertParameters["CREATOR"].DefaultValue = user.LoginName.ToString();
                dsChild.InsertParameters["CREATE_DATE"].DefaultValue = DateTime.Now.ToString("yyyyMMdd");
                dsChild.Insert();
                //處理單頭合計及稅額
                if (bllReturn.ReturnTotal(gvr.Cells[5].Text) == 0)
                    ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_total_false") + "');", true);
                else
                {
                    RedGlovePermission.Model.Sales_Return Returnmodel = new RedGlovePermission.Model.Sales_Return();
                    Returnmodel = bllReturn.GetReturnModel(gvr.Cells[5].Text);
                    gvr.Cells[13].Text = Returnmodel.Amount.ToString();
                    gvr.Cells[14].Text = Returnmodel.Tax.ToString();
                }
                ScriptManager.RegisterStartupScript(Page, GetType(), Guid.NewGuid().ToString(), "alert('" + ResourceManager.GetString("Pub_Msg_update_true") + "');", true);
                _hfChildSearch.Value = "";
                BindChildData((GridView)sender);
            }
            if (e.CommandName == "InsertCancel")
            {
                _hfChildSearch.Value = "";
                BindChildData((GridView)sender);
            }
        }
예제 #5
0
        /// <summary>
        /// 得到一家公司資料
        /// </summary>
        /// <param name="Company">公司名</param>
        /// <returns></returns>
        public RedGlovePermission.Model.Basic_Companies GetCompanyModel(string Company)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select top 1 Company,Description,Track from Basic_Company ");
            strSql.Append(" where Company=@Company ");
            SqlParameter[] parameters = {
					new SqlParameter("@Company", SqlDbType.Char,10)};
            parameters[0].Value = Company;

            RedGlovePermission.Model.Basic_Companies model = new RedGlovePermission.Model.Basic_Companies();
            DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                //if (ds.Tables[0].Rows[0]["MA001"].ToString() != "")
                //{
                model.Company = ds.Tables[0].Rows[0]["Company"].ToString();
                //}
                model.Track = ds.Tables[0].Rows[0]["Track"].ToString();
                model.Description = ds.Tables[0].Rows[0]["Description"].ToString();
                return model;
            }
            else
            {
                return null;
            }
        }