private void 采购明细统计_Load(object sender, EventArgs e)
{
myEntity = new MYDBEntities2();
cmbType.SelectedIndex = 0;
InitUsers();
InitData();
}
private void 采购借款记录_Load(object sender, EventArgs e)
{
if (Mydb == null)
{
Mydb = new MYDBEntities2();
}
btnWriteOff.Visible = DisplayWriteOff;
InitData();
dgvLoan.DataSource = DaLoanBindingSource;
dgvLoan.DataBindingComplete += Classes.PubFunc.dgv_DataBindingComplete;
}
public bool MultiSelect = false; //是否可以多选
private void 择供应商_Load(object sender, EventArgs e)
{
dgvDaSupplier.MultiSelect = MultiSelect;
if (myEntity == null)
{
myEntity = new MYDBEntities2();
}
//获取现有的关系
mDaSupplier = myEntity.DaGoodsSuppliers.Where(d => d.IntGoodsID == mDaGoodsID).Select(d => d.DaSupplier.IntID).ToList();
InitData();
SearchData();
}
private void 到货信息编辑_Load(object sender, EventArgs e)
{
myEntity = new MYDBEntities2();
/*
* //判断是否有货物已入库
* var mStockIn = myEntity.DaStockIns.Where(d => d.IntContractID == mContractID).ToList();
*
* if (mStockIn.Count > 0)
* mDaStockInID = mStockIn[0].IntID;
*/
InitData();
}
private void 采购合同编辑_Load(object sender, EventArgs e)
{
if (myEntity == null)
{
myEntity = new MYDBEntities2();
}
InitGoodsTable();
DaSupplierBindingSource.DataSource = goodsTable;
dgvPurchaseGoods.DataSource = DaSupplierBindingSource;
isLoading = true;
InitCmbDaType();
InitData();
isLoading = false;
}
private void 择采购物品_Load(object sender, EventArgs e)
{
if (myEntity == null)
{
myEntity = new MYDBEntities2();
}
//if(DaGoods != null)
//{
// //已选择,显示选择的物品;
// txtGoodsNum.Text = DaGoods.VcNum;
// txtGoodsName.Text = DaGoods.VcName;
//}
InitGoodsNameData();
InitDataBinding();
}
private void 发票信息编辑_Load(object sender, EventArgs e)
{
if (myEntity == null)
{
myEntity = new MYDBEntities2();
}
//获取已到票信息
var mDaInvoice = myEntity.DaInvoices.Where(d => d.IntContractGoodsID == MContractGoodsId).ToList();
if (mDaInvoice.Count > 0)
{
MInvoiceId = mDaInvoice[0].IntID;
}
InitData();
}
private void InitData()
{
if (myEntity == null)
{
myEntity = new MYDBEntities2();
}
ZDUnitBindingSource.DataSource = myEntity.ZdGoodsUnits.ToList();
cmbUnit.DataSource = ZDUnitBindingSource;
cmbUnit.DisplayMember = "VcDesc";
cmbUnit.ValueMember = "ID";
if (mDaGoodsID > 0)
{
//修改
mDaGoods = myEntity.DaGoods1.SingleOrDefault(d => d.IntID == mDaGoodsID);
oldNum = mDaGoods.VcNum;
//mDaGoodsTypeID = mda
//cmbUnit.SelectedValue = mDaGoods.IntUnit;
}
else
{
//新增
string maxNum;
GetMaxNum("1", out maxNum);
mDaGoods = new DaGoods()
{
IntTypeID = mDaGoodsTypeID, VcNum = maxNum, IntStatus = 0
};
}
txtNum.DataBindings.Add("Text", mDaGoods, "VcNum");
txtName.DataBindings.Add("Text", mDaGoods, "VcName");
txtNorms.DataBindings.Add("Text", mDaGoods, "VcNorms");
txtRemark.DataBindings.Add("Text", mDaGoods, "VcRemark");
txtTypeName.Text = myEntity.DaGoodsTypes.SingleOrDefault(d => d.IntID == mDaGoods.IntTypeID).VcType;// mDaGoodsTypeName;
txtPrice.DataBindings.Add("Text", mDaGoods, "MonPrice", true);
cmbUnit.DataBindings.Add("SelectedValue", mDaGoods, "IntUnit");
}
private void 增加供应商_Load(object sender, EventArgs e)
{
if (myEntity == null)
{
myEntity = new MYDBEntities2();
}
if (DaSupplierID == 0)
{
//新增
string maxNum = myEntity.DaSuppliers.Select(a => a.VcNum).Max();
maxNum = !string.IsNullOrEmpty(maxNum) ? (Convert.ToInt64(maxNum) + 1).ToString() : "1000001";
txtDaSupplierNum.Text = maxNum;
}
else
{
//修改
//根据DaSupplierID获取供应商
mDaSupplier = myEntity.DaSuppliers.Where(d => d.IntID == DaSupplierID).SingleOrDefault();
txtName.Text = mDaSupplier.VcName;
txtRegCapital.Text = mDaSupplier.VcRegCapital;
txtLegalRep.Text = mDaSupplier.VcLegalRep;
txtTaxID.Text = mDaSupplier.VcTaxID;
txtOpeningBank.Text = mDaSupplier.VcOpeningBank;
txtBankAccount.Text = mDaSupplier.VcBankAccount;
txtAddress.Text = mDaSupplier.VcAddress;
txtWebsite.Text = mDaSupplier.VcWebsite;
txtTel.Text = mDaSupplier.VcTel;
txtFax.Text = mDaSupplier.VcFax;
txtPostCode.Text = mDaSupplier.VcPostCode;
txtRemark.Text = mDaSupplier.VcRemark;
//DaSupplierbindingSource.DataSource = mDaSupplier;
//txtName.DataBindings.Add("Text", DaSupplierbindingSource, "VcName");
//txtRegCapital.DataBindings.Add("Text", DaSupplierbindingSource, "VcRegCapital");
}
}
private void InitData()
{
if (myEntity == null)
{
myEntity = new MYDBEntities2();
}
if (DaContactID > 0)
{
//修改
mDaSuppContact = myEntity.DaSupplierContacts.Where(d => d.IntID == DaContactID).SingleOrDefault();
DaSupplierID = mDaSuppContact.IntSupplierID;
}
else
{
//增加
mDaSuppContact = new DaSupplierContact()
{
IntSupplierID = DaSupplierID, IntEmpNum = Classes.PubClass.UserId
};
DaSupplier daSupplier = myEntity.DaSuppliers.SingleOrDefault(d => d.IntID == DaSupplierID);
if (daSupplier != null)
{
mDaSuppContact.VcTel = daSupplier.VcTel;
mDaSuppContact.VcFax = daSupplier.VcFax;
}
}
bindingSourceDaSuppContact.DataSource = mDaSuppContact;
txtName.Text = myEntity.DaSuppliers.Where(d => d.IntID == DaSupplierID).SingleOrDefault().VcName;
txtContactName.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcName");
txtPost.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcPost");
txtTel.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcTel");
txtFax.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcFax");
txtMobile.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcMobile");
txtQQ.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcQQ");
txtEmail.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcEmail");
txtRemark.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcRemark");
}
private void OK_Click(object sender, EventArgs e)
{
try
{
MYDBEntities2 myEntity = new MYDBEntities2();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
string LoginName, Password;
LoginName = txtLoginName.Text.Trim();
Password = txtPassword.Text.Trim();
List <T_Users> Users = myEntity.T_Users.Where(d => d.LoginName == LoginName).ToList();
if (Users.Count < 1)
{
MessageBox.Show("登录名输入错误");
return;
}
else
{
var User = Users.FirstOrDefault();
Password = Classes.MD5.Md5Encrypt(Password);
if (string.Compare(Password, User.PassWord) != 0)
{
MessageBox.Show("密码输入错误");
txtPassword.Text = "";
return;
}
if (User.UserStatus != "正常")
{
MessageBox.Show("该账户已停用");
return;
}
if (LoginName.ToLower() == "admin")
{
CommonClass.SttUser.blSuperUser = true;
}
else
{
CommonClass.SttUser.blSuperUser = false;
}
Classes.PubClass.LoginName = LoginName;
Classes.PubClass.UserId = User.id;
Classes.PubClass.UserName = User.UserName;
Classes.PubClass.UserRight = User.OperRight;
Classes.PubClass.UserStatus = User.UserStatus;
Classes.PubClass.UserRoleId = User.IntRoleID ?? -1;
//添加权限
CommonClass.UserRightList.Clear();
销售管理.BLL.Da.GetUserRight(Classes.PubClass.UserRoleId);
CommonClass.SttDb.iDBType = 1;
isLogined = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//var mTable = new T_UsersTableAdapter().GetDataByLoginName(LoginName);
//if (mTable.Rows.Count < 1)
//{
// MessageBox.Show("登录名输入错误");
// return;
//}
//else
//{
// var mRow = (销售管理.DAL.DataSetUsers.T_UsersRow)mTable.Rows[0];
// Password = Classes.MD5.Md5Encrypt(Password);
// if (string.Compare(Password, mRow.PassWord) != 0)
// {
// MessageBox.Show("密码输入错误");
// txtPassword.Text = "";
// return;
// }
// Classes.PubClass.LoginName = LoginName;
// Classes.PubClass.UserId = mRow.id;
// Classes.PubClass.UserName = mRow.UserName;
// Classes.PubClass.UserRight = mRow.OperRight;
// Classes.PubClass.UserStatus = mRow.UserStatus;
// isLogined = true;
//}
System.Net.IPAddress[] IPs = System.Net.Dns.GetHostAddresses(System.Net.Dns.GetHostName());
for (int c = 0; c < IPs.Length; c++)
{
if (IPs[c].AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork)
{
new T_LoginLogTableAdapter().Insert(Classes.PubClass.UserId, IPs[c].ToString());
}
}
MainForm mForm = new MainForm(this);
// mForm.tssb用户名.Text = "登录用户名:"+ Classes.PubClass.UserName +" | 权限:" + Classes.PubClass.UserRight;
mForm.LoadModuleListFromDb(Classes.PubClass.UserRoleId);
mForm.Show();
//this.DialogResult = DialogResult.OK;
this.Hide();
}
private void OK_Click(object sender, EventArgs e)
{
//获取连接字符串
string file = System.Windows.Forms.Application.ExecutablePath;
Configuration config = ConfigurationManager.OpenExeConfiguration(file);
String xmlPath = "DBInfo.xml";
if (xmlPath == null)
{
MessageBox.Show("请先选择数据源！");
}
Common.SqlConnectionSet.SetConnStr(xmlPath.Trim());
try
{
MYDBEntities2 myEntity = new MYDBEntities2();
this.DialogResult = System.Windows.Forms.DialogResult.OK;
string LoginName, Password;
LoginName = txtLoginName.Text.Trim();
Password = txtPassword.Text.Trim();
List <T_Users> Users = myEntity.T_Users.Where(d => d.LoginName == LoginName).ToList();
if (Users.Count < 1)
{
MessageBox.Show("登录名输入错误");
return;
}
else
{
var User = Users.FirstOrDefault();
Password = Classes.MD5.Md5Encrypt(Password);
if (string.Compare(Password, User.PassWord) != 0)
{
MessageBox.Show("密码输入错误");
txtPassword.Text = "";
return;
}
if (User.UserStatus != "正常")
{
MessageBox.Show("该账户已停用");
return;
}
if (LoginName.ToLower() == "admin")
{
CommonClass.SttUser.blSuperUser = true;
}
else
{
CommonClass.SttUser.blSuperUser = false;
}
Classes.PubClass.LoginName = LoginName;
Classes.PubClass.UserId = User.id;
Classes.PubClass.UserName = User.UserName;
Classes.PubClass.UserRight = User.OperRight;
Classes.PubClass.UserStatus = User.UserStatus;
Classes.PubClass.UserRoleId = User.IntRoleID ?? -1;
//添加权限
CommonClass.UserRightList.Clear();
销售管理.BLL.Da.GetUserRight(Classes.PubClass.UserRoleId);
CommonClass.SttDb.iDBType = 1;
isLogined = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
System.Net.IPAddress[] IPs = System.Net.Dns.GetHostAddresses(System.Net.Dns.GetHostName());
for (int c = 0; c < IPs.Length; c++)
{
if (IPs[c].AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork)
{
new T_LoginLogTableAdapter().Insert(Classes.PubClass.UserId, IPs[c].ToString());
}
}
MainForm mForm = new MainForm(this);
//mForm.tssb用户名.Text = "登录用户名:"+ Classes.PubClass.UserName +" | 权限:" + Classes.PubClass.UserRight;
mForm.LoadModuleListFromDb(Classes.PubClass.UserRoleId);
mForm.Show();
//this.DialogResult = DialogResult.OK;
this.Hide();
}
