private void Clear_textBoxes() { FirstName.Clear(); LastName.Clear(); ProductName.Clear(); wholesalecost.Clear(); SaleCost.Clear(); }
public static void BatchSaleCost(DataTable dt, Oper oper) { using (SqlConnection conn = ConnectionPool.BorrowConnection()) { //conn.Open(); SqlTransaction trans = conn.BeginTransaction(); try { string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString(); DateTime dtSysTime = DateTime.Parse(strSysTime); foreach (DataRow dr in dt.Rows) { SaleCost sc = new SaleCost(dr); //newOper.cndCreateDate = dtSysTime; string strCount = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select count(*) from tbSaleCost where cnnCustID = " + sc.cnnCustID + " and cnvcYear='" + sc.cnvcYear + "'").ToString(); if (Convert.ToInt32(strCount) > 0) { throw new Exception(sc.cnnCustID + "的" + sc.cnvcYear + "年成本管理已存在"); } EntityMapping.Create(sc, trans); BusiLog busiLog = new BusiLog(); busiLog.cndOperDate = dtSysTime; busiLog.cnnBusiSerialNo = Helper.GetSerialNo(trans); busiLog.cnvcComments = sc.cnvcCustName; busiLog.cnvcFuncCode = " 批量添加销售成本"; busiLog.cnvcOperID = oper.cnvcOperID; busiLog.cnvcIPAddress = ""; EntityMapping.Create(busiLog, trans); } trans.Commit(); } catch (SqlException sex) { trans.Rollback(); LogAdapter.WriteDatabaseException(sex); throw sex; } catch (Exception ex) { trans.Rollback(); LogAdapter.WriteFeaturesException(ex); throw ex; } finally { ConnectionPool.ReturnConnection(conn); } } }
private void btnOK_Click(object sender, System.Web.UI.ImageClickEventArgs e) { try { if (txtCustID.Text.Trim() == "" || this.ddlYear.SelectedValue == "") { Popup("请选择客户和年份!"); return; } string strSql = "select * from tbSaleCost where cnnCustID = " + txtCustID.Text.Trim() + " and cnvcYear='" + this.ddlYear.SelectedValue + "'"; DataTable dt = Helper.Query(strSql); if (dt.Rows.Count > 0) { Popup("本销售成本存在冲突"); return; } if (this.JudgeIsNull(txtCustName.Text.Trim(), "客户名称")) { return; } if (this.JudgeIsNull(txtBudgetCost.Text.Trim(), "预算销售成本") || !this.JudgeIsNum(txtBudgetCost.Text.Trim(), "预算销售成本")) { return; } if (this.JudgeIsNull(txtRealSaleCost.Text.Trim(), "实际销售成本合计") || !this.JudgeIsNum(txtRealSaleCost.Text.Trim(), "实际销售成本合计")) { return; } SaleCost cost = new SaleCost(); cost.cnnCustID = decimal.Parse(txtCustID.Text.Trim()); cost.cnvcCustName = txtCustName.Text.Trim(); cost.cnvcYear = ddlYear.SelectedValue; cost.cnnBudgetCost = decimal.Parse(txtBudgetCost.Text.Trim()); cost.cnnRealSaleCost = decimal.Parse(txtRealSaleCost.Text.Trim()); SalesManageFacade.AddSaleCost(cost, oper); Popup("销售成本添加成功"); this.txtCustID.Text = ""; this.txtCustName.Text = ""; this.txtBudgetCost.Text = ""; this.txtRealSaleCost.Text = ""; } catch (Exception ex) { Popup(ex.Message); } }
public static void UpdateSaleCost(SaleCost cost, Oper oper) { using (SqlConnection conn = ConnectionPool.BorrowConnection()) { //conn.Open(); SqlTransaction trans = conn.BeginTransaction(); try { string strSysTime = SqlHelper.ExecuteScalar(trans, CommandType.Text, "select getdate()").ToString(); DateTime dtSysTime = DateTime.Parse(strSysTime); //newOper.cndCreateDate = dtSysTime; EntityMapping.Update(cost, trans); BusiLog busiLog = new BusiLog(); busiLog.cndOperDate = dtSysTime; busiLog.cnnBusiSerialNo = Helper.GetSerialNo(trans); busiLog.cnvcComments = cost.cnvcCustName; busiLog.cnvcFuncCode = " 修改销售成本"; busiLog.cnvcOperID = oper.cnvcOperID; busiLog.cnvcIPAddress = ""; EntityMapping.Create(busiLog, trans); trans.Commit(); } catch (SqlException sex) { trans.Rollback(); LogAdapter.WriteDatabaseException(sex); throw sex; } catch (Exception ex) { trans.Rollback(); LogAdapter.WriteFeaturesException(ex); throw ex; } finally { ConnectionPool.ReturnConnection(conn); } } }
private void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e) { try { SaleCost cost = new SaleCost(); decimal costsum = 0; //1月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[6].Controls[0]).Text.Trim(), "1月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[6].Controls[0]).Text.Trim(), "1月使用")) { return; } else { cost.cnnUsed1 = decimal.Parse(((TextBox)e.Item.Cells[6].Controls[0]).Text.Trim()); costsum += cost.cnnUsed1; } //2月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[7].Controls[0]).Text.Trim(), "2月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[7].Controls[0]).Text.Trim(), "2月使用")) { return; } else { cost.cnnUsed2 = decimal.Parse(((TextBox)e.Item.Cells[7].Controls[0]).Text.Trim()); costsum += cost.cnnUsed2; } //3月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[8].Controls[0]).Text.Trim(), "3月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[8].Controls[0]).Text.Trim(), "3月使用")) { return; } else { cost.cnnUsed3 = decimal.Parse(((TextBox)e.Item.Cells[8].Controls[0]).Text.Trim()); costsum += cost.cnnUsed3; } //4月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[9].Controls[0]).Text.Trim(), "4月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[9].Controls[0]).Text.Trim(), "4月使用")) { return; } else { cost.cnnUsed4 = decimal.Parse(((TextBox)e.Item.Cells[9].Controls[0]).Text.Trim()); costsum += cost.cnnUsed4; } //5月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[10].Controls[0]).Text.Trim(), "5月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[10].Controls[0]).Text.Trim(), "5月使用")) { return; } else { cost.cnnUsed5 = decimal.Parse(((TextBox)e.Item.Cells[10].Controls[0]).Text.Trim()); costsum += cost.cnnUsed5; } //6月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[11].Controls[0]).Text.Trim(), "6月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[11].Controls[0]).Text.Trim(), "6月使用")) { return; } else { cost.cnnUsed6 = decimal.Parse(((TextBox)e.Item.Cells[11].Controls[0]).Text.Trim()); costsum += cost.cnnUsed6; } //7月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[12].Controls[0]).Text.Trim(), "7月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[12].Controls[0]).Text.Trim(), "7月使用")) { return; } else { cost.cnnUsed7 = decimal.Parse(((TextBox)e.Item.Cells[12].Controls[0]).Text.Trim()); costsum += cost.cnnUsed7; } //8月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[13].Controls[0]).Text.Trim(), "8月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[13].Controls[0]).Text.Trim(), "8月使用")) { return; } else { cost.cnnUsed8 = decimal.Parse(((TextBox)e.Item.Cells[13].Controls[0]).Text.Trim()); costsum += cost.cnnUsed8; } //9月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[14].Controls[0]).Text.Trim(), "9月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[14].Controls[0]).Text.Trim(), "9月使用")) { return; } else { cost.cnnUsed9 = decimal.Parse(((TextBox)e.Item.Cells[14].Controls[0]).Text.Trim()); costsum += cost.cnnUsed9; } //10月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[15].Controls[0]).Text.Trim(), "10月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[15].Controls[0]).Text.Trim(), "10月使用")) { return; } else { cost.cnnUsed10 = decimal.Parse(((TextBox)e.Item.Cells[15].Controls[0]).Text.Trim()); costsum += cost.cnnUsed10; } //11月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[16].Controls[0]).Text.Trim(), "11月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[16].Controls[0]).Text.Trim(), "11月使用")) { return; } else { cost.cnnUsed11 = decimal.Parse(((TextBox)e.Item.Cells[16].Controls[0]).Text.Trim()); costsum += cost.cnnUsed11; } //12月 if (this.JudgeIsNull(((TextBox)e.Item.Cells[17].Controls[0]).Text.Trim(), "12月使用") || !this.JudgeIsNum(((TextBox)e.Item.Cells[17].Controls[0]).Text.Trim(), "12月使用")) { return; } else { cost.cnnUsed12 = decimal.Parse(((TextBox)e.Item.Cells[17].Controls[0]).Text.Trim()); costsum += cost.cnnUsed12; } cost.cnnCustID = decimal.Parse(e.Item.Cells[0].Text.Trim()); cost.cnvcCustName = e.Item.Cells[1].Text.Trim(); cost.cnvcYear = e.Item.Cells[2].Text.Trim(); cost.cnnBudgetCost = decimal.Parse(e.Item.Cells[3].Text.Trim()); cost.cnnRealSaleCost = decimal.Parse(e.Item.Cells[4].Text.Trim()); cost.cnnCostUsed = costsum; SalesManageFacade.UpdateSaleCost(cost, oper); Popup("销售成本修改成功"); string strsql = "select * from tbSaleCost where cnnCustID=" + cost.cnnCustID + " and cnvcYear='" + cost.cnvcYear + "' order by cnnCustID,cnvcYear"; DataTable dtout = Helper.Query(strsql); Session.Remove("QUERY"); Session["QUERY"] = dtout; this.DataGrid1.EditItemIndex = -1; this.DataGrid1.DataSource = dtout; this.DataGrid1.DataBind(); } catch (Exception ex) { Popup(ex.Message); } }