/// <summary>
/// 更新时查询信息
/// </summary>
/// <returns></returns>
public Supplier SelUpdateSupplierByCode(string Su_Code)
{
string sql = string.Format("select * from T_Supplier where Su_Code='{0}' and Su_Enable=1 and Su_Clear=1", XYEEncoding.strCodeHex(Su_Code));
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Supplier supplier = new Supplier()
{
Su_ID = Convert.ToInt32(read["Su_ID"]),
Su_Name = XYEEncoding.strHexDecode(read["Su_Name"].ToString()),
Su_Phone = XYEEncoding.strHexDecode(read["Su_Phone"].ToString()),
Su_Address = XYEEncoding.strHexDecode(read["Su_Address"].ToString()),
Su_fax = XYEEncoding.strHexDecode(read["Su_fax"].ToString()),
Su_Email = XYEEncoding.strHexDecode(read["Su_email"].ToString()),
Su_Bankaccounts = XYEEncoding.strHexDecode(read["Su_Bankaccounts"].ToString()),
Su_Bank = XYEEncoding.strHexDecode(read["Su_Bank"].ToString()),
Su_ProCode = XYEEncoding.strHexDecode(read["Su_ProCode"].ToString()),
Su_Credit = XYEEncoding.strHexDecode(read["Su_Credit"].ToString()),
Su_Money = read["Su_Money"].ToString(),
Su_Surplus = read["Su_Surplus"].ToString(),
Su_Reckoning = XYEEncoding.strHexDecode(read["Su_Reckoning"].ToString()),
Su_Empname = XYEEncoding.strHexDecode(read["Su_Empname"].ToString()),
Su_EmpPhone = XYEEncoding.strHexDecode(read["Su_EmpPhone"].ToString()),
Su_Remark = XYEEncoding.strHexDecode(read["Su_Remark"].ToString()),
Su_Enable = Convert.ToInt32(read["Su_Enable"].ToString()),
Su_Clear = Convert.ToInt32(read["Su_Clear"].ToString()),
Su_Code = XYEEncoding.strHexDecode(read["Su_Code"].ToString()),
Su_Area = XYEEncoding.strHexDecode(read["Su_Area"].ToString()),
Su_EnableStr = Convert.ToInt32(read["Su_Enable"].ToString()) == 1 ? "未禁用" : "已禁用"
};
return(supplier);
}
return(null);
}
/// <summary>
/// 根据城市编号查询信息
/// </summary>
/// <returns></returns>
public List <Supplier> SelSupplierByCityCode(string Su_CityName)
{
List <Supplier> list = new List <Supplier>();
string sql = string.Format("select * from T_Supplier where Su_Area like '%{0}%' and Su_Enable=1 and Su_Clear=1", XYEEncoding.strCodeHex(Su_CityName));
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Supplier supplier = new Supplier();
supplier.Su_ID = Convert.ToInt32(read["Su_ID"]);
supplier.Su_Name = XYEEncoding.strHexDecode(read["Su_Name"].ToString());
supplier.Su_Phone = XYEEncoding.strHexDecode(read["Su_Phone"].ToString());
supplier.Su_Address = XYEEncoding.strHexDecode(read["Su_Address"].ToString());
supplier.Su_fax = XYEEncoding.strHexDecode(read["Su_fax"].ToString());
supplier.Su_Email = XYEEncoding.strHexDecode(read["Su_email"].ToString());
supplier.Su_Bankaccounts = XYEEncoding.strHexDecode(read["Su_Bankaccounts"].ToString());
supplier.Su_Bank = XYEEncoding.strHexDecode(read["Su_Bank"].ToString());
supplier.Su_ProCode = XYEEncoding.strHexDecode(read["Su_ProCode"].ToString());
supplier.Su_Credit = XYEEncoding.strHexDecode(read["Su_Credit"].ToString());
supplier.Su_Money = read["Su_Money"].ToString();
supplier.Su_Surplus = read["Su_Surplus"].ToString();
supplier.Su_Reckoning = XYEEncoding.strHexDecode(read["Su_Reckoning"].ToString());
supplier.Su_Empname = XYEEncoding.strHexDecode(read["Su_Empname"].ToString());
supplier.Su_EmpPhone = XYEEncoding.strHexDecode(read["Su_EmpPhone"].ToString());
supplier.Su_Remark = XYEEncoding.strHexDecode(read["Su_Remark"].ToString());
supplier.Su_Enable = Convert.ToInt32(read["Su_Enable"].ToString());
supplier.Su_Clear = Convert.ToInt32(read["Su_Clear"].ToString());
supplier.Su_Code = XYEEncoding.strHexDecode(read["Su_Code"].ToString());
supplier.Su_Area = XYEEncoding.strHexDecode(read["Su_Area"].ToString());
supplier.Su_EnableStr = Convert.ToInt32(read["Su_Enable"].ToString()) == 1 ? "未禁用" : "已禁用";
list.Add(supplier);
}
;
return(list);
}
public Buy SelBuyByCodeToModel(string code)
{
string sql = string.Format("select * from T_Buy where Buy_Clear=1 and Buy_Code='{0}'", XYEEncoding.strCodeHex(code));
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Buy b = new Buy();
b.Buy_ID = Convert.ToInt32(read["Buy_ID"]);
b.Buy_Code = XYEEncoding.strHexDecode(read["Buy_Code"].ToString());
b.Buy_Date = Convert.ToDateTime(read["Buy_Date"]);
b.Buy_StockCode = XYEEncoding.strHexDecode(read["Buy_StockCode"].ToString());
b.Buy_StockName = XYEEncoding.strHexDecode(read["Buy_StockName"].ToString());
b.Buy_PurchaseStatus = read["Buy_PurchaseStatus"] == DBNull.Value ? 0 : Convert.ToInt32(read["Buy_PurchaseStatus"]);
b.Buy_AuditStatus = read["Buy_AuditStatus"] == DBNull.Value ? 0 : Convert.ToInt32(read["Buy_AuditStatus"]);
b.Buy_PurchaserID = XYEEncoding.strHexDecode(read["Buy_PurchaserID"].ToString());
b.Buy_SalesMan = XYEEncoding.strHexDecode(read["Buy_SalesMan"].ToString());
b.Buy_Operation = XYEEncoding.strHexDecode(read["Buy_Operation"].ToString());
b.Buy_AuditMan = XYEEncoding.strHexDecode(read["Buy_AuditMan"].ToString());
b.Buy_Remark = XYEEncoding.strHexDecode(read["Buy_Remark"].ToString());
b.Buy_Clear = read["Buy_Clear"] == DBNull.Value ? 0 : Convert.ToInt32(read["Buy_Clear"]);
b.Buy_SupplierCode = XYEEncoding.strHexDecode(read["Buy_SupplierCode"].ToString());
b.Buy_SupplierName = XYEEncoding.strHexDecode(read["Buy_SupplierName"].ToString());
b.Buy_Class = XYEEncoding.strHexDecode(read["Buy_Class"].ToString());
b.Buy_IsPay = read["Buy_IsPay"] == DBNull.Value ? 0 : Convert.ToInt32(read["Buy_IsPay"]);
b.Buy_PayMethod = read["Buy_PayMethod"] == DBNull.Value ? 0 : Convert.ToInt32(read["Buy_PayMethod"]);
b.Buy_IsPutSto = read["Buy_IsPutSto"] == DBNull.Value ? 0 : Convert.ToInt32(read["Buy_IsPutSto"]);
b.Buy_GetDate = read["Buy_GetDate"] == DBNull.Value ? Convert.ToDateTime("1990-01-01") : Convert.ToDateTime(read["Buy_GetDate"]);
b.Buy_Logistics = XYEEncoding.strHexDecode(read["Buy_Logistics"].ToString());
b.Buy_LogPhone = XYEEncoding.strHexDecode(read["Buy_LogPhone"].ToString());
b.Buy_LogCode = XYEEncoding.strHexDecode(read["Buy_LogCode"].ToString());
return(b);
}
return(null);
}
/// <summary>
/// 根据工号查询信息
/// </summary>
/// <param name="Emp_Code">工号</param>
/// <returns></returns>
public Empolyee SelEmpolyeeByCode(string Emp_Code)
{
string sql = string.Format("select * from T_Empolyee where Emp_Code='{0}' and Emp_Clear=1", Emp_Code);
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Empolyee emp = new Empolyee();
emp.Emp_ID = Convert.ToInt32(read["Emp_ID"]);
emp.Emp_Name = XYEEncoding.strHexDecode(read["Emp_Name"].ToString());
emp.Emp_Code = XYEEncoding.strHexDecode(read["Emp_Code"].ToString());
emp.Emp_Card = XYEEncoding.strHexDecode(read["Emp_Card"].ToString());
emp.Emp_Area = XYEEncoding.strHexDecode(read["Emp_Area"].ToString());
emp.Emp_Bank = XYEEncoding.strHexDecode(read["Emp_Bank"].ToString());
emp.Emp_Birthday = Convert.ToDateTime(read["Emp_Birthday"]);
emp.Emp_CardCode = XYEEncoding.strHexDecode(read["Emp_CardCode"].ToString());
emp.Emp_Clear = Convert.ToInt32(read["Emp_Clear"]);
emp.Emp_Depid = XYEEncoding.strHexDecode(read["Emp_Depid"].ToString());
emp.Emp_Education = XYEEncoding.strHexDecode(read["Emp_Education"].ToString());
emp.Emp_Email = XYEEncoding.strHexDecode(read["Emp_Email"].ToString());
emp.Emp_Enable = Convert.ToInt32(read["Emp_Enable"]);
emp.Emp_Entry = Convert.ToDateTime(read["Emp_Entry"]);
emp.Emp_OpenBank = XYEEncoding.strHexDecode(read["Emp_OpenBank"].ToString());
emp.Emp_Password = XYEEncoding.strHexDecode(read["Emp_Password"].ToString());
emp.Emp_Phone = XYEEncoding.strHexDecode(read["Emp_Phone"].ToString());
emp.Emp_School = XYEEncoding.strHexDecode(read["Emp_School"].ToString());
emp.Emp_Sex = XYEEncoding.strHexDecode(read["Emp_Sex"].ToString());
emp.Emp_State = Convert.ToInt32(read["Emp_State"]);
emp.Emp_UserRole = XYEEncoding.strHexDecode(read["Emp_UserRole"].ToString());
emp.Emp_zhiwen = XYEEncoding.strHexDecode(read["Emp_zhiwen"].ToString());
return(emp);
}
return(null);
}
public List <Empolyee> SelEmpList()
{
List <Empolyee> list = new List <Empolyee>();
string sql = @"select Emp_Code,
Emp_Name,
r.Role_Name,
Emp_Area,
Emp_CardCode,
dep.Dt_Name,
Emp_Sex,
Emp_Card,
Emp_Phone,
Emp_Bank,
Emp_OpenBank,
Emp_Birthday,
Emp_Email,
Emp_Education,
Emp_School,
Emp_Entry,
Emp_State,
Emp_Enable
from T_Empolyee emp,
T_Role r,
T_Department dep
where Emp_Clear=1
and emp.Emp_Depid=dep.Dt_Code
and emp.Emp_UserRole=r.Role_Code";
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Empolyee emp = new Empolyee()
{
Emp_CardCode = XYEEncoding.strHexDecode(read["Emp_CardCode"].ToString()),
Emp_Area = XYEEncoding.strHexDecode(read["Emp_Area"].ToString()),
Emp_Code = XYEEncoding.strHexDecode(read["Emp_Code"].ToString()),
Emp_Sex = XYEEncoding.strHexDecode(read["Emp_Sex"].ToString()),
Emp_Card = XYEEncoding.strHexDecode(read["Emp_Card"].ToString()),
Emp_Phone = XYEEncoding.strHexDecode(read["Emp_Phone"].ToString()),
Emp_Bank = XYEEncoding.strHexDecode(read["Emp_Bank"].ToString()),
Emp_OpenBank = XYEEncoding.strHexDecode(read["Emp_OpenBank"].ToString()),
Emp_Birthday = Convert.ToDateTime(read["Emp_Birthday"].ToString()),
Emp_Email = XYEEncoding.strHexDecode(read["Emp_Email"].ToString()),
Emp_Education = XYEEncoding.strHexDecode(read["Emp_Education"].ToString()),
Emp_School = XYEEncoding.strHexDecode(read["Emp_School"].ToString()),
Emp_Entry = Convert.ToDateTime(read["Emp_Entry"].ToString()),
Emp_State = Convert.ToInt32(read["Emp_State"].ToString()),
Emp_Enable = Convert.ToInt32(read["Emp_Enable"].ToString()),
Roles = new RoleService().GetModel(read["Emp_UserRole"] == null ? "" : read["Emp_UserRole"].ToString()),
Departments = new DepartmentService().SelDepartmentByCode(read["Emp_Depid"] == null ? "" : read["Emp_Depid"].ToString())
};
list.Add(emp);
}
return(list);
}
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="ParentID">父级ID：默认为空</param>
/// <param name="pNode">父级节点：默认为null，可选</param>
/// <param name="table">表名：默认为City，可选参数：P</param>
/// <param name="ControlName">控件名：必选</param>
private void AddTree(string ParentID, Node pNode, string table, ComboTree ControlName)
{
if (ParentID == "")
{
ParentID = "D4";
}
string ParentId = "City_ParentId";
string Code = "City_Code";
string Name = "City_Name";
try
{
DataTable dt = cm.SelCityTable();
if (table == "P")
{
ParentId = "ST_ParentId";
Code = "ST_Code";
Name = "ST_Name";
dt = pm.SelProfession();
}
DataView dvTree = new DataView(dt);
//过滤ParentID,得到当前的所有子节点
dvTree.RowFilter = string.Format("{0} = '{1}'", ParentId, ParentID);
foreach (DataRowView Row in dvTree)
{
Node node = new Node();
if (pNode == null)
{
//添加根节点
node.Text = XYEEncoding.strHexDecode(Row[Name].ToString());
node.Tag = XYEEncoding.strHexDecode(Row[Code].ToString());
ControlName.Nodes.Add(node);
AddTree(Row[Code].ToString(), node, table, ControlName);
//展开第一级节点
node.Expand();
}
else
{
//添加当前节点的子节点
node.Text = XYEEncoding.strHexDecode(Row[Name].ToString());
node.Tag = XYEEncoding.strHexDecode(Row[Code].ToString());
pNode.Nodes.Add(node);
AddTree(Row[Code].ToString(), node, table, ControlName); //再次递归
}
}
}
catch (Exception ex)
{
MessageBox.Show("加载数据失败,请检查服务器连接并尝试刷新.错误:" + ex.Message);
}
}
//回调遍历节点
private void AddTree(string ParentID, Node pNode, string table, ComboTree ct)
{
CityManager cm = new CityManager();
ProfessionManager pm = new ProfessionManager();
if (ParentID == "")
{
ParentID = "D4";
}
string ParentId = "City_ParentID";
string Code = "City_Code";
string Name = "City_Name";
DataTable dt = cm.GetList("").Tables[0];
if (table == "P")
{
ParentId = "ST_ParentID";
Code = "ST_Code";
Name = "ST_Name";
dt = pm.GetList("").Tables[0];
}
DataView dvTree = new DataView(dt);
//过滤ParentID,得到当前的所有子节点
dvTree.RowFilter = string.Format("{0} = '{1}'", ParentId, ParentID);
foreach (DataRowView Row in dvTree)
{
Node node = new Node();
if (pNode == null)
{
//添加根节点
node.Text = XYEEncoding.strHexDecode(Row[Name].ToString());
node.Tag = XYEEncoding.strHexDecode(Row[Code].ToString());
ct.Nodes.Add(node);
AddTree(Row[Code].ToString(), node, table, ct);
//展开第一级节点
node.Expand();
}
else
{
//添加当前节点的子节点
node.Text = XYEEncoding.strHexDecode(Row[Name].ToString());
node.Tag = XYEEncoding.strHexDecode(Row[Code].ToString());
pNode.Nodes.Add(node);
AddTree(Row[Code].ToString(), node, table, ct);//再次递归
}
}
}
/// <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="ParentID">条件ID:默认D4</param>
/// <param name="pNode">父级ID：null</param>
/// <param name="dt">查询结果集:DataTable</param>
protected virtual void AddTree(string ParentID, TreeNode pNode, DataTable dts, string tableName)
{
if (ParentID == "")
{
ParentID = "D4";
}
string ParentId = "PIC_ParentId";
string Code = "PIC_Code";
string Name = "PIC_Name";
if (tableName == "C")
{
ParentId = "City_ParentId";
Code = "City_Code";
Name = "City_Name";
}
DataTable dt = dts;
DataView dvTree = new DataView(dt);
//过滤ParentID,得到当前的所有子节点
dvTree.RowFilter = string.Format("{0} = '{1}'", ParentId, ParentID);
foreach (DataRowView Row in dvTree)
{
TreeNode Node = new TreeNode();
if (pNode == null)
{
//添加根节点
Node.Text = XYEEncoding.strHexDecode(Row[Name].ToString());
Node.Tag = XYEEncoding.strHexDecode(Row[Code].ToString());
treeView1.Nodes.Add(Node);
AddTree(Row[Code].ToString(), Node, dts, tableName);
//展开第一级节点
Node.Expand();
}
else
{
//添加当前节点的子节点
Node.Text = XYEEncoding.strHexDecode(Row[Name].ToString());
Node.Tag = XYEEncoding.strHexDecode(Row[Code].ToString());
pNode.Nodes.Add(Node);
AddTree(Row[Code].ToString(), Node, dts, tableName); //再次递归
}
}
}
/// <summary>
/// 查询所有信息
/// </summary>
/// <param name="isDisEC">isDisEC：true仅显示启用,false显示启用和未删除</param>
/// <returns></returns>
public List <Supplier> SelSupplier(bool isDisEC)
{
List <Supplier> list = new List <Supplier>();
string sql = "select * from T_Supplier";
if (isDisEC == true)
{
sql += " where Su_Clear=1";
}
else
{
sql += " where Su_Enable=1 and Su_Clear=1";
}
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Supplier supplier = new Supplier()
{
Su_ID = Convert.ToInt32(read["Su_ID"]),
Su_Name = XYEEncoding.strHexDecode(read["Su_Name"].ToString()),
Su_Phone = XYEEncoding.strHexDecode(read["Su_Phone"].ToString()),
Su_Address = XYEEncoding.strHexDecode(read["Su_Address"].ToString()),
Su_fax = XYEEncoding.strHexDecode(read["Su_fax"].ToString()),
Su_Email = XYEEncoding.strHexDecode(read["Su_email"].ToString()),
Su_Bankaccounts = XYEEncoding.strHexDecode(read["Su_Bankaccounts"].ToString()),
Su_Bank = XYEEncoding.strHexDecode(read["Su_Bank"].ToString()),
Su_Profession = XYEEncoding.strHexDecode(read["Su_Profession"].ToString()),
Su_ProCode = XYEEncoding.strHexDecode(read["Su_ProCode"].ToString()),
Su_Credit = XYEEncoding.strHexDecode(read["Su_Credit"].ToString()),
Su_Money = XYEEncoding.strHexDecode(read["Su_Money"].ToString()),
Su_Surplus = XYEEncoding.strHexDecode(read["Su_Surplus"].ToString()),
Su_Reckoning = XYEEncoding.strHexDecode(read["Su_Reckoning"].ToString()),
Su_Empname = XYEEncoding.strHexDecode(read["Su_Empname"].ToString()),
Su_EmpPhone = XYEEncoding.strHexDecode(read["Su_EmpPhone"].ToString()),
Su_Remark = XYEEncoding.strHexDecode(read["Su_Remark"].ToString()),
Su_Enable = Convert.ToInt32(read["Su_Enable"].ToString()),
Su_Clear = Convert.ToInt32(read["Su_Clear"].ToString()),
Su_Code = XYEEncoding.strHexDecode(read["Su_Code"].ToString()),
Su_Area = XYEEncoding.strHexDecode(read["Su_Area"].ToString()),
Su_EnableStr = Convert.ToInt32(read["Su_Enable"].ToString()) == 1 ? "未禁用" : "已禁用"
};
list.Add(supplier);
}
return(list);
}
/// <summary>
/// 自定义where查询
/// </summary>
/// <returns></returns>
public List <Supplier> SelSupplierByWhere(string SQLWhere)
{
List <Supplier> list = new List <Supplier>();
string sql = string.Format("select * from T_Supplier ");
if (!string.IsNullOrWhiteSpace(SQLWhere))
{
sql = string.Format("{0} where {1} and Su_Enable=1 and Su_Clear=1", sql, SQLWhere);
}
else
{
sql += SQLWhere + " where Su_Enable=1 and Su_Clear=1";
}
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Supplier supplier = new Supplier()
{
Su_ID = Convert.ToInt32(read["Su_ID"]),
Su_Name = XYEEncoding.strHexDecode(read["Su_Name"].ToString()),
Su_Phone = XYEEncoding.strHexDecode(read["Su_Phone"].ToString()),
Su_Address = XYEEncoding.strHexDecode(read["Su_Address"].ToString()),
Su_fax = XYEEncoding.strHexDecode(read["Su_fax"].ToString()),
Su_Email = XYEEncoding.strHexDecode(read["Su_email"].ToString()),
Su_Bankaccounts = XYEEncoding.strHexDecode(read["Su_Bankaccounts"].ToString()),
Su_Bank = XYEEncoding.strHexDecode(read["Su_Bank"].ToString()),
Su_Profession = XYEEncoding.strHexDecode(read["Su_Profession"].ToString()),
Su_ProCode = XYEEncoding.strHexDecode(read["Su_ProCode"].ToString()),
Su_Credit = XYEEncoding.strHexDecode(read["Su_Credit"].ToString()),
Su_Money = XYEEncoding.strHexDecode(read["Su_Money"].ToString()),
Su_Surplus = XYEEncoding.strHexDecode(read["Su_Surplus"].ToString()),
Su_Reckoning = XYEEncoding.strHexDecode(read["Su_Reckoning"].ToString()),
Su_Empname = XYEEncoding.strHexDecode(read["Su_Empname"].ToString()),
Su_EmpPhone = XYEEncoding.strHexDecode(read["Su_EmpPhone"].ToString()),
Su_Remark = XYEEncoding.strHexDecode(read["Su_Remark"].ToString()),
Su_Enable = Convert.ToInt32(read["Su_Enable"].ToString()),
Su_Clear = Convert.ToInt32(read["Su_Clear"].ToString()),
Su_Code = XYEEncoding.strHexDecode(read["Su_Code"].ToString()),
Su_EnableStr = Convert.ToInt32(read["Su_Enable"].ToString()) == 1 ? "未禁用" : "已禁用"
};
list.Add(supplier);
}
return(list);
}
public List <Buy> SelBuyByCode(string code)
{
List <Buy> list = new List <Buy>();
string sql = string.Format("select * from T_Buy where Buy_Clear=1 and Buy_Code={0}", code);
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Buy buy = new Buy()
{
Buy_ID = Convert.ToInt32(read["Buy_ID"]),
Buy_Code = XYEEncoding.strHexDecode(read["Buy_Code"].ToString()),
Buy_Date = Convert.ToDateTime(read["Buy_Date"])
};
list.Add(buy);
}
return(list);
}
/// <summary>
/// 查询所有信息
/// </summary>
/// <returns>List集合</returns>
public List <City> SelCity()
{
List <City> list = new List <City>();
string sql = "select * from T_City where City_Clear=1 and City_Enable=1";
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
City city = new City()
{
City_ID = Convert.ToInt32(read["City_ID"]),
City_Name = XYEEncoding.strHexDecode(read["City_Name"].ToString()),
City_Code = XYEEncoding.strHexDecode(read["City_Code"].ToString()),
City_ParentId = XYEEncoding.strHexDecode(read["City_ParentId"].ToString()),
City_Clear = Convert.ToInt32(read["City_Clear"].ToString()),
City_Enable = Convert.ToInt32(read["City_Enable"].ToString())
};
list.Add(city);
}
return(list);
}
/// <summary>
/// 查询所有信息
/// </summary>
/// <returns>List集合</returns>
public List <ProjectCost> SelProjectCost()
{
List <ProjectCost> list = new List <ProjectCost>();
string sql = "select * from T_ProjectCost where PIC_Clear=1 and PIC_Enable=1";
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
ProjectCost pic = new ProjectCost()
{
PC_ID = Convert.ToInt32(read["PIC_ID"]),
PC_Name = XYEEncoding.strHexDecode(read["PIC_Name"].ToString()),
PC_Code = XYEEncoding.strHexDecode(read["PIC_Code"].ToString()),
PC_ParentId = XYEEncoding.strHexDecode(read["PIC_ParentId"].ToString()),
PC_Clear = Convert.ToInt32(read["PIC_Clear"].ToString()),
PC_Enable = Convert.ToInt32(read["PIC_Enable"].ToString())
};
list.Add(pic);
}
return(list);
}
/// <summary>
/// 根据编号查询信息
/// </summary>
/// <returns>List集合</returns>
public List <Profession> SelProfessionByCode(string ST_Code)
{
List <Profession> list = new List <Profession>();
string sql = string.Format("select * from T_Profession where ST_Code={0} and ST_Enable=1 and ST_Clear=1", XYEEncoding.strCodeHex(ST_Code));
SqlDataReader read = DbHelperSQL.ExecuteReader(sql);
while (read.Read())
{
Profession profession = new Profession()
{
ST_ID = Convert.ToInt32(read["ST_ID"]),
ST_Name = XYEEncoding.strHexDecode(read["ST_Name"].ToString()),
ST_Code = XYEEncoding.strHexDecode(read["ST_Code"].ToString()),
ST_ParentId = XYEEncoding.strHexDecode(read["ST_ParentId"].ToString()),
ST_Enable = Convert.ToInt32(read["ST_Enable"]),
ST_Clear = Convert.ToInt32(read["ST_Clear"]),
};
list.Add(profession);
}
return(list);
}
private void InsBankAccount_Load(object sender, EventArgs e)
{
BankAccountForm bam = (BankAccountForm)Owner;
try
{
switch (bam.StateType)
{
case 0:
textBox1.Text = BuildCode.ModuleCode("BA");
break;
case 1:
BankAccount tba = bm.SelBankAccountByCode(bam.id);
textBox1.Text = XYEEncoding.strHexDecode(tba.Ba_Code);
textBox3.Text = XYEEncoding.strHexDecode(tba.Ba_CardHolder);
textBox2.Text = XYEEncoding.strHexDecode(tba.Ba_Account);
textBox4.Text = XYEEncoding.strHexDecode(tba.Ba_OpenBank);
textBox5.Text = XYEEncoding.strHexDecode(tba.Ba_AvailablePrice);
textBox6.Text = XYEEncoding.strHexDecode(tba.Ba_Remark);
if (tba.Ba_Enable == 1)
{
radioButton2.Checked = true;
}
else
{
radioButton1.Checked = true;
}
break;
default:
MessageBox.Show("类型错误！");
break;
}
}
catch (Exception ex)
{
MessageBox.Show("加载数据失败,请检查服务器连接并尝试刷新.错误:" + ex.Message);
}
}
//递归添加树的节点
private void AddTree(string ParentID, TreeNode pNode, DataTable table)
{
if (ParentID == "")
{
ParentID = "D4";
}
string ParentId = "City_ParentID";
string Code = "City_Code";
string Name = "City_Name";
DataView dvTree = new DataView(table);
//过滤ParentID,得到当前的所有子节点
dvTree.RowFilter = string.Format("{0} = '{1}'", ParentId, ParentID);
foreach (DataRowView Row in dvTree)
{
TreeNode Node = new TreeNode();
if (pNode == null)
{
//添加根节点
Node.Text = XYEEncoding.strHexDecode(Row[Name].ToString());
Node.Tag = XYEEncoding.strHexDecode(Row[Code].ToString());
treeViewClient.Nodes.Add(Node);
AddTree(Row[Code].ToString(), Node, table);
//展开第一级节点
Node.Expand();
}
else
{
//添加当前节点的子节点
Node.Text = XYEEncoding.strHexDecode(Row[Name].ToString());
Node.Tag = XYEEncoding.strHexDecode(Row[Code].ToString());
pNode.Nodes.Add(Node);
AddTree(Row[Code].ToString(), Node, table);//再次递归
}
}
}
private void InsEmpolyee_Load(object sender, EventArgs e)
{
textBox2.Enabled = false;
comboBox1.SelectedIndex = 0;
textBox11.Text = DateTime.Now.ToString();
comboBox1.DataSource = dm.SelDepartment();
comboBox1.DisplayMember = "Dt_Name";
comboBox1.ValueMember = "Dt_Code";
//绑定角色下拉框
DataTable dt = role.GetAllList().Tables[0];
cbe_juese.DataSource = dt;
cbe_juese.DisplayMember = "Role_Name";
cbe_juese.ValueMember = "Role_Code";
cbe_juese.SelectedIndex = 0;
EmpolyeeForm empM = (EmpolyeeForm)Owner;
try
{
switch (empM.StateType)
{
case 0:
textBox2.Text = BuildCode.ModuleCode("EMP");
break;
case 1:
Model.Empolyee empolyee = em.SelEmpolyeeByCode(empM.id);
textBox1.Text = empolyee.Emp_Name;
textBox2.Text = empolyee.Emp_Code;
//获取选中的地址，绑定在地址的三个控件上面
string str = empolyee.Emp_Area;
string[] sArray = str.Split(new char[] { '/' });
tb_sheng.Text = sArray[0].ToString();
tb_shi.Text = sArray[1].ToString();
tb_qu.Text = sArray[2].ToString();
//
tb_pws.Text = empolyee.Emp_Password;
textBox3.Text = empolyee.Emp_CardCode;
textBox4.Text = empolyee.Emp_Phone;
textBox5.Text = empolyee.Emp_Card;
textBox6.Text = empolyee.Emp_Birthday.ToString();
textBox7.Text = empolyee.Emp_Email;
textBox8.Text = empolyee.Emp_School;
textBox9.Text = empolyee.Emp_Bank;
textBox10.Text = empolyee.Emp_OpenBank;
textBox11.Text = empolyee.Emp_Entry.ToString();
comboBox1.Text = XYEEncoding.strHexDecode(dm.SelDepartmentByCode(XYEEncoding.strCodeHex(empolyee.Emp_Depid)).Dt_Name);
//
cbe_juese.Text = XYEEncoding.strHexDecode(role.GetModel(XYEEncoding.strCodeHex(empolyee.Emp_UserRole)).Role_Name);
//
comboBox2.Text = empolyee.Emp_Education;
if (empolyee.Emp_Sex == "男")
{
radioButton1.Checked = true;
}
else
{
radioButton2.Checked = true;
}
if (empolyee.Emp_State == 0)
{
checkBox2.Checked = true;
}
if (empolyee.Emp_Enable == 0)
{
checkBox1.Checked = true;
}
break;
default:
MessageBox.Show("类型错误！");
break;
}
}
catch (Exception ex)
{
MessageBox.Show("加载数据失败,请检查服务器连接并尝试刷新.错误:" + ex.Message);
}
}
