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();
}
