public static dbo_RevenueExpenseClass SumBySP(string User_ID) { dbo_RevenueExpenseClass clsdbo_RevenueExpense = new dbo_RevenueExpenseClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "[dbo].[RevenueExpenseSumBySP]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@User_ID", User_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_RevenueExpense.Amount = reader["Amount"] is DBNull ? null : (Decimal?)reader["Amount"]; } else { clsdbo_RevenueExpense = null; } reader.Close(); } catch (SqlException) { return(clsdbo_RevenueExpense); } finally { connection.Close(); } return(clsdbo_RevenueExpense); }
protected void GridViewExpense_RowCommand(object sender, GridViewCommandEventArgs e) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); if (e.CommandName == "AddNew") { string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID); try { dbo_RevenueExpenseClass rev = new dbo_RevenueExpenseClass(); rev.Post_No = txtPost_No.Text;// GenerateID.Post_No(user_class.CV_CODE); rev.CV_Code = user_class.CV_CODE; rev.Post_Date = DateTime.Now; TextBox txtFooterRevenue_Amount = (TextBox)GridViewExpense.FooterRow.FindControl("txtFooter_Amount"); rev.Amount = txtFooterRevenue_Amount.Text == "" ? 0 : decimal.Parse(txtFooterRevenue_Amount.Text); DropDownList _ddlFooterDetail = (DropDownList)GridViewExpense.FooterRow.FindControl("ddlFooterDetail"); rev.Account_Code = _ddlFooterDetail.SelectedValue; rev.Account_No = GenerateID.EP(user_class.CV_CODE); TextBox txtFooterRemark = (TextBox)GridViewExpense.FooterRow.FindControl("txtFooterRemark"); rev.Remark = txtFooterRemark.Text; bool succes = false; succes = dbo_RevenueExpenseDataClass.Add(rev); if (succes) { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("บันทึกสำเร็จ!"); } GridViewExpense.ShowFooter = false; InitialExpense(); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); } catch (Exception ex) { logger.Error(ex.Message); } } else if (e.CommandName == "_Delete") { LinkButton lnkView = (LinkButton)e.CommandSource; string Account_No = lnkView.CommandArgument; dbo_RevenueExpenseDataClass.Delete(Account_No); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("ลบข้อมูลสำเร็จ"); InitialExpense(); } }
protected void GridViewRevenue_Expense_RowCommand(object sender, GridViewCommandEventArgs e) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); if (e.CommandName == "_Delete") { LinkButton lnkView = (LinkButton)e.CommandSource; string Post_No = lnkView.CommandArgument; dbo_RevenueExpenseDataClass.DeletebyPostNo(Post_No); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("ลบข้อมูลสำเร็จ"); btnSearchSubmit_Click(null, null); } else if (e.CommandName == "View") { LinkButton lnkView = (LinkButton)e.CommandSource; string Post_No = lnkView.CommandArgument; pnlForm.Visible = true; pnlGrid.Visible = false; string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; dbo_UserClass user_class = dbo_UserDataClass.Select_Record(User_ID); List <dbo_RevenueExpenseClass> item = dbo_RevenueExpenseDataClass.Search(Post_No, null, null, user_class.CV_CODE); List <dbo_RevenueExpenseClass> item_rv = item.Where(f => f.Account_No.Substring(6, 2) == "RV").ToList(); List <dbo_RevenueExpenseClass> item_ep = item.Where(f => f.Account_No.Substring(6, 2) == "EP").ToList(); dbo_RevenueExpenseClass it = item.FirstOrDefault(); txtPost_Date.Text = Convert.ToDateTime(it.Post_Date).ToString("dd/MM/yyyy"); //txtPost_Date.Text = Convert.ToString(it.Post_Date); txtPost_No.Text = Post_No; Textbox1.Text = item_rv.Sum(f => f.Amount).Value.ToString("#,##0.##"); Textbox2.Text = item_ep.Sum(f => f.Amount).Value.ToString("#,##0.##"); GridViewRevenue.DataSource = item_rv; GridViewRevenue.DataBind(); GridViewExpense.DataSource = item_ep; GridViewExpense.DataBind(); } }
protected void GridViewExpense_RowUpdating(object sender, GridViewUpdateEventArgs e) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); try { int RowIndex = Convert.ToInt32((e.RowIndex).ToString()); Label _Account_No = (Label)GridViewExpense.Rows[RowIndex].FindControl("lblAccount_No"); DropDownList _ddlEditDetail = (DropDownList)GridViewExpense.Rows[RowIndex].FindControl("ddlEditDetail"); TextBox _txtEditRevenue_Amount = (TextBox)GridViewExpense.Rows[RowIndex].FindControl("txtEdit_Amount"); TextBox _txtEditRemark = (TextBox)GridViewExpense.Rows[RowIndex].FindControl("txtEditRemark"); dbo_RevenueExpenseClass st = new dbo_RevenueExpenseClass(); st = dbo_RevenueExpenseDataClass.Select_Record(_Account_No.Text); st.Amount = _txtEditRevenue_Amount.Text == "" ? 0 : Decimal.Parse(_txtEditRevenue_Amount.Text.Replace(",", string.Empty)); st.Remark = _txtEditRemark.Text; bool success = false; string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; success = dbo_RevenueExpenseDataClass.Update(st); if (success) { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("บันทึกสำเร็จ!"); } InitialExpense(); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); } catch (Exception ex) { logger.Error(ex.Message); } }
/* * public static dbo_RevenueExpenseClass Select_Record(dbo_RevenueExpenseClass clsdbo_RevenueExpensePara) * { * dbo_RevenueExpenseClass clsdbo_RevenueExpense = new dbo_RevenueExpenseClass(); * SqlConnection connection = SAMDataClass.GetConnection(); * string selectProcedure = "[dbo].[RevenueExpenseSelect]"; * SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); * selectCommand.CommandType = CommandType.StoredProcedure; * selectCommand.Parameters.AddWithValue("@Post_Date", clsdbo_RevenueExpensePara.Post_Date); * try * { * connection.Open(); * SqlDataReader reader * = selectCommand.ExecuteReader(CommandBehavior.SingleRow); * if (reader.Read()) * { * clsdbo_RevenueExpense.Post_Date = reader["Post_Date"] is DBNull ? null : (DateTime?)reader["Post_Date"]; * clsdbo_RevenueExpense.Post_No = reader["Post_No"] is DBNull ? null : reader["Post_No"].ToString(); * clsdbo_RevenueExpense.Account_No = reader["Account_No"] is DBNull ? null : reader["Account_No"].ToString(); * clsdbo_RevenueExpense.Account_Code = reader["Account_Code"] is DBNull ? null : reader["Account_Code"].ToString(); * clsdbo_RevenueExpense.Amount = reader["Amount"] is DBNull ? null : (Decimal?)reader["Amount"]; * clsdbo_RevenueExpense.Remark = reader["Remark"] is DBNull ? null : reader["Remark"].ToString(); * } * else * { * clsdbo_RevenueExpense = null; * } * reader.Close(); * } * catch (SqlException) * { * return clsdbo_RevenueExpense; * } * finally * { * connection.Close(); * } * return clsdbo_RevenueExpense; * }*/ public static dbo_RevenueExpenseClass Select_Record(string Account_No) { dbo_RevenueExpenseClass clsdbo_RevenueExpense = new dbo_RevenueExpenseClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "[dbo].[RevenueExpenseSelectbyAccountNo]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@Account_No", Account_No); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_RevenueExpense.Post_Date = reader["Post_Date"] is DBNull ? null : (DateTime?)reader["Post_Date"]; clsdbo_RevenueExpense.Post_No = reader["Post_No"] is DBNull ? null : reader["Post_No"].ToString(); clsdbo_RevenueExpense.Account_No = reader["Account_No"] is DBNull ? null : reader["Account_No"].ToString(); clsdbo_RevenueExpense.Account_Code = reader["Account_Code"] is DBNull ? null : reader["Account_Code"].ToString(); clsdbo_RevenueExpense.Amount = reader["Amount"] is DBNull ? null : (Decimal?)reader["Amount"]; clsdbo_RevenueExpense.Remark = reader["Remark"] is DBNull ? null : reader["Remark"].ToString(); } else { clsdbo_RevenueExpense = null; } reader.Close(); } catch (SqlException) { return(clsdbo_RevenueExpense); } finally { connection.Close(); } return(clsdbo_RevenueExpense); }
public static bool Update(dbo_RevenueExpenseClass newdbo_RevenueExpenseClass) { SqlConnection connection = SAMDataClass.GetConnection(); string updateProcedure = "[dbo].[RevenueExpenseUpdate]"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (newdbo_RevenueExpenseClass.Post_Date.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewPost_Date", newdbo_RevenueExpenseClass.Post_Date); } else { updateCommand.Parameters.AddWithValue("@NewPost_Date", DBNull.Value); } if (newdbo_RevenueExpenseClass.Post_No != null) { updateCommand.Parameters.AddWithValue("@NewPost_No", newdbo_RevenueExpenseClass.Post_No); } else { updateCommand.Parameters.AddWithValue("@NewPost_No", DBNull.Value); } if (newdbo_RevenueExpenseClass.Account_No != null) { updateCommand.Parameters.AddWithValue("@NewAccount_No", newdbo_RevenueExpenseClass.Account_No); } else { updateCommand.Parameters.AddWithValue("@NewAccount_No", DBNull.Value); } if (newdbo_RevenueExpenseClass.Account_Code != null) { updateCommand.Parameters.AddWithValue("@NewAccount_Code", newdbo_RevenueExpenseClass.Account_Code); } else { updateCommand.Parameters.AddWithValue("@NewAccount_Code", DBNull.Value); } if (newdbo_RevenueExpenseClass.Amount.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewAmount", newdbo_RevenueExpenseClass.Amount); } else { updateCommand.Parameters.AddWithValue("@NewAmount", DBNull.Value); } if (newdbo_RevenueExpenseClass.Remark != null) { updateCommand.Parameters.AddWithValue("@NewRemark", newdbo_RevenueExpenseClass.Remark); } else { updateCommand.Parameters.AddWithValue("@NewRemark", DBNull.Value); } /*if (olddbo_RevenueExpenseClass.Post_Date.HasValue == true) * { * updateCommand.Parameters.AddWithValue("@OldPost_Date", olddbo_RevenueExpenseClass.Post_Date); * } * else * { * updateCommand.Parameters.AddWithValue("@OldPost_Date", DBNull.Value); * } * if (olddbo_RevenueExpenseClass.Post_No != null) * { * updateCommand.Parameters.AddWithValue("@OldPost_No", olddbo_RevenueExpenseClass.Post_No); * } * else * { * updateCommand.Parameters.AddWithValue("@OldPost_No", DBNull.Value); * } * if (olddbo_RevenueExpenseClass.Account_No != null) * { * updateCommand.Parameters.AddWithValue("@OldAccount_No", olddbo_RevenueExpenseClass.Account_No); * } * else * { * updateCommand.Parameters.AddWithValue("@OldAccount_No", DBNull.Value); * } * if (olddbo_RevenueExpenseClass.Account_Code != null) * { * updateCommand.Parameters.AddWithValue("@OldAccount_Code", olddbo_RevenueExpenseClass.Account_Code); * } * else * { * updateCommand.Parameters.AddWithValue("@OldAccount_Code", DBNull.Value); * } * if (olddbo_RevenueExpenseClass.Amount.HasValue == true) * { * updateCommand.Parameters.AddWithValue("@OldAmount", olddbo_RevenueExpenseClass.Amount); * } * else * { * updateCommand.Parameters.AddWithValue("@OldAmount", DBNull.Value); * }*/ updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); updateCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
public static bool AddSP(dbo_RevenueExpenseClass clsdbo_RevenueExpense) { logger.Info(System.Web.HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); SqlConnection connection = SAMDataClass.GetConnection(); string insertProcedure = "[RevenueExpenseInsertAddSP]"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_RevenueExpense.Post_Date.HasValue == true) { insertCommand.Parameters.AddWithValue("@Post_Date", clsdbo_RevenueExpense.Post_Date); } else { insertCommand.Parameters.AddWithValue("@Post_Date", DBNull.Value); } if (clsdbo_RevenueExpense.Post_No != null) { insertCommand.Parameters.AddWithValue("@Post_No", clsdbo_RevenueExpense.Post_No); } else { insertCommand.Parameters.AddWithValue("@Post_No", DBNull.Value); } if (clsdbo_RevenueExpense.Account_No != null) { insertCommand.Parameters.AddWithValue("@Account_No", clsdbo_RevenueExpense.Account_No); } else { insertCommand.Parameters.AddWithValue("@Account_No", DBNull.Value); } if (clsdbo_RevenueExpense.Account_Code != null) { insertCommand.Parameters.AddWithValue("@Account_Code", clsdbo_RevenueExpense.Account_Code); } else { insertCommand.Parameters.AddWithValue("@Account_Code", DBNull.Value); } if (clsdbo_RevenueExpense.Amount.HasValue == true) { insertCommand.Parameters.AddWithValue("@Amount", clsdbo_RevenueExpense.Amount); } else { insertCommand.Parameters.AddWithValue("@Amount", DBNull.Value); } if (clsdbo_RevenueExpense.Remark != null) { insertCommand.Parameters.AddWithValue("@Remark", clsdbo_RevenueExpense.Remark); } else { insertCommand.Parameters.AddWithValue("@Remark", DBNull.Value); } if (clsdbo_RevenueExpense.CV_Code != null) { insertCommand.Parameters.AddWithValue("@CV_Code", clsdbo_RevenueExpense.CV_Code); } else { insertCommand.Parameters.AddWithValue("@CV_Code", DBNull.Value); } if (clsdbo_RevenueExpense.User_ID != null) { insertCommand.Parameters.AddWithValue("@User_ID", clsdbo_RevenueExpense.User_ID); } else { insertCommand.Parameters.AddWithValue("@User_ID", DBNull.Value); } insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); insertCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
protected void btnSaveSubmit_Click(object sender, EventArgs e) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); try { if (txtRequisition_Amount.Text == string.Empty) { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("กรุณาระบุจำนวนเงิน"); } //else if (Convert.ToDecimal(txtRequisition_Amount.Text) > Convert.ToDecimal(txtTotalBalanceOutstanding.Text)) //{ // System.Threading.Thread.Sleep(500); // ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); // Show("ไม่สามารถเบิกค่าคอมมิชชั่นเกินยอดหนี้คงค้างได้"); //} else { dbo_UserClass user_class = dbo_UserDataClass.Select_Record(HttpContext.Current.Request.Cookies["User_ID"].Value); dbo_CommissionRequisitionClass com_req = new dbo_CommissionRequisitionClass(); com_req.Commission_requisition_no = GenerateID.Commission_requisition_no(user_class.CV_CODE); com_req.Commission_Requisition_Date = DateTime.Now; com_req.Requisition_Amount = decimal.Parse(string.IsNullOrEmpty(txtRequisition_Amount.Text) ? "0" : txtRequisition_Amount.Text); // string user_id = ddl_SPName.SelectedIndex == 0 ? string.Empty : ddl_SPName.SelectedValue; //List<dbo_DebtClass> listofdebt = dbo_DebtDataClass.Search(user_id, string.Empty); int index = 1; // decimal init_debt = decimal.Parse(txtTotalBalanceOutstanding.Text); // decimal? check_init = 0; decimal? cal_com = decimal.Parse(txtRequisition_Amount.Text); HiddenField hdf = new HiddenField(); hdf.Value = string.Empty; string user_id = string.Empty; foreach (GridViewRow currentRow in grdCommissionRequisition.Rows) { if (cal_com > 0) { CheckBox chk = (CheckBox)currentRow.FindControl("chkAll"); if (chk.Checked) { Label lblClearing_No = (Label)currentRow.FindControl("lblClearing_No"); logger.Debug("lblClearing_No.Text " + lblClearing_No.Text); Label lblCommissionAmount = (Label)currentRow.FindControl("lblCommissionAmount"); logger.Debug("lblCommissionAmount.Text " + lblCommissionAmount.Text); logger.Debug("cal_com " + cal_com); hdf = (HiddenField)currentRow.FindControl("hdfUser_ID"); if (!string.IsNullOrEmpty(lblClearing_No.Text)) { List <dbo_RequisitionClearingClass> rc = dbo_RequisitionClearingDataClass.Search(lblClearing_No.Text, string.Empty, string.Empty, null, null, null, null, user_class.CV_CODE); //decimal? to_req = decimal.Parse(lblCommissionAmount.Text); decimal?to_req = cal_com; foreach (dbo_RequisitionClearingClass rc_ in rc) { logger.Debug(rc_.Requisition_No); List <dbo_CommissionClass> com = dbo_CommissionDataClass.Select_Record(rc_.Requisition_No); logger.Debug("** " + com[0].Commission_Balance_Outstanding + " , " + to_req + " **"); logger.Debug("com[0].Commission_Balance_Outstanding <= to_req"); if (com[0].Commission_Balance_Outstanding <= to_req) { dbo_CommissionRequisitionDtlClass detail = new dbo_CommissionRequisitionDtlClass(); detail.Clearing_No = lblClearing_No.Text; detail.Commission = decimal.Parse(lblCommissionAmount.Text); detail.Requisition_Amount = com[0].Commission_Balance_Outstanding; detail.Commission_requisition_no = com_req.Commission_requisition_no + index.ToString("00"); index++; dbo_CommissionRequisitionDtlDataClass.Add(detail, HttpContext.Current.Request.Cookies["User_ID"].Value); if (com.Count > 0) { com[0].Commission_Requisition_Status = 3; logger.Debug("com[0].Commission_Requisition_Status " + com[0].Commission_Requisition_Status); to_req = to_req - com[0].Commission_Balance_Outstanding; logger.Debug("to_req update " + to_req); com[0].Commission_Balance_Outstanding = 0; logger.Debug("com[0].Commission_Balance_Outstanding " + com[0].Commission_Balance_Outstanding); dbo_CommissionDataClass.Update(com[0], HttpContext.Current.Request.Cookies["User_ID"].Value); // break; } } else { dbo_CommissionRequisitionDtlClass detail = new dbo_CommissionRequisitionDtlClass(); detail.Clearing_No = lblClearing_No.Text; detail.Commission = decimal.Parse(lblCommissionAmount.Text); detail.Requisition_Amount = to_req; detail.Commission_requisition_no = com_req.Commission_requisition_no + index.ToString("00"); index++; dbo_CommissionRequisitionDtlDataClass.Add(detail, HttpContext.Current.Request.Cookies["User_ID"].Value); if (com.Count > 0) { com[0].Commission_Requisition_Status = 2; logger.Debug("com[0].Commission_Requisition_Status " + com[0].Commission_Requisition_Status); to_req = com[0].Commission_Balance_Outstanding - to_req; logger.Debug("to_req update " + to_req); // com[0].Commission_Balance_Outstanding = detail.Commission - detail.Requisition_Amount; com[0].Commission_Balance_Outstanding = com[0].Commission_Balance_Outstanding - detail.Requisition_Amount; logger.Debug("com[0].Commission_Balance_Outstanding " + com[0].Commission_Balance_Outstanding); dbo_CommissionDataClass.Update(com[0], HttpContext.Current.Request.Cookies["User_ID"].Value); break; } } } } cal_com = cal_com - decimal.Parse(lblCommissionAmount.Text); } } } dbo_CommissionRequisitionClass total = dbo_ClearingDataClass.Get_Commission_Balance_Outstanding(hdf.Value); com_req.Total_Balance_Outstanding = total.Total_Balance_Outstanding; logger.Debug("com_req.Total_Balance_Outstanding " + com_req.Total_Balance_Outstanding); com_req.Commission_Balance_Outstanding = total.Commission_Balance_Outstanding; logger.Debug("com_req.Commission_Balance_Outstanding " + com_req.Commission_Balance_Outstanding); com_req.Total_Credit_Amount = total.Total_Credit_Amount; logger.Debug("com_req.Total_Credit_Amount " + com_req.Total_Credit_Amount); dbo_CommissionRequisitionDataClass.Add(com_req, HttpContext.Current.Request.Cookies["User_ID"].Value); // Show("บันทึกสำเร็จ"); string Post_No = GenerateID.Post_No(user_class.CV_CODE); dbo_RevenueExpenseClass rev = new dbo_RevenueExpenseClass(); rev.Post_No = Post_No; rev.CV_Code = user_class.CV_CODE; rev.Amount = decimal.Parse(txtRequisition_Amount.Text); rev.Account_Code = "5071"; rev.Account_No = GenerateID.EP(user_class.CV_CODE); rev.Remark = ""; rev.Post_Date = DateTime.Now; rev.User_ID = user_id; dbo_RevenueExpenseDataClass.AddSP(rev); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); string url = "../Report_From/ViewsReport.aspx?RPT=CommissionReqList&PRM=" + com_req.Commission_requisition_no; string s = "window.open('" + url + "', 'popup_window', 'width=1024,height=768,left=100,top=100,resizable=yes');"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", s, true); btnSearch_2_Submit_Click(null, null); } } catch (Exception ex) { logger.Error(ex.Message); } }