/// <summary>
/// 确定按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonX1_Click(object sender, EventArgs e)
{
try
{
string wuliudanhao = this.textBoxXdanhao.Text.Trim(); //单号
string wuliumingc = this.textBoxXname.Text.Trim(); //名称
string wuliuTel = this.textBoxXTel.Text.Trim(); //电话
DateTime daohrq = this.dateTimeInput1.Value; //预计到货日期
Buy b = new Buy();
b.Buy_LogCode = XYEEncoding.strCodeHex(wuliudanhao);
b.Buy_Logistics = XYEEncoding.strCodeHex(wuliumingc);
b.Buy_LogPhone = XYEEncoding.strCodeHex(wuliuTel);
b.Buy_GetDate = daohrq;
b.Buy_Code = XYEEncoding.strCodeHex(danhao);
bool result = bm.LogisticalUpdate(b);
if (result)
{
MessageBox.Show("物流信息添加成功！");
this.Close();
return;
}
else
{
MessageBox.Show("物流信息添加失败!");
return;
}
}
catch (Exception ex)
{
MessageBox.Show("错误代码:3214-新增物流信息时保存异常，异常信息：" + ex.Message);
}
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="ba">参数实体类</param>
/// <returns></returns>
public int InsBankAccount(BankAccount ba)
{
string sql = @"insert into T_BankAccount(
Ba_Code,
Ba_OpenBank,
Ba_Account,
Ba_CardHolder,
Ba_Remark,
Ba_AvailablePrice,
Ba_Enable,
Ba_Clear)
values (
@Ba_Code,
@Ba_OpenBank,
@Ba_Account,
@Ba_CardHolder,
@Ba_Remark,
@Ba_AvailablePrice,
@Ba_Enable,
@Ba_Clear)";
SqlParameter[] sps =
{
new SqlParameter("@Ba_Code", XYEEncoding.strCodeHex(ba.Ba_Code)),
new SqlParameter("@Ba_OpenBank", XYEEncoding.strCodeHex(ba.Ba_OpenBank)),
new SqlParameter("@Ba_Account", XYEEncoding.strCodeHex(ba.Ba_Account)),
new SqlParameter("@Ba_CardHolder", XYEEncoding.strCodeHex(ba.Ba_CardHolder)),
new SqlParameter("@Ba_Remark", XYEEncoding.strCodeHex(ba.Ba_Remark)),
new SqlParameter("@Ba_AvailablePrice", XYEEncoding.strCodeHex(ba.Ba_AvailablePrice)),
new SqlParameter("@Ba_Enable", ba.Ba_Enable),
new SqlParameter("@Ba_Clear", ba.Ba_Clear)
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Role model)
{
model.Role_Code = XYEEncoding.strCodeHex(model.Role_Code);
model.Role_Modules = XYEEncoding.strCodeHex(model.Role_Modules);
model.Role_Name = XYEEncoding.strCodeHex(model.Role_Name);
return(dal.Add(model));
}
/// <summary>
/// 删除按钮 转码code用于删除的where条件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void 除DToolStripMenuItem_Click(object sender, EventArgs e)
{
if (superGridControl1.PrimaryGrid.GetSelectedRows() == null)
{
ClientTypeManager ctm = new ClientTypeManager();
SelectedElementCollection col = superGridControl1.PrimaryGrid.GetSelectedRows();
DialogResult dr = MessageBox.Show("确定要删除该数据吗?操作不可恢复", "请注意",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
GridRow row = col[0] as GridRow;
string code = XYEEncoding.
strCodeHex(row.Cells["TypeCode"].Value.ToString());
bool result = ctm.Delete(code);
if (result)
{
loadData();
MessageBox.Show("客户类别删除成功");
}
else
{
MessageBox.Show("删除失败,请检查是否选中列");
}
}
else
{
MessageBox.Show("请先选中要修改的数据所在行");
}
}
/// <summary>
/// 新增物流跟进
/// </summary>
/// <param name="buyprocess"></param>
/// <returns></returns>
public int InsBuyFollow(BuyProcess buyprocess)
{
string sql = @"INSERT INTO T_BuyProcess
(BP_Code
,BP_Datetime
,BP_Opt
,BP_Ope
,BP_Remark)
Values
(@BP_Code
,@BP_Datetime
,@BP_Opt
,@BP_Ope
,@BP_Remark)";
SqlParameter[] sps =
{
new SqlParameter("@BP_Code", XYEEncoding.strCodeHex(buyprocess.BP_Code)),
new SqlParameter("@BP_Datetime", buyprocess.BP_Datetime),
new SqlParameter("@BP_Opt", XYEEncoding.strCodeHex(buyprocess.BP_Opt)),
new SqlParameter("@BP_Ope", XYEEncoding.strCodeHex(buyprocess.BP_Ope)),
new SqlParameter("@BP_Remark", XYEEncoding.strCodeHex(buyprocess.BP_Remark))
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
private void BuyPaymentForm_Load(object sender, EventArgs e)
{
try
{
//绑定采购明细
DataTable dt = ch.DataTableReCoding(bpm.SelEmp(" buy.Buy_Code='" + XYEEncoding.strCodeHex(_buycode) + "'").Tables[0]);
superGridControl1.PrimaryGrid.DataSource = dt;
superGridControl1.PrimaryGrid.AllowEdit = false;
LoginInfomation l = LoginInfomation.getInstance();
l.UserName = "******";
ltxt_operation.Text = l.UserName;
txt_yifu.Visible = false;
ltxt_weipay.ReadOnly = true;
dataGridViewFujia.ReadOnly = true;
dataGridViewFujia.AllowUserToResizeColumns = false; //是否可以调整列的大小
dataGridViewFujia.AllowUserToResizeRows = false; //是否可以调整行的大小
txt_caigoucode.Text = _buycode;
ltxt_suname.Text = _suname;
ltxt_AccountName.Text = _acountname;
txt_shif.Text = _fukuan;
ltxt_saleman.Text = _saleman;
}
catch (Exception ex)
{
MessageBox.Show("错误代码:3205-创建采购付款单异常，异常信息：" + ex.Message);
}
textBoxOddNumbers.Text = BuildCode.ModuleCode("AP");
}
private void buttonSave_Click(object sender, EventArgs e)
{
if (InsTextIsNull() == false)
{
return;
}
try
{
int result = InsBuypaymentFun();
if (result > 0)
{
bool r = bm.PaymentUpdateByCode(XYEEncoding.strCodeHex(_buycode), 2);
if (r)
{
MessageBox.Show("保存成功");
Close();
Dispose();
return;
}
}
else
{
MessageBox.Show("保存失败");
return;
}
}
catch (Exception ex)
{
MessageBox.Show("错误代码:3206-保存采购付款单异常，异常信息：" + ex.Message);
}
}
// 分页获取数据列表
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 根据code更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateByCode(City model)
{
model.City_Name = XYEEncoding.strCodeHex(model.City_Name);
model.City_Code = XYEEncoding.strCodeHex(model.City_Code);
model.City_ParentId = XYEEncoding.strCodeHex(model.City_ParentId);
return(dal.UpdateByCode(model));
}
/// <summary>
/// 批量更新数据
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public bool UpdateBatch(DataTable ds)
{
StringBuilder strSql = new StringBuilder();
foreach (DataRow dr in ds.Rows)
{
if (dr.RowState == DataRowState.Modified)
{
strSql.Append("update T_Permission set Per_ReadState = " + dr["Per_ReadState"] +
",Per_WriteState = " + dr["Per_WriteState"] +
",Per_AuditState = " + dr["Per_AuditState"] +
" where Per_Code = '" + XYEEncoding.strCodeHex(dr["Per_Code"].ToString()) + "';");
}
}
if (strSql.Length == 0)
{
return(false);
}
int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(MaterialType model)
{
model.MT_Code = XYEEncoding.strCodeHex(model.MT_Code);
model.MT_Name = XYEEncoding.strCodeHex(model.MT_Name);
model.MT_ParentID = XYEEncoding.strCodeHex(model.MT_ParentID);
return(dal.Add(model));
}
/// <summary>
/// 根据user_role做内链接
/// </summary>
/// <param name="name"></param>
/// <param name="password"></param>
/// <returns></returns>
public DataTable GetUserAndRoleModel(string name, string password)
{
CodingHelper ch = new CodingHelper();
//查询后解密返回
return(ch.DataTableReCoding(dal.GetUserAndRoleModel(XYEEncoding.strCodeHex(name),
XYEEncoding.strCodeHex(password))));
}
/// <summary>
/// 根据code更新一条数据
/// </summary>
public bool UpdateByCode(MaterialType model)
{
model.MT_Name = XYEEncoding.strCodeHex(model.MT_Name);
model.MT_Code = XYEEncoding.strCodeHex(model.MT_Code);
model.MT_ParentID = XYEEncoding.strCodeHex(model.MT_ParentID);
return(dal.UpdateByCode(model));
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 是否存在该记录
/// </summary>
public bool UpdateByCode(Storage model)
{
model.St_Address = XYEEncoding.strCodeHex(model.St_Address);
model.St_Code = XYEEncoding.strCodeHex(model.St_Code);
model.St_EmpName = XYEEncoding.strCodeHex(model.St_EmpName);
model.St_Name = XYEEncoding.strCodeHex(model.St_Name);
model.St_Phone = XYEEncoding.strCodeHex(model.St_Phone);
model.St_Remark = XYEEncoding.strCodeHex(model.St_Remark);
return(dal.UpdateByCode(model));
}
/// <summary>
/// 批量插入权限信息到数据库中
/// </summary>
/// <param name="pList">要新增的实体列表</param>
/// <returns></returns>
public int AddBatch(List <Permission> pList)
{
foreach (var p in pList)
{
p.Per_Code = XYEEncoding.strCodeHex(p.Per_Code);
p.Per_ModuleName = XYEEncoding.strCodeHex(p.Per_ModuleName);
p.Per_RoleCode = XYEEncoding.strCodeHex(p.Per_RoleCode);
p.Per_Type = XYEEncoding.strCodeHex(p.Per_Type);
}
return(dal.AddBatch(pList));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Storage model)
{
model.St_Address = XYEEncoding.strCodeHex(model.St_Address);
model.St_Code = XYEEncoding.strCodeHex(model.St_Code);
model.St_EmpName = XYEEncoding.strCodeHex(model.St_EmpName);
model.St_Name = XYEEncoding.strCodeHex(model.St_Name);
model.St_Phone = XYEEncoding.strCodeHex(model.St_Phone);
model.St_Remark = XYEEncoding.strCodeHex(model.St_Remark);
return(dal.Add(model));
}
/// <summary>
/// 查询历史折扣
/// </summary>
/// <param name="clientName"></param>
/// <param name="maName"></param>
/// <returns></returns>
public DataTable SelDiscountByAccount(string clientName, string maName)
{
string sql = string.Format(@"select DISTINCT '241E2E532E3F583F' as 价格类型,sd.Sell_DiscountAPrice as 价格,sd.Sell_Discount as 折扣率 from T_Sell s
inner join T_SellDetail sd on sd.Sell_Code = s.Sell_Code
where s.Sell_ClientName = '{0}' and sd.Sell_MaName = '{1}'", XYEEncoding.strCodeHex(clientName), XYEEncoding.strCodeHex(maName));
SqlDataAdapter adapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString);
DataSet ds = new DataSet();
adapter.Fill(ds, "T_SellDetail");
return(ch.DataTableReCoding(ds.Tables[0]));
}
/// <summary>
/// 多条件查询(地区类型-地区列表-关键词)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolStripButton5_Click(object sender, EventArgs e)
{
try
{
List <Supplier> list = new List <Supplier>();
string SQLWhere = "";
string treeName = treeView1.SelectedNode.Text;
string treeTag = treeView1.SelectedNode.Tag.ToString();
string searchType = toolStripComboBox2.Text.Trim();
string searchKey = XYEEncoding.strCodeHex(toolStripSelTxt.Text.Trim());
if (treeView1.SelectedNode == null) //如果TreeView选中项为空
{
return;
}
if (string.IsNullOrWhiteSpace(toolStripSelTxt.Text.Trim())) //如果搜索关键字为空
{
return;
}
SQLWhere += string.Format("Su_Area like '%{0}%'", XYEEncoding.strCodeHex(treeName));
//模糊查询城市名
switch (searchType) //搜索框内容加密后
{
case "单位名称":
SQLWhere += string.Format(" and Su_Name like '%{0}%'", searchKey);
break;
case "联系人":
SQLWhere += string.Format(" and Su_Empname like '%{0}%'", searchKey);
break;
case "联系手机":
SQLWhere += string.Format(" and Su_EmpPhone like '%{0}%'", searchKey);
break;
case "常用电话":
SQLWhere += string.Format(" and Su_Phone like '%{0}%'", searchKey);
break;
default:
MessageBox.Show("类型选择错误，请重新选择！");
break;
}
list = sm.SelSupplierByWhere(SQLWhere); //拼接where
superGridControl1.PrimaryGrid.DataSource = list;
}
catch (Exception ex)
{
MessageBox.Show("加载数据失败,请检查服务器连接并尝试刷新.错误:" + ex.Message);
}
}
public Sell SelSellGatheringBySellCode(string Sell_Code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Sell_ID,Sell_Code,Sell_Type,Sell_Date,Sell_TransportType,Sell_Review,Sell_ChangeDate,Sell_Operation,Sell_Auditman,Sell_Remark,");
strSql.Append("Sell_IsPay,Sell_IsPutSto,Sell_PayMathod,Sell_GetDate,Sell_Logistics,Sell_LogCode,Sell_LogPhone,Sell_OddMoney,Sell_AccountCode,Sell_InMoney,Sell_LastMoney,Sell_Address,");
strSql.Append("Sell_ClientName,Sell_CliPhone,Sell_LinkMan,Sell_Salesman,Sell_OddStatus,Sell_jiajiState,Sell_zuiwanshijian,Sell_fukuanfangshi from T_Sell");
strSql.Append(" where Sell_Code=@Sell_Code");
SqlParameter[] parameters =
{
new SqlParameter("@Sell_Code", SqlDbType.NVarChar, 512)
};
parameters[0].Value = XYEEncoding.strCodeHex(Sell_Code);
SqlDataReader read = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters);
while (read.Read())
{
Sell model = new Sell();
model.Sell_ID = Convert.ToInt32(read["Sell_ID"]);
model.Sell_Code = XYEEncoding.strHexDecode(read["Sell_Code"].ToString());
model.Sell_Type = XYEEncoding.strHexDecode(read["Sell_Type"].ToString());
model.Sell_Date = Convert.ToDateTime(read["Sell_Date"]);
model.Sell_TransportType = XYEEncoding.strHexDecode(read["Sell_TransportType"].ToString());
model.Sell_Review = Convert.ToInt32(read["Sell_Review"]);
model.Sell_ChangeDate = Convert.ToDateTime(read["Sell_ChangeDate"]);
model.Sell_Operation = XYEEncoding.strHexDecode(read["Sell_Operation"].ToString());
model.Sell_Auditman = XYEEncoding.strHexDecode(read["Sell_Auditman"].ToString());
model.Sell_Remark = XYEEncoding.strHexDecode(read["Sell_Remark"].ToString());
model.Sell_IsPay = Convert.ToInt32(read["Sell_IsPay"]);
model.Sell_IsPutSto = Convert.ToInt32(read["Sell_IsPutSto"]);
model.Sell_PayMathod = Convert.ToInt32(read["Sell_PayMathod"]);
model.Sell_GetDate = Convert.ToDateTime(read["Sell_GetDate"]);
model.Sell_Logistics = XYEEncoding.strHexDecode(read["Sell_Logistics"].ToString());
model.Sell_LogCode = XYEEncoding.strHexDecode(read["Sell_LogCode"].ToString());
model.Sell_LogPhone = XYEEncoding.strHexDecode(read["Sell_LogPhone"].ToString());
model.Sell_OddMoney = read["Sell_OddMoney"].ToString();
model.Sell_AccountCode = XYEEncoding.strHexDecode(read["Sell_AccountCode"].ToString());
model.Sell_InMoney = read["Sell_InMoney"].ToString();
model.Sell_LastMoney = read["Sell_LastMoney"].ToString();
model.Sell_Address = XYEEncoding.strHexDecode(read["Sell_Address"].ToString());
model.Sell_ClientName = XYEEncoding.strHexDecode(read["Sell_ClientName"].ToString());
model.Sell_CliPhone = XYEEncoding.strHexDecode(read["Sell_CliPhone"].ToString());
model.Sell_LinkMan = XYEEncoding.strHexDecode(read["Sell_LinkMan"].ToString());
model.Sell_Salesman = XYEEncoding.strHexDecode(read["Sell_Salesman"].ToString());
model.Sell_OddStatus = Convert.ToInt32(read["Sell_OddStatus"]);
model.Sell_jiajiState = Convert.ToInt32(read["Sell_jiajiState"]);
model.Sell_zuiwanshijian = Convert.ToDateTime(read["Sell_zuiwanshijian"]);
model.Sell_fukuanfangshi = XYEEncoding.strHexDecode(read["Sell_fukuanfangshi"].ToString());
return(model);
}
return(null);
}
/// <summary>
/// 根据工号修改信息
/// </summary>
/// <param name="empolyee"></param>
/// <returns></returns>
public int UpdateEmpolyee(Empolyee empolyee)
{
string sql = @"update T_Empolyee set
Emp_Name=@Emp_Name
,Emp_Password=@Emp_Password
,Emp_UserRole=@Emp_UserRole
,Emp_Area=@Emp_Area
,Emp_zhiwen=@Emp_zhiwen
,Emp_CardCode=@Emp_CardCode
,Emp_Depid=@Emp_Depid
,Emp_Sex=@Emp_Sex
,Emp_Card=@Emp_Card
,Emp_State=@Emp_State
,Emp_Phone=@Emp_Phone
,Emp_Bank=@Emp_Bank
,Emp_OpenBank=@Emp_OpenBank
,Emp_Birthday=@Emp_Birthday
,Emp_Email=@Emp_Email
,Emp_Education=@Emp_Education
,Emp_School=@Emp_School
,Emp_Entry=@Emp_Entry
,Emp_Enable=@Emp_Enable
,Emp_Clear=@Emp_Clear
where Emp_Code=@Emp_Code";
SqlParameter[] sps =
{
new SqlParameter("@Emp_Code", XYEEncoding.strCodeHex(empolyee.Emp_Code)),
new SqlParameter("@Emp_Name", XYEEncoding.strCodeHex(empolyee.Emp_Name)),
new SqlParameter("@Emp_Password", XYEEncoding.strCodeHex(empolyee.Emp_Password)),
new SqlParameter("@Emp_UserRole", XYEEncoding.strCodeHex(empolyee.Emp_UserRole)),
new SqlParameter("@Emp_Area", XYEEncoding.strCodeHex(empolyee.Emp_Area)),
new SqlParameter("@Emp_zhiwen", empolyee.Emp_zhiwen),
new SqlParameter("@Emp_CardCode", XYEEncoding.strCodeHex(empolyee.Emp_CardCode)),
new SqlParameter("@Emp_Depid", XYEEncoding.strCodeHex(empolyee.Emp_Depid)),
new SqlParameter("@Emp_Sex", XYEEncoding.strCodeHex(empolyee.Emp_Sex)),
new SqlParameter("@Emp_Card", XYEEncoding.strCodeHex(empolyee.Emp_Card)),
new SqlParameter("@Emp_State", empolyee.Emp_State),
new SqlParameter("@Emp_Phone", XYEEncoding.strCodeHex(empolyee.Emp_Phone)),
new SqlParameter("@Emp_Bank", XYEEncoding.strCodeHex(empolyee.Emp_Bank)),
new SqlParameter("@Emp_OpenBank", XYEEncoding.strCodeHex(empolyee.Emp_OpenBank)),
new SqlParameter("@Emp_Birthday", empolyee.Emp_Birthday),
new SqlParameter("@Emp_Email", XYEEncoding.strCodeHex(empolyee.Emp_Email)),
new SqlParameter("@Emp_Education", XYEEncoding.strCodeHex(empolyee.Emp_Education)),
new SqlParameter("@Emp_School", XYEEncoding.strCodeHex(empolyee.Emp_School)),
new SqlParameter("@Emp_Entry", empolyee.Emp_Entry),
new SqlParameter("@Emp_Enable", empolyee.Emp_Enable),
new SqlParameter("@Emp_Clear", empolyee.Emp_Clear),
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
/// <summary>
/// 增加信息
/// </summary>
/// <param name="profession">模型载体</param>
/// <returns>受影响行数</returns>
public int InsProfession(Profession profession)
{
string sql = "insert into T_Profession(ST_Code,ST_Name,ST_ParentId,ST_Enable,ST_Clear,) values(@ST_Code,@ST_Name,@ST_ParentId,@ST_Enable,@ST_Clear,)";
SqlParameter[] sps =
{
new SqlParameter("@ST_Name", XYEEncoding.strCodeHex(profession.ST_Name)),
new SqlParameter("@ST_Code", XYEEncoding.strCodeHex(profession.ST_Code)),
new SqlParameter("@ST_ParentId", XYEEncoding.strCodeHex(profession.ST_ParentId)),
new SqlParameter("@ST_Enable", profession.ST_Enable),
new SqlParameter("@ST_Clear", profession.ST_Clear)
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
/// <summary>
/// 根据编号更新信息
/// </summary>
/// <param name="profession">模型载体</param>
/// <returns>受影响行数</returns>
public int UpdateProfession(Profession profession)
{
string sql = "update T_Profession set ST_Name=@ST_Name,ST_ParentId=@ST_ParentId,ST_Enable=@ST_Enable,ST_Clear=@ST_Clear where ST_Code=@ST_Code and ST_Enable=1 and ST_Clear=1";
SqlParameter[] sps =
{
new SqlParameter("@ST_Name", XYEEncoding.strCodeHex(profession.ST_Name)),
new SqlParameter("@ST_ParentId", XYEEncoding.strCodeHex(profession.ST_ParentId)),
new SqlParameter("@ST_Enable", profession.ST_Enable),
new SqlParameter("@ST_Clear", profession.ST_Clear),
new SqlParameter("@ST_Code", XYEEncoding.strCodeHex(profession.ST_Code))
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
private void buttonXLogin_Click(object sender, EventArgs e)
{
User u = new User();
UserManager um = new UserManager();
PermissionManager pm = new PermissionManager();
string name = textBoxXName.Text.Trim();
string password = textBoxXPassword.Text.Trim();
if (string.IsNullOrWhiteSpace(name))
{
labelName.Visible = true;
labelNull.Text = "请输入用户名";
labelNull.Visible = true;
}
else if (string.IsNullOrWhiteSpace(password))
{
labelPW.Visible = true;
labelNull.Text = "请输入密码";
labelNull.Visible = true;
}
else
{
if (!um.Exists(name))
{
labelName.Visible = false;
labelPW.Visible = false;
labelNull.Text = "用户名不存在";
labelNull.Visible = true;
return;
}
DataTable user = um.GetUserAndRoleModel(name, password);
if (user.Rows.Count > 0)
{
LoginInfomation information = LoginInfomation.getInstance();
information.UserName = user.Rows[0]["User_Name"].ToString();
information.UserRole = user.Rows[0]["Role_Name"].ToString();
information.UserCode = user.Rows[0]["User_Code"].ToString();
//根据角色里的权限编码查询所拥有的权限信息
DataSet permission = pm.GetList("Per_Code = '" +
XYEEncoding.strCodeHex(user.Rows[0]["Role_Modules"].ToString()) + "'");
getPermissionList(permission);
Close();
}
else
{
labelNull.Text = "密码不正确";
labelNull.Visible = true;
}
}
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(string C_No)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from T_Conllection");
strSql.Append(" where C_No=@C_No");
SqlParameter[] parameters =
{
new SqlParameter("@C_No", SqlDbType.VarChar, 512)
};
parameters[0].Value = XYEEncoding.strCodeHex(C_No);
return(DbHelperSQL.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 根据编号修改信息
/// </summary>
/// <param name="supplier">模型载体</param>
/// <returns>受影响行数</returns>
public int UpdateSupplier(Supplier supplier)
{
string sql = string.Format(@"UPDATE T_Supplier
SET Su_Name = @Su_Name
,Su_Phone = @Su_Phone
,Su_Address = @Su_Address
,Su_fax = @Su_fax
,Su_Email = @Su_Email
,Su_Bankaccounts = @Su_Bankaccounts
,Su_Bank = @Su_Bank
,Su_Profession = @Su_Profession
,Su_ProCode = @Su_ProCode
,Su_Credit = @Su_Credit
,Su_Money = @Su_Money
,Su_Surplus = @Su_Surplus
,Su_Reckoning = @Su_Reckoning
,Su_Empname = @Su_Empname
,Su_EmpPhone = @Su_EmpPhone
,Su_Remark = @Su_Remark
,Su_Enable = @Su_Enable
,Su_Clear = @Su_Clear
,Su_Area=@Su_Area
WHERE Su_Code=@Su_Code");
SqlParameter[] sps =
{
new SqlParameter("@Su_Name", XYEEncoding.strCodeHex(supplier.Su_Name)),
new SqlParameter("@Su_Phone", XYEEncoding.strCodeHex(supplier.Su_Phone)),
new SqlParameter("@Su_Address", XYEEncoding.strCodeHex(supplier.Su_Address)),
new SqlParameter("@Su_fax", XYEEncoding.strCodeHex(supplier.Su_fax)),
new SqlParameter("@Su_Email", XYEEncoding.strCodeHex(supplier.Su_Email)),
new SqlParameter("@Su_Bankaccounts", XYEEncoding.strCodeHex(supplier.Su_Bankaccounts)),
new SqlParameter("@Su_Bank", XYEEncoding.strCodeHex(supplier.Su_Bank)),
new SqlParameter("@Su_Profession", XYEEncoding.strCodeHex(supplier.Su_Profession)),
new SqlParameter("@Su_ProCode", XYEEncoding.strCodeHex(supplier.Su_ProCode)),
new SqlParameter("@Su_Credit", XYEEncoding.strCodeHex(supplier.Su_Credit)),
new SqlParameter("@Su_Money", XYEEncoding.strCodeHex(supplier.Su_Money)),
new SqlParameter("@Su_Surplus", XYEEncoding.strCodeHex(supplier.Su_Surplus)),
new SqlParameter("@Su_Reckoning", XYEEncoding.strCodeHex(supplier.Su_Reckoning)),
new SqlParameter("@Su_Empname", XYEEncoding.strCodeHex(supplier.Su_Empname)),
new SqlParameter("@Su_EmpPhone", XYEEncoding.strCodeHex(supplier.Su_EmpPhone)),
new SqlParameter("@Su_Remark", XYEEncoding.strCodeHex(supplier.Su_Remark)),
new SqlParameter("@Su_Enable", supplier.Su_Enable),
new SqlParameter("@Su_Clear", supplier.Su_Clear),
new SqlParameter("@Su_Code", XYEEncoding.strCodeHex(supplier.Su_Code)),
new SqlParameter("@Su_Area", XYEEncoding.strCodeHex(supplier.Su_Area))
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
/// <summary>
/// 绑定控件
/// </summary>
public void bankj()
{
string ID = AppDomain.CurrentDomain.GetData("s").ToString();
BuyPaymentManager buy = new BuyPaymentManager();
Model.BuyPayment bu = buy.GetModel(XYEEncoding.strCodeHex(ID));
this.textBoxOddNumbers.Text = XYEEncoding.strHexDecode(bu.Buy_Code);
this.dateTimePicker1.Value = Convert.ToDateTime(bu.Buy_Date);
this.labtextboxTop1.Text = XYEEncoding.strHexDecode(bu.Buy_SuName);
this.labtextboxTop2.Text = XYEEncoding.strHexDecode(bu.Buy_AmountPay);
this.labtextboxTop6.Text = XYEEncoding.strHexDecode(bu.Buy_AccountName);
this.labtextboxTop7.Text = XYEEncoding.strHexDecode(bu.Buy_AccountPaid);
this.labtextboxTop8.Text = XYEEncoding.strHexDecode(bu.Buy_Actmoney);
this.labtextboxBotton1.Text = XYEEncoding.strHexDecode(bu.Buy_SalesMan);
this.labtextboxBotton4.Text = XYEEncoding.strHexDecode(bu.Buy_AuditMan);
}
/// <summary>
/// 新增申请付款单
/// </summary>
/// <param name="buypay"></param>
/// <returns></returns>
public int InsBuyPayment(BuyPayment buypay)
{
string sql = @"INSERT INTO T_BuyPayment
(Buy_Code
,Buy_BCode
,Buy_Date
,Buy_SuName
,Buy_AccountName
,Buy_AmountPay
,Buy_moneyOwed
,Buy_AccountPaid
,Buy_SalesMan
,Buy_Remark
,Buy_States
,Buy_Class)
Values
(@Buy_Code
,@Buy_BCode
,@Buy_Date
,@Buy_SuName
,@Buy_AccountName
,@Buy_AmountPay
,@Buy_moneyOwed
,@Buy_AccountPaid
,@Buy_SalesMan
,@Buy_Remark
,@Buy_States
,@Buy_Class)";
SqlParameter[] sps =
{
new SqlParameter("@Buy_Code", XYEEncoding.strCodeHex(buypay.Buy_Code)),
new SqlParameter("@Buy_BCode", XYEEncoding.strCodeHex(buypay.Buy_BCode)),
new SqlParameter("@Buy_Date", (buypay.Buy_Date)),
new SqlParameter("@Buy_SuName", XYEEncoding.strCodeHex(buypay.Buy_SuName)),
new SqlParameter("@Buy_AccountName", XYEEncoding.strCodeHex(buypay.Buy_AccountName)),
new SqlParameter("@Buy_AmountPay", XYEEncoding.strCodeHex(buypay.Buy_AmountPay)),
new SqlParameter("@Buy_moneyOwed", XYEEncoding.strCodeHex(buypay.Buy_moneyOwed)),
new SqlParameter("@Buy_AccountPaid", XYEEncoding.strCodeHex(buypay.Buy_AccountPaid)),
new SqlParameter("@Buy_SalesMan", XYEEncoding.strCodeHex(buypay.Buy_SalesMan)),
new SqlParameter("@Buy_Remark", buypay.Buy_Remark),
new SqlParameter("@Buy_States", buypay.Buy_States),
new SqlParameter("@Buy_Class", buypay.Buy_Class)
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
//根据条件模糊查询
private void toolStripButton6_Click(object sender, EventArgs e)
{
try
{
string SQLWhere = "";
string treeName = treeView1.SelectedNode.Text;
string treeTag = treeView1.SelectedNode.Tag.ToString();
string searchType = toolStripComboBox1.Text.Trim();
string searchKey = XYEEncoding.strCodeHex(toolStripTextBox3.Text.Trim());
if (treeView1.SelectedNode == null) //如果TreeView选中项为空
{
return;
}
if (string.IsNullOrWhiteSpace(toolStripTextBox3.Text.Trim())) //如果搜索关键字为空
{
return;
}
SQLWhere += string.Format(" tm.Ma_TypeID = '{0}'", XYEEncoding.strCodeHex(treeTag));
//模糊货品信息
switch (searchType) //搜索框内容加密后
{
case "货品编号":
SQLWhere += string.Format(" and td.Sto_MaCode like '%{0}%'", searchKey);
break;
case "货品名称":
SQLWhere += string.Format(" and td.Sto_MaName like '%{0}%'", searchKey);
break;
case "货品规格":
SQLWhere += string.Format(" and td.Sto_MaModel like '%{0}%'", searchKey);
break;
default:
MessageBox.Show("类型选择错误，请重新选择！");
break;
}
superGridControl1.PrimaryGrid.DataSource = stock.GetList(SQLWhere);
}
catch (Exception)
{
throw;
}
}
//保存并退出按钮
private void buttonX3_Click(object sender, EventArgs e)
{
Model.Department dep = new Model.Department();
try
{
if (_update == false)
{
dep.Dt_Name = XYEEncoding.strCodeHex(this.textBoxXName.Text.Trim());
dep.Dt_RoleCode = comboBoxEx1.SelectedValue == null ? "" : XYEEncoding.strCodeHex(comboBoxEx1.SelectedValue.ToString());
dep.Dt_Code = XYEEncoding.strCodeHex(BuildCode.ModuleCode("DT"));
dep.Dt_Clear = 1;
int result = depm.InsDepartment(dep);
if (result == 1)
{
MessageBox.Show("部门添加成功！");
this.Close();
this.Dispose();
}
else
{
MessageBox.Show("部门保存失败！");
}
}
else
{
dep.Dt_Name = this.textBoxXName.Text.Trim();
dep.Dt_RoleCode = comboBoxEx1.SelectedValue == null ? "" : comboBoxEx1.SelectedValue.ToString();
dep.Dt_Code = _Department.Dt_Code;
int r = depm.UpdateDepartment(dep);
if (r == 1)
{
MessageBox.Show("修改部门成功！");
this.Close();
this.Dispose();
}
else
{
MessageBox.Show("修改部门失败!");
}
}
}
catch (Exception ex)
{
MessageBox.Show("错误，添加或者修改错误" + ex.Message);
}
}
/// <summary>
/// 根据编号修改信息
/// </summary>
/// <param name="empolyee"></param>
/// <returns></returns>
public int UpdateDepartment(Department dep)
{
string sql = @"update T_Department set
Dt_RoleCode=@Dt_RoleCode
,Dt_Name=@Dt_Name
where Dt_Code=@Dt_Code";
SqlParameter[] sps =
{
new SqlParameter("@Dt_RoleCode", XYEEncoding.strCodeHex(dep.Dt_RoleCode)),
new SqlParameter("@Dt_Name", XYEEncoding.strCodeHex(dep.Dt_Name)),
new SqlParameter("@Dt_Code", XYEEncoding.strCodeHex(dep.Dt_Code)),
};
return(DbHelperSQL.ExecuteSql(sql, sps));
#endregion
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="city">模型载体</param>
/// <returns>受影响行数</returns>
public int InsCity(City city)
{
string sql = @"INSERT INTO T_City VALUES
(@City_Code
,@City_Name
,@City_ParentId
,@City_Enable
,@City_Clear)";
SqlParameter[] sps =
{
new SqlParameter("@City_Code", XYEEncoding.strCodeHex(city.City_Code)),
new SqlParameter("@City_Name", XYEEncoding.strCodeHex(city.City_Name)),
new SqlParameter("@City_ParentId", XYEEncoding.strCodeHex(city.City_ParentId)),
new SqlParameter("@City_Enable", city.City_Enable),
new SqlParameter("@City_Clear", city.City_Clear)
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}