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