private void _sbSaveAndContinue_Click(object sender, EventArgs e) { if (Save()) { r.ChangeText("1"); _ID = 0; _teName.EditValue = _teMeRemark.EditValue = string.Empty; } }
private void simpleButton3_Click(object sender, EventArgs e) { if (_TableTypeID == (int)BasicClass.Enums.TableType._缝制要求) { r.ChangeText(gridView1.GetFocusedRowCellDisplayText(_coRemarks)); } else { r.ChangeText(gridView1.GetFocusedRowCellValue(_coID).ToString()); } this.Close(); }
private void _barCancelStock_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (DialogResult.Yes == XtraMessageBox.Show("取消当前采购数量?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2)) { if (DialogResult.Yes == XtraMessageBox.Show("是否真的取消当前采购数量?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2)) { DataTable dttt = BasicClass.GetDataSet.GetDS(BasicClass.Bllstr.bllStockBackInfo, "GetList", new object[] { "(ID=" + Convert.ToInt32(gridView1.GetFocusedRowCellValue(_coID)) + ")" }).Tables[0]; dttt.Rows[0]["IsEnd"] = 1; BasicClass.GetDataSet.UpData(BasicClass.Bllstr.bllStockBackInfo, dttt); gridView1.DeleteRow(gridView1.FocusedRowHandle); r.ChangeText("OK"); } } }
private void simpleButton1_Click(object sender, EventArgs e) { gridView1.CloseEditor(); gridView1.UpdateCurrentRow(); dtPWI.AcceptChanges(); if (CheckRepeat()) { return; } DataTable dtt = dtPWI.Clone(); int a = 0; for (int i = 0; i < dtPWI.Rows.Count - 2; i++) { a = Convert.ToInt32(dtPWI.Rows[i]["A"]); if (a > 1) { dtt.Rows.Clear(); dtt.Rows.Add(dtPWI.Rows[i].ItemArray); if (a == 2) { BasicClass.GetDataSet.UpData(BasicClass.Bllstr.bllProductWorkingInfo, dtt); } else if (a == 3) { dtPWI.Rows[i]["ID"] = BasicClass.GetDataSet.Add(BasicClass.Bllstr.bllProductWorkingInfo, dtt); } dtPWI.Rows[i]["A"] = 1; } } r.ChangeText("OK"); }
private void gridView1_DoubleClick(object sender, EventArgs e) { if (gridView1.FocusedRowHandle > -1) { int row = gridView1.FocusedRowHandle; int a = 0; DataTable dtMCTem = dtMC.Clone(); for (int i = 0; i < dtMC.Rows.Count; i++) { a = Convert.ToInt32(dtMC.Rows[i]["A"]); if (a > 1) { dtMCTem.Rows.Clear(); dtMC.Rows[i]["MaterielID"] = _ID; dtMCTem.Rows.Add(dtMC.Rows[i].ItemArray); if (a == 3) { dtMC.Rows[i]["ID"] = BasicClass.GetDataSet.Add("Hownet.BLL.MaterielCompany", dtMCTem); } else if (a == 2) { BasicClass.GetDataSet.UpData("Hownet.BLL.MaterielCompany", dtMCTem); } dtMC.Rows[i]["A"] = 1; } } r.ChangeText(gridView1.GetRowCellValue(row, _coID).ToString() + "," + gridView1.GetRowCellDisplayText(row, _coCompanyID)); if (!_sbSaveAndContinue.Visible) { this.Close(); } } }
private void simpleButton1_Click(object sender, EventArgs e) { if (Convert.ToInt32(lookUpEdit1.EditValue) > 0) { if (DialogResult.Yes == XtraMessageBox.Show("确认照此修改生产部门?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1)) { if (DepTypeID == 3) { try { decimal ccc = Convert.ToDecimal(textEdit1.EditValue); } catch { XtraMessageBox.Show("加工费填写错误!"); return; } } DataTable dtTM = BasicClass.GetDataSet.GetDS(BasicClass.Bllstr.bllProductTaskMain, "GetList", new object[] { "(ID=" + _PlanID + ")" }).Tables[0]; if (dtTM.Rows.Count == 1) { dtTM.Rows[0]["DeparmentID"] = Convert.ToInt32(lookUpEdit1.EditValue); dtTM.Rows[0]["DeparmentType"] = DepTypeID; dtTM.Rows[0]["Price"] = textEdit1.EditValue; BasicClass.GetDataSet.UpData(BasicClass.Bllstr.bllProductTaskMain, dtTM); r.ChangeText("1"); } } this.Close(); } }
private void simpleButton1_Click(object sender, EventArgs e) { if (textEdit2.EditValue == DBNull.Value) { this.Close(); } else { decimal amount = 0; try { amount = Convert.ToDecimal(textEdit2.EditValue); if (amount > _SumAmount) { XtraMessageBox.Show("不能超过总数量"); textEdit2.EditValue = _SumAmount; } else { r.ChangeText(amount.ToString()); this.Close(); } } catch { XtraMessageBox.Show("只能填写数字"); textEdit2.EditValue = DBNull.Value; } } }
private void simpleButton1_Click(object sender, EventArgs e) { if (Convert.ToInt32(lookUpEdit1.EditValue) > 0) { if (Convert.ToInt32(textEdit5.EditValue) < Convert.ToInt32(textEdit4.EditValue)) { XtraMessageBox.Show("箱号错误!"); return; } if (_WTIID > 0 && Convert.ToInt32(textEdit5.EditValue) == _BoxNum && Convert.ToInt32(textEdit4.EditValue) == _BoxNum) { if (Convert.ToInt32(dtWTI.Rows[0]["EmployeeID"]) == 0) { dtWTI.Rows[0]["EmployeeID"] = Convert.ToInt32(lookUpEdit1.EditValue); dtWTI.Rows[0]["DateTime"] = BasicClass.GetDataSet.GetDateTime(); } dtWTI.Rows[0]["OutAmount"] = Convert.ToInt32(textEdit2.EditValue); dtWTI.Rows[0]["Amount"] = Convert.ToInt32(textEdit3.EditValue); BasicClass.GetDataSet.UpData(BasicClass.Bllstr.bllWorkTicketInfo, dtWTI); if (!textEdit2.Enabled) { BasicClass.GetDataSet.ExecSql(BasicClass.Bllstr.bllPayInfo, "DelByWTInfoID", new object[] { _WTIID }); BasicClass.GetDataSet.ExecSql(BasicClass.Bllstr.bllWorkTicketInfo, "AddPayInfoByID", new object[] { _WTIID }); } } else if (_BoxNum > 0) { DateTime dtNow = BasicClass.GetDataSet.GetDateTime(); for (int i = Convert.ToInt32(textEdit4.EditValue); i < Convert.ToInt32(textEdit5.EditValue) + 1; i++) { _WTIID = Convert.ToInt32(BasicClass.GetDataSet.GetOne(BasicClass.Bllstr.bllWorkTicketInfo, "GetID", new object[] { _TaskID, i, _WorkingName, _SizeID })); if (_WTIID > 0) { dtWTI = BasicClass.GetDataSet.GetDS(BasicClass.Bllstr.bllWorkTicketInfo, "GetList", new object[] { "(ID=" + _WTIID + ")" }).Tables[0]; dtWTI.Rows[0]["EmployeeID"] = Convert.ToInt32(lookUpEdit1.EditValue); dtWTI.Rows[0]["DateTime"] = dtNow; if (Convert.ToInt32(textEdit2.EditValue) > 0) { dtWTI.Rows[0]["OutAmount"] = Convert.ToInt32(textEdit2.EditValue); } if (Convert.ToInt32(textEdit3.EditValue) > 0) { dtWTI.Rows[0]["Amount"] = Convert.ToInt32(textEdit3.EditValue); } BasicClass.GetDataSet.UpData(BasicClass.Bllstr.bllWorkTicketInfo, dtWTI); //if (!textEdit2.Enabled) //{ BasicClass.GetDataSet.ExecSql(BasicClass.Bllstr.bllPayInfo, "DelByWTInfoID", new object[] { _WTIID }); BasicClass.GetDataSet.ExecSql(BasicClass.Bllstr.bllWorkTicketInfo, "AddPayInfoByID", new object[] { _WTIID }); //} } } } } r.ChangeText(lookUpEdit1.EditValue.ToString() + "+" + lookUpEdit1.Text); this.Close(); }
private void _barVerify_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (_MainID == 0) { XtraMessageBox.Show("请先保存!"); return; } if (DialogResult.No == XtraMessageBox.Show("确认审核本单?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2)) { return; } if (Convert.ToInt32(_lePW.editVal) == 0) { XtraMessageBox.Show("请选择工艺单"); return; } dtTM.Rows[0]["PWorkingID"] = _lePW.editVal; dtTM.Rows[0]["IsVerify"] = 3; dtTM.Rows[0]["VerifyMan"] = BasicClass.UserInfo.UserID; dtTM.Rows[0]["VerifyDate"] = DateTime.Today; dtTM.Rows[0]["IsTicket"] = true; if (Save()) { _isVerify = true; BasicClass.GetDataSet.ExecSql("Hownet.BLL.BaseFile.MakBox", "MakClothing", new object[] { _MainID }); if (_ParentID > 0) { BasicClass.GetDataSet.ExecSql("Hownet.BLL.ProductionPlan", "UpPlanAmount", new object[] { _ParentID, _MainID, (int)BasicClass.Enums.TableType.ProductionPlan, _TableTypeID, true }); } _barUnVerify.Enabled = true; _leMateriel.IsNotCanEdit = _leCompany.IsNotCanEdit = _leBrand.IsNotCanEdit = false; _brSave.Enabled = _barVerify.Enabled = _brDel.Enabled = false; if (_isVerify && (bs.Position == dtMain.Rows.Count - 1)) { _brAddNew.Enabled = true; } cRR.ChangeText(_MainID.ToString() + "," + userNum1.NumStr + "/" + _leDeparment.valStr); checkEdit1.Visible = false; BasicClass.GetDataSet.ExecSql(BasicClass.Bllstr.bllAmountInfo, "InNoList", new object[] { 0 }); } ShowPWI(); }
private void UpCard(int aa) { object o = BasicClass.GetDataSet.GetOne(blWTDC, "UpIDCardNo", new object[] { _ticketID, _GroupBy, aa, _TaskID }); if (o != null && Convert.ToInt32(o) == 1) { XtraMessageBox.Show("更新成功!"); r.ChangeText(textEdit1.Text); this.Close(); } }
private void GetID() { if (_id != 0) { if (gridView1.FocusedRowHandle > -1) { int _mID = int.Parse(gridView1.GetFocusedRowCellValue(_coID).ToString()); if (_mID > 0) { r.ChangeText(_mID.ToString()); } } } }
private void GetID() { if (_id != 0) { Save(); if (treeList1.FocusedNode != null) { int _mID = int.Parse(treeList1.FocusedNode.GetValue(_trID).ToString()); if (_mID > 0) { r.ChangeText(_mID.ToString()); } } } }
private void ChangTxt() { if (gridView1.FocusedRowHandle > -1 && _id != 0) { if (gridView1.GetFocusedRowCellDisplayText(_coID) != "0") { _id = int.Parse(gridView1.GetFocusedRowCellDisplayText(_coID)); r.ChangeText(_id.ToString()); this.Close(); } else { XtraMessageBox.Show("請先保存!"); return; } } }
private void simpleButton1_Click(object sender, EventArgs e) { gridView1.CloseEditor(); gridView1.UpdateCurrentRow(); dtFC.AcceptChanges(); if (dtFC.Rows.Count > 0) { DataTable dtTem = dtFC.Clone(); if (Convert.ToInt32(dtFC.Rows[0]["UserID"]) > -1)//用户第一次设置 { for (int i = 0; i < dtFC.Rows.Count; i++) { dtTem.Rows.Clear(); dtTem.Rows.Add(dtFC.Rows[i].ItemArray); dtTem.Rows[0]["UserID"] = BasicClass.UserInfo.UserID * -1; BasicClass.GetDataSet.Add("Hownet.BLL.FromCloumns", dtTem); } } else { for (int i = 0; i < dtFC.Rows.Count; i++) { if (Convert.ToInt32(dtFC.Rows[i]["A"]) == 2) { dtTem.Rows.Clear(); dtTem.Rows.Add(dtFC.Rows[i].ItemArray); BasicClass.GetDataSet.UpData("Hownet.BLL.FromCloumns", dtTem); } } } r.ChangeText("1"); this.Close(); } else { this.Close(); } }
private void barButtonItem1_ItemClick_1(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (DialogResult.No == MessageBox.Show("是否确认审核", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2)) { return; } Save(); t = true; dtMI.Rows[0]["VerifyMan"] = BasicClass.UserInfo.UserID; dtMI.Rows[0]["VerifyDate"] = DateTime.Today; dtMI.Rows[0]["IsVerify"] = 3; BasicClass.GetDataSet.UpData(blMIOO, dtMI); dtCL = BasicClass.GetDataSet.GetDS(blCL, "GetList", new object[] { "ID=0" }).Tables[0]; DataRow dr = dtCL.NewRow(); dr["ID"] = 0; dr["CompanyID"] = _companyID; dr["DateTime"] = dtMI.Rows[0]["DateTime"]; dr["LastMoney"] = dtMI.Rows[0]["LastMoney"]; dr["ChangMoney"] = chang; dr["Money"] = last - chang; dr["TypeID"] = _typeID;; dr["TableID"] = _id; dr["NowMoneyTypeID"] = 0; dr["NowMoney"] = 0; dr["NowReta"] = 1; dr["A"] = 1; dtCL.Rows.Add(dr); BasicClass.GetDataSet.Add(blCL, dtCL); BasicClass.GetDataSet.ExecSql(BasicClass.Bllstr.bllCompany, "UpLastMoney", new object[] { _companyID, (last - chang) }); _barVerify.Enabled = _brSave.Enabled = _barDel.Enabled = false; _brAddNew.Enabled = _barUnVerify.Enabled = (bs.Position == dtMain.Rows.Count - 1); DataTable dtKM = BasicClass.GetDataSet.GetDS("Hownet.BLL.Bas_KJKM", "GetList", new object[] { "(ID=" + lookUpEdit1.EditValue + ")" }).Tables[0]; if (dtKM.Rows.Count > 0) { dtKM.Rows[0]["Money"] = Convert.ToDecimal(dtKM.Rows[0]["Money"]) + chang - Convert.ToDecimal(textEdit1.EditValue); BasicClass.GetDataSet.UpData("Hownet.BLL.Bas_KJKM", dtKM); } //dtKM = BasicClass.GetDataSet.GetDS("Hownet.BLL.Bas_KJKM", "GetList", new object[] { "(CompanyID=" + _companyID + ")" }).Tables[0]; //if (dtKM.Rows.Count > 0) //{ // dtKM.Rows[0]["Money"] = Convert.ToDecimal(dtKM.Rows[0]["Money"]) - chang; // BasicClass.GetDataSet.UpData("Hownet.BLL.Bas_KJKM", dtKM); //} string bllMI = "Hownet.BLL.MoneyList"; decimal lastMoney = Convert.ToDecimal(BasicClass.GetDataSet.GetOne(bllMI, "GetLastMoney", new object[] { Convert.ToInt32(lookUpEdit1.EditValue) })); DataTable dtMII = BasicClass.GetDataSet.GetDS(bllMI, "GetList", new object[] { "1=2" }).Tables[0]; DataRow ddr = dtMII.NewRow(); ddr["KJKMID"] = Convert.ToInt32(lookUpEdit1.EditValue); ddr["DateTime"] = dtMI.Rows[0]["DateTime"]; ddr["InMoney"] = chang - Convert.ToDecimal(textEdit1.EditValue); ddr["OutMoney"] = 0; ddr["Money"] = lastMoney + chang - Convert.ToDecimal(textEdit1.EditValue); ddr["TableID"] = _id; ddr["TypeID"] = (int)BasicClass.Enums.MoneyTableType.BackMoney; ddr["Remark"] = "收客户:" + _leCompany.valStr + " 货款" + memoEdit1.Text; dtMII.Rows.Add(ddr); BasicClass.GetDataSet.Add(bllMI, dtMII); string bllMain = "Hownet.BLL.CW_KJFL"; string bllInfo = "Hownet.BLL.CW_KJFLInfo"; DataTable dtPZ = BasicClass.GetDataSet.GetDS(bllMain, "GetList", new object[] { "(ID= 0 )" }).Tables[0]; DataRow drr = dtPZ.NewRow(); drr["A"] = 3; drr["ID"] = 0; DateTime dtNow = Convert.ToDateTime(dtMI.Rows[0]["DateTime"]); drr["编号"] = BasicClass.GetDataSet.GetOne(bllMain, "NewNum", new object[] { dtNow, 1 }); drr["年"] = dtNow.Year; drr["月"] = dtNow.Month.ToString().PadLeft(2, '0'); drr["日"] = dtNow.Day.ToString().PadLeft(2, '0'); drr["时间"] = dtNow.ToString("yyyy-MM-dd"); drr["附件"] = string.Empty; drr["制单人"] = BasicClass.UserInfo.TrueName; drr["审核"] = BasicClass.UserInfo.TrueName; drr["记帐"] = BasicClass.UserInfo.TrueName; drr["财务主管"] = BasicClass.UserInfo.TrueName; drr["制单人ID"] = BasicClass.UserInfo.UserID; drr["审核ID"] = 0; drr["记帐ID"] = 0; drr["财务主管ID"] = 0; drr["制单日期"] = dtNow; drr["审核日期"] = dtNow; drr["记账日期"] = dtNow; drr["帐户"] = lookUpEdit1.Text; drr["帐户ID"] = Convert.ToInt32(lookUpEdit1.EditValue); drr["TypeID"] = 1; drr["TableID"] = _id; dtPZ.Rows.Add(drr); int _PZID = BasicClass.GetDataSet.Add(bllMain, dtPZ); DataTable dtInfo = BasicClass.GetDataSet.GetDS(bllInfo, "GetList", new object[] { "(ID= 0 )" }).Tables[0]; DataRow drrrr = dtInfo.NewRow(); drrrr["A"] = 3; drrrr["ID"] = 0; drrrr["MainID"] = _PZID; drrrr["费用类别"] = "应收帐款"; drrrr["金额"] = chang; drrrr["手续费"] = DBNull.Value; drrrr["费用类别ID"] = 82; drrrr["项目名称"] = string.Empty; drrrr["项目名称ID"] = 0; drrrr["客户订单编号"] = string.Empty; drrrr["客户"] = string.Empty; drrrr["款号"] = string.Empty; drrrr["报销人"] = string.Empty; drrrr["备注"] = "收客户:" + _leCompany.valStr + " 货款"; drrrr["客户订单ID"] = 0; drrrr["客户ID"] = 0; drrrr["款号ID"] = 0; drrrr["报销人ID"] = 0; drrrr["二级科目"] = _leCompany.valStr; drrrr["二级科目ID"] = _companyID; drrrr["报销部门"] = string.Empty; drrrr["报销部门ID"] = 0; dtInfo.Rows.Add(drrrr); BasicClass.GetDataSet.Add(bllInfo, dtInfo); if (Convert.ToDecimal(textEdit1.EditValue) > 0) { dtInfo.Rows[0]["ID"] = 0; dtInfo.Rows[0]["金额"] = Convert.ToDecimal(textEdit1.EditValue); dtInfo.Rows[0]["费用类别"] = "财务费用"; dtInfo.Rows[0]["费用类别ID"] = 117; dtInfo.Rows[0]["二级科目"] = _leCompany.valStr; dtInfo.Rows[0]["二级科目ID"] = _companyID; BasicClass.GetDataSet.Add(bllInfo, dtInfo); } r.ChangeText("1"); }
private void simpleButton1_Click(object sender, EventArgs e) { r.ChangeText(_lePW.editVal.ToString()); this.Close(); }
private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { if (Convert.ToInt32(e.KeyChar) == 13) { int _ID = 0; try { _ID = Convert.ToInt32(textBox1.Text.Trim()); textBox1.Text = string.Empty; DataTable dtTem = new DataTable(); //if (_ID > 0) dtTem = BasicClass.GetDataSet.GetDS(bllRL, "GetList", new object[] { "(QRID=" + _ID + ")" }).Tables[0]; //else // dtTem = BasicClass.GetDataSet.GetDS(bllRL, "GetList", new object[] { "(ID=" + _ID*-1 + ")" }).Tables[0]; if (dtTem.Rows.Count == 1) { if (dtSBIL.Select("(NotAmount=" + dtTem.Rows[0]["ID"] + ")").Length > 0) { XtraMessageBox.Show("该物料已被领走"); return; } if (dtDepInfo.Select("(ID=" + dtTem.Rows[0]["DepotInfoID"] + ")").Length > 0) { if (DialogResult.Yes == XtraMessageBox.Show("该物料确认出仓?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1)) { decimal _amount = 0; DataRow dr = dtSBIL.NewRow(); dr["ID"] = 0; dr["A"] = 1; dr["InfoID"] = _InfoID; _amount = Convert.ToDecimal(dtTem.Rows[0]["NotAmount"]); dr["Amount"] = dtTem.Rows[0]["NotAmount"]; dr["Remark"] = string.Empty; dr["IsOk"] = true; dr["BatchNumBer"] = dtTem.Rows[0]["BatchNumBer"]; dr["NotAmount"] = dtTem.Rows[0]["ID"]; dr["SpecID"] = dtTem.Rows[0]["SpecID"]; dr["DepotInfoID"] = dtTem.Rows[0]["DepotInfoID"]; dr["MainID"] = _ManID; dr["QRID"] = _ID; DataTable dtt = dtSBIL.Clone(); dtt.Rows.Add(dr.ItemArray); dtt.Rows[0]["ID"] = BasicClass.GetDataSet.Add(bll, dtt); dtSBIL.Rows.Add(dtt.Rows[0].ItemArray); r.ChangeText(_amount.ToString()); } } else { XtraMessageBox.Show("非所选择仓库的物料!"); return; } } } catch (Exception ex) { XtraMessageBox.Show("条码号不正确"); return; } } }
private bool Save() { mod.ID = _id; try { mod.Sn = Convert.ToInt32(_ltSn.val.Trim()).ToString(); } catch { mod.Sn = _ltSn.val.Trim(); //.Replace("'", "''"); } mod.Name = _ltName.val.Trim(); //.Replace("'", "''"); if (mod.Sn.Trim() == string.Empty) { XtraMessageBox.Show("请填写编号!"); return(false); } if (mod.Name.Trim() == string.Empty) { XtraMessageBox.Show("请填写员工姓名!"); return(false); } if (mod.ID == 0) { DataTable dttt = BasicClass.GetDataSet.GetDS(BasicClass.Bllstr.bllMiniEmp, "GetList", new object[] { "(Sn='" + mod.Sn + "') And (IsEnd=0)" }).Tables[0]; if (dttt.Rows.Count > 0) { XtraMessageBox.Show("编号:" + mod.Sn + "已被员工" + dttt.Rows[0]["Name"].ToString() + "使用"); return(false); } } else { if (_ldDim.val == null) { DataTable dttt = BasicClass.GetDataSet.GetDS(BasicClass.Bllstr.bllMiniEmp, "GetList", new object[] { "(Sn='" + mod.Sn + "') And (ID<>" + _id + ") And (IsEnd=0)" }).Tables[0]; if (dttt.Rows.Count > 0) { XtraMessageBox.Show("编号:" + mod.Sn + "已被员工" + dttt.Rows[0]["Name"].ToString() + "使用"); return(false); } } } mod.IntroducerID = int.Parse(_leJSR.editVal.ToString()); mod.IdentityCard = _ltIdentityCard.val; mod.Sex = int.Parse(_reSex.EditValue.ToString()); mod.Province = int.Parse(_leProvince.editVal.ToString()); mod.City = int.Parse(_leCity.editVal.ToString()); mod.County = int.Parse(_leCounty.editVal.ToString()); mod.Address = _ltAddress.val; mod.Phone = _ltPhone.val; if (_ldAcc.val != null) { mod.AccDate = DateTime.Parse(_ldAcc.val.ToString()); } else { mod.AccDate = BasicClass.GetDataSet.GetDateTime().Date; } mod.WorkTypeID = ucCheckComboBox1.Values; mod.DefaultWorkType = ucCheckComboBox2.Values; mod.PayID = int.Parse(_lePayType.editVal.ToString()); mod.BedID = int.Parse(_leBed.editVal.ToString()); mod.TableID = int.Parse(_leTable.editVal.ToString()); mod.DepartmentID = int.Parse(_leDepartment.editVal.ToString()); mod.DegreeID = int.Parse(_leDegree.editVal.ToString()); mod.PolityID = int.Parse(_lePolity.editVal.ToString()); mod.SOSMan = _teSOSMan.Text; mod.SOSPhone = _teSOSPhone.Text; mod.NowAddress = _ltNowAddress.val; try { if (_teLastMoney.EditValue != null) { mod.LassMoney = (decimal)_teLastMoney.EditValue; } else { mod.LassMoney = 0; } } catch { mod.LassMoney = 0; } try { if (_teRoyalty.EditValue != null) { mod.Royalty = (decimal)_teRoyalty.EditValue; } else { mod.Royalty = 0; } } catch { mod.Royalty = 0; } try { if (_ltIDCard.EditVal.ToString() != string.Empty) { mod.IDCardID = long.Parse(_ltIDCard.val); } else { mod.IDCardID = 0; } } catch (Exception ex) { mod.IDCardID = 0; } if (mod.BedID > 0 && mod.BedID != _bedID) { DataTable dttt = BasicClass.GetDataSet.GetDS(BasicClass.Bllstr.bllDeparment, "GetIsUse", new object[] { mod.BedID }).Tables[0]; if (dttt.Rows.Count > 0) { if (!(Convert.ToInt32(dttt.Rows[0][0]) > Convert.ToInt32(dttt.Rows[0][1]))) { XtraMessageBox.Show("该宿舍员工已安排满员!"); return(false); } } } if (mod.TableID > 0 && mod.TableID != _tableID) { DataTable dttt = BasicClass.GetDataSet.GetDS(BasicClass.Bllstr.bllDeparment, "GetIsUse", new object[] { mod.TableID }).Tables[0]; if (dttt.Rows.Count > 0) { if (!(Convert.ToInt32(dttt.Rows[0][0]) > Convert.ToInt32(dttt.Rows[0][1]))) { XtraMessageBox.Show("该餐桌员工已安排满员!"); return(false); } } } if (mod.IDCardID != 0) { DataTable dttt = BasicClass.GetDataSet.GetDS(BasicClass.Bllstr.bllMiniEmp, "GetList", new object[] { "(IDCardID=" + mod.IDCardID + ") And (ID<>" + _id + ") And ((DimDate IS NULL) OR (DimDate = CONVERT(DATETIME, '1900-01-01 00:00:00', 102)))" }).Tables[0]; if (dttt.Rows.Count > 0) { XtraMessageBox.Show("ID卡号:" + mod.IDCardID + "已被员工" + dttt.Rows[0]["Name"].ToString() + "使用"); return(false); } } if (_ldDim.val != null) { mod.DimDate = (DateTime)_ldDim.val; } else { mod.DimDate = DateTime.Parse("1900-1-1"); } if (mod.DimDate > DateTime.Parse("1900-1-1")) { mod.IsEnd = 1; mod.IDCardID = 0; mod.TableID = 0; mod.BedID = 0; } else { mod.IsEnd = 0; } if (mod.PayID == 49 || mod.PayID == 50) { mod.LassMoney = Convert.ToInt32(lookUpEdit1.EditValue); } try { mod.NeedDeposit = Convert.ToDecimal(_teNeedDeposit.EditVal); } catch { mod.NeedDeposit = 0; } try { mod.Deposit = Convert.ToDecimal(_teDeposit.EditVal); } catch { mod.Deposit = 0; } mod.IsCaicTiCheng = _ceIsCaicTiCheng.Checked; if (_id > 0) { if (mod.Image.Trim() != string.Empty && mod.Image.Trim() != _picName.Trim()) { BasicClass.FileUpDown.DelFile(mod.Image); BasicClass.FileUpDown.DelFile("Mini" + mod.Image); } } if (_picName.Trim() != "") { BasicClass.FileUpDown.UpFile(BasicClass.BasicFile.Dir + _picName, _picName); //BasicClass.FileUpDown.UpFile(BasicClass.BasicFile.Dir + "Mini" + _picName, "Mini" + _picName); } if (_ldHeTongDate.val != null) { mod.HeTongDate = (DateTime)_ldHeTongDate.val; } else { mod.HeTongDate = DateTime.Parse("1900-1-1"); } mod.HeTongAmount = _teHeTongAmount.val; if (_ldHeTongDQDate.val != null) { mod.HeTongDQDate = (DateTime)_ldHeTongDQDate.val; } else { mod.HeTongDQDate = DateTime.Parse("1900-1-1"); } mod.Image = _picName; mod.A = 1; mod.FillDate = BasicClass.GetDataSet.GetDateTime().Date; mod.FillUser = BasicClass.UserInfo.UserID; mod.BoardWages = Convert.ToDecimal(_teBoardWages.EditValue); mod.Remark = ""; mod.MaxAmountDay = Convert.ToInt32(_teMaxAmountDay.EditValue); mod.BankAccountName = _teBankAccountName.EditValue.ToString().Trim();; mod.BankName = _teBankName.EditValue.ToString().Trim();; mod.BankNO = _teBankNO.EditValue.ToString().Trim(); //if (dt.Rows.Count > 0) // mod.Deposit = Convert.ToDecimal(dt.Rows[0]["Deposit"]); //else // mod.Deposit = 0; List <modEmployee> li = new List <modEmployee>(); li.Add(mod); DataTable dtt = BasicClass.ToDataTable.ListToDataTable <modEmployee>(li); dtt.TableName = "Emp"; if (_id == 0) { _id = mod.ID = BasicClass.GetDataSet.Add(BasicClass.Bllstr.bllMiniEmp, dtt); } else { BasicClass.GetDataSet.UpData(BasicClass.Bllstr.bllMiniEmp, dtt); } cr.ChangeText("1"); BasicClass.GetDataSet.SetDataTable(); return(true); }
private void simpleButton1_Click(object sender, EventArgs e) { r.ChangeText(Convert.ToDateTime(dateEdit1.EditValue).ToString()); this.Close(); }
private void simpleButton1_Click(object sender, EventArgs e) { try { gridView1.CloseEditor(); //byte[] bb; if (ID > -1) { if (_teSn.Text.Trim() == "" || _teUserName.Text.Trim() == "") { XtraMessageBox.Show("用户编号、用户名不能为空"); return; } } string pass; if (ID > 0) { pass = bllPW.Encrypt(textEdit1.Text.Trim(), "howneter"); byte[] bb = Convert.FromBase64String(pass); if (!((bool)(BasicClass.GetDataSet.GetOne(BasicClass.Bllstr.bllUsers, "CheckUser", new object[] { ID, bb })))) { XtraMessageBox.Show("原密码错误!"); return; } } else if (ID == 0) { if (_tePass.Text.Trim().Length == 0 || !_tePass.EditValue.Equals(_te2Pass.EditValue)) { XtraMessageBox.Show("新密码不能为空且两次密码要相同,请重新设置密码!"); _te2Pass.EditValue = _tePass.EditValue = null; return; } } else if (ID < 0) { pass = bllPW.Encrypt(textEdit1.Text.Trim(), "howneter"); byte[] bb = Convert.FromBase64String(pass); if (!((bool)(BasicClass.GetDataSet.GetOne(BasicClass.Bllstr.bllUsers, "CheckUser", new object[] { ID * -1, bb })))) { XtraMessageBox.Show("原密码错误!"); return; } DataTable dtTem = BasicClass.GetDataSet.GetDS(BasicClass.Bllstr.bllUsers, "GetList", new object[] { "(ID=" + ID * -1 + ")" }).Tables[0]; if (dtTem.Rows.Count > 0) { if (_tePass.Text.Trim().Length > 0) { if (!_tePass.EditValue.Equals(_te2Pass.EditValue)) { XtraMessageBox.Show("两次密码不一样,请重新设置密码!"); _te2Pass.EditValue = _tePass.EditValue = null; return; } } else { XtraMessageBox.Show("请输入新密码"); return; } dtTem.Rows[0]["Password"] = Convert.FromBase64String(bllPW.Encrypt(_tePass.Text.Trim(), "howneter")); BasicClass.GetDataSet.UpData(BasicClass.Bllstr.bllUsers, dtTem); XtraMessageBox.Show("密码已修改,下次登录请使用新密码!"); this.Close(); return; } } if (_tePass.Text.Trim().Length > 0) { if (!_tePass.EditValue.Equals(_te2Pass.EditValue)) { XtraMessageBox.Show("两次密码不一样,请重新设置密码!"); _te2Pass.EditValue = _tePass.EditValue = null; this.Close(); } } //if (_loJobs.EditValue == null || _loJobs.EditValue.ToString() == "0") //{ // XtraMessageBox.Show("请选择该用户所属部门职务!"); // return; //} dtUser.Rows[0]["Name"] = _teSn.EditValue.ToString().Trim(); dtUser.Rows[0]["TrueName"] = _teUserName.EditValue.ToString().Trim(); dtUser.Rows[0]["ID"] = ID; if (BasicClass.GetDataSet.GetDS(BasicClass.Bllstr.bllUsers, "GetList", new object[] { "(Name='" + _teSn.EditValue.ToString().Trim() + "') AND (ID <> " + ID + ")" }).Tables[0].Rows.Count > 0) { XtraMessageBox.Show("编号已存在"); _teSn.Focus(); return; } if (ID == 0) { dtUser.Rows[0]["Password"] = Convert.FromBase64String(bllPW.Encrypt(_tePass.Text.Trim(), "howneter")); } else { if (_tePass.Text.Trim().Length > 0) { dtUser.Rows[0]["Password"] = Convert.FromBase64String(bllPW.Encrypt(_tePass.Text.Trim(), "howneter")); } } if (_loDepartment.EditValue != null) { dtUser.Rows[0]["DepartmentID"] = int.Parse(_loDepartment.EditValue.ToString()); } else { dtUser.Rows[0]["DepartmentID"] = 0; } if (_loJobs.EditValue != null) { dtUser.Rows[0]["JobsID"] = int.Parse(_loJobs.EditValue.ToString()); } else { dtUser.Rows[0]["JobsID"] = 0; } dtUser.Rows[0]["Phone"] = ""; dtUser.Rows[0]["Email"] = ""; dtUser.Rows[0]["State"] = 0; if (ID == 0) { dtUser.Rows[0]["ID"] = BasicClass.GetDataSet.Add(BasicClass.Bllstr.bllUsers, dtUser); } else { //modAU.Password = bllAU.GetModel(ID).Password; BasicClass.GetDataSet.UpData(BasicClass.Bllstr.bllUsers, dtUser); } //SaveUserAtDepartment(modUI.UserInfoID); r.ChangeText("1"); this.Close(); } catch (Exception ex) { this.Close(); } }
private void simpleButton1_Click(object sender, EventArgs e) { if (_teAmount.Text.Trim().Length == 0 || Convert.ToDecimal(_teAmount.EditValue) == 0) { return; } if (simpleButton1.Text == "确定") { if (DialogResult.Yes == XtraMessageBox.Show("是否确认添加?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1)) { _Amount = 0; DataRow dr = dtSBIL.NewRow(); dr["A"] = 1; dr["ID"] = 0; dr["InfoID"] = _InfoID; dr["Amount"] = Convert.ToDecimal(_teAmount.EditValue); dr["Remark"] = _teReamrk.EditValue; dr["SpecID"] = lookUpEdit1.EditValue; dr["DepotInfoID"] = lookUpEdit2.EditValue; dr["MainID"] = _MainID; DataTable dtTem = dtSBIL.Clone(); dtTem.Rows.Add(dr.ItemArray); dtTem.Rows[0]["ID"] = BasicClass.GetDataSet.Add(bll, dtTem); dtSBIL.Rows.Add(dtTem.Rows[0].ItemArray); Print(Convert.ToInt32(dtTem.Rows[0]["ID"])); lookUpEdit1.EditValue = 0; // lookUpEdit2.EditValue = 0; _teAmount.EditValue = DBNull.Value; _teReamrk.EditValue = string.Empty; //for (int i = 0; i < gridView1.RowCount; i++) //{ // _Amount += Convert.ToDecimal(gridView1.GetRowCellValue(i, _coAmount)); //} //r.ChangeText(_Amount.ToString()); } } else { if (DialogResult.Yes == XtraMessageBox.Show("是否确认修改?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1)) { _Amount = 0; DataTable dtTem = dtSBIL.Clone(); DataRow[] drs = dtSBIL.Select("(ID=" + _ID + ")"); drs[0]["Amount"] = Convert.ToDecimal(_teAmount.EditValue); drs[0]["Remark"] = _teReamrk.EditValue; drs[0]["SpecID"] = lookUpEdit1.EditValue; drs[0]["DepotInfoID"] = lookUpEdit2.EditValue; dtTem.Rows.Add(drs[0].ItemArray); BasicClass.GetDataSet.UpData(bll, dtTem); dtSBIL.AcceptChanges(); Print(Convert.ToInt32(dtTem.Rows[0]["ID"])); lookUpEdit1.EditValue = 0; //lookUpEdit2.EditValue = 0; _teAmount.EditValue = DBNull.Value; _teReamrk.EditValue = string.Empty; for (int i = 0; i < gridView1.RowCount; i++) { _Amount += Convert.ToDecimal(gridView1.GetRowCellValue(i, _coAmount)); } r.ChangeText(_Amount.ToString()); simpleButton1.Text = "确定"; } } }
private void simpleButton1_Click(object sender, EventArgs e) { int _stockInfoID = 0; dtSBI.Rows.Clear(); DataRow[] drs; DateTime lt = BasicClass.GetDataSet.GetDateTime().Date.AddDays(5); string sss = string.Empty; for (int i = 0; i < gridView1.RowCount; i++) { try { _stockInfoID = Convert.ToInt32(gridView1.GetRowCellValue(i, _coStockInfoID)); if (gridView1.GetRowCellDisplayText(i, _coNowAmount).Length > 0 && Convert.ToDecimal(gridView1.GetRowCellValue(i, _coNowAmount)) > 0) { drs = dtSBI.Select("(StockInfoID=" + _stockInfoID + ")"); if (drs.Length > 0) { drs[0]["Amount"] = Convert.ToDecimal(gridView1.GetRowCellValue(i, _coNowAmount)); } else { DataRow dr = dtSBI.NewRow(); dr["ID"] = 0; dr["MainID"] = 0; dr["A"] = 3; dr["StringTaskID"] = gridView1.GetRowCellValue(i, _coStringTaskID); dr["Remark"] = string.Empty; dr["StockInfoID"] = _stockInfoID; dr["MaterielID"] = gridView1.GetRowCellValue(i, _coMaterielID); dr["ColorID"] = gridView1.GetRowCellValue(i, _coColorID); dr["ColorOneID"] = gridView1.GetRowCellValue(i, _coColorOneID); dr["ColorTwoID"] = gridView1.GetRowCellValue(i, _coColorTwoID); dr["SizeID"] = gridView1.GetRowCellValue(i, _coSizeID); dr["Price"] = gridView1.GetRowCellValue(i, _coPrice); dr["DepotMeasureID"] = dr["CompanyMeasureID"] = gridView1.GetRowCellValue(i, _coDepotMeasureID); dr["Amount"] = dr["NotAmount"] = dr["PriceAmount"] = dr["NotPriceAmount"] = gridView1.GetRowCellValue(i, _coNowAmount); dr["MListID"] = gridView1.GetRowCellValue(i, _coMListID); dr["CompanyID"] = dr["BrandID"] = dr["IsEnd"] = 0; dr["DemandID"] = 0; dr["NeedAMount"] = dr["ExcessAmount"] = 0; dr["Money"] = Convert.ToDecimal(gridView1.GetRowCellValue(i, _coNowAmount)) * Convert.ToDecimal(gridView1.GetRowCellValue(i, _coPrice)); dr["Conversion"] = 1; dr["NeedIsEnd"] = Convert.ToInt32(gridView1.GetRowCellValue(i, _coNeedIsEnd)); dr["MaterielRemark"] = gridView1.GetRowCellDisplayText(i, _coMaterielRemark); dr["LastTime"] = lt; sss += gridView1.GetRowCellDisplayText(i, _coStockRemark); dtSBI.Rows.Add(dr); } dtSBI.AcceptChanges(); } } catch { } } r.RowChang(dtSBI); r.ChangeText(sss); this.Close(); }