/// <summary> /// 查询所有信息 /// </summary> /// <returns>所有数据以DataTable的形式返回</returns> public DataTable SelSupplierTable() { string sql = @"select Su_Code as 编码, Su_Name as 单位名称, Su_Address as 通讯地址, Su_EmpName as 联系人, Su_EmpPhone as 联系手机, Su_fax as 传真, Su_Email as 邮箱, Su_Credit as 信用等级, Su_Money as 账款额度, Su_Surplus as 剩余额度, Su_Reckoning as 月结日, Su_Area as 城市, Su_Remark as 备注, (case when Su_Enable=1 then '2A50591F3727' else '3635591F3727' end) as 是否禁用 from T_Supplier where Su_Clear=1 and Su_Enable=1"; SqlDataAdapter adapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); adapter.Fill(ds, "T_Supplier"); return(ch.DataTableReCoding(ds.Tables[0])); }
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"); }
/// <summary> /// 查询所有信息 /// </summary> /// <param name="isDisplayEnable">参数:默认为true 显示所有,false显示未禁用</param> /// <returns>所有数据以DataTable的形式返回</returns> public DataTable SelBankAccount(bool isDisplayEnable) { string sql = @"select Ba_ID as ID, Ba_Code as 编码, Ba_OpenBank as 开户行, Ba_Account as 银行账号, Ba_CardHolder as 持卡人, Ba_Remark as 备注, Ba_AvailablePrice as 可用金额, (case when Ba_Enable = 1 then '2A50591F3727' else '3635591F3727' end) as 是否禁用 from T_BankAccount where Ba_Clear=1"; if (isDisplayEnable == false) { sql += " and Ba_Enable=1"; } SqlDataAdapter adapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); adapter.Fill(ds, "T_BankAccount"); return(ch.DataTableReCoding(ds.Tables[0])); }
/// <summary> /// 查询 /// </summary> /// <returns></returns> public DataTable SelDepartment() { string sql = "select * from T_Department where Dt_Clear=1"; SqlDataAdapter adapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); adapter.Fill(ds, "T_Department"); return(ch.DataTableReCoding(ds.Tables[0])); }
/// <summary> /// 查询最近售价 /// </summary> /// <returns></returns> public DataTable SelPriceByMaName(string Ma_Name) { string sql = string.Format("select top 5 '330A59182E3F583F' as 价格类型,Sell_DiscountAPrice as 价格,Sell_Discount as 折扣率 from T_SellDetail where Sell_MaName='{0}' order by Sell_Lineno desc", XYEEncoding.strCodeHex(Ma_Name)); SqlDataAdapter adapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); adapter.Fill(ds, "T_SellDetail"); return(ch.DataTableReCoding(ds.Tables[0])); }
public DataTable SelBuyDataTable() { string sql = "select * from T_Buy where Buy_Clear=1"; SqlDataAdapter dapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); dapter.Fill(ds, "T_Buy"); return(ch.DataTableReCoding(ds.Tables[0])); }
/// <summary> /// 获得资金收款单数据列表 /// </summary> public DataTable GetList() { string strsql = (@" select Sell_ID , (case when Sell_IsPay=0 then '2A502E315B0A' when Sell_IsPay=1 then '565B53322E315B0A' when Sell_IsPay=2 then '36352E315B0A' end ) as Sell_IsPay , Sell_Code, (case when Sell_Review=1 then '36352D175E2F' else '2A502D175E2F' end ) as Sell_Review , Sell_Date , Sell_fukuanfangshi , Sell_OddMoney, Sell_InMoney, Sell_LastMoney, Sell_Operation , Sell_Auditman , Sell_Remark , Sell_ClientName , Sell_Salesman from T_Sell where Sell_Review=1 and (Sell_IsPay=0 or Sell_IsPay=1) "); SqlDataAdapter adapter = new SqlDataAdapter(strsql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); adapter.Fill(ds, "T_Sell"); return(ch.DataTableReCoding(ds.Tables[0])); }
public DataTable SelBuyDataTableToCheck() { string sql = @"select buy.Buy_ID as ID, Buy_Code as 编号, Buy_Date as 单据日期, (case when Buy_PurchaseStatus=1 then '36352D175E2F' else '2A502D175E2F' end ) as 单据状态, Buy_SupplierName as 供应商, su.Su_Bank as 结算账户, --结算账户,本次付款,总金额 tbd.Buy_AmountMoney as 总金额, Buy_SalesMan as 业务员, buy.Buy_Remark as 备注 from T_Buy buy left join T_BuyDetail tbd on buy.Buy_Code=tbd.Buy_ID left join T_Supplier su on buy.Buy_SupplierCode=su.Su_Code"; SqlDataAdapter dapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); dapter.Fill(ds, "T_Buy"); return(ch.DataTableReCoding(ds.Tables[0])); }
/// <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> /// 选择下拉框查询内容 /// </summary> /// <returns></returns> public DataTable SelClientToTable() { string sql = @"select Cli_ID as 编号,Cli_Name as 客户名 ,Cli_Code from T_Client"; SqlDataAdapter adapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); adapter.Fill(ds, "T_Client"); return(ch.DataTableReCoding(ds.Tables[0])); }
/// <summary> /// 查询 /// </summary> /// <returns></returns> public DataTable SelOrderType() { string sql = "select * from T_OrderType"; SqlDataAdapter adapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); adapter.Fill(ds, "T_OrderType"); return(ch.DataTableReCoding(ds.Tables[0])); }
/// <summary> /// 获得数据列表 /// </summary> public DataTable GetListToTable(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select MT_ID,MT_Code,MT_Name,MT_ParentID,MT_Enable,MT_Clear"); strSql.Append(" FROM T_MaterialType where MT_Enable = 1 and MT_Clear = 1"); if (strWhere.Trim() != "") { strSql.Append(" and " + strWhere); } SqlDataAdapter adapter = new SqlDataAdapter(strSql.ToString(), DbHelperSQL.connectionString); DataSet ds1 = new DataSet(); adapter.Fill(ds1, "T_MaterialType"); return(ch.DataTableReCoding(ds1.Tables[0])); }
/// <summary> /// 点击图片显示DataGirdView数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected virtual void ClickPicBox(object sender, EventArgs e) { PictureBox pb = sender as PictureBox; pbName = pb.Name; try { switch (pb.Name) { case "pictureBox1": resizablePanel1.Location = new Point(180, 110); dataGridViewFujia.DataSource = sm.SelSupplierTable2(); dataGridViewFujia.Columns[2].Visible = false; break; case "pictureBox4": resizablePanel1.Location = new Point(180, 140); dataGridViewFujia.DataSource = bam.SelBankAccount2(); break; case "pictureBox5": resizablePanel1.Location = new Point(190, 260); DataTable dt = ch.DataTableReCoding(em.SelEmp2("").Tables[0]); dataGridViewFujia.DataSource = dt; break; } } catch (Exception ex) { MessageBox.Show("错误代码:3209-采购付款单选择框异常,异常信息:" + ex.Message); } if (!_btnAdd) { resizablePanel1.Visible = true; _btnAdd = true; } else { resizablePanel1.Size = new System.Drawing.Size(248, 144); resizablePanel1.Visible = true; resizablePanel1.Focus(); } }
public DataTable SelBuyCancelDetailByCode() { string sql = string.Format(@"select * from T_BuyDetail select bd.Buy_Lineno as 编码, bd.Buy_MaName as 货品名称, bd.Buy_Model as 规格型号, bd.Buy_Unit as 单位, bd.Buy_CurNumber as 数量, bd.Buy_DiscountAPrice as 单价, bd.Buy_Discount as 折扣率, bd.Buy_DiscountBPrice as 折后单价, (bd.Buy_CurNumber * bd.Buy_DiscountBPrice) as 总金额 from T_BuyDetail bd left join T_Buy buy on buy.Buy_Code = bd.Buy_ID"); SqlDataAdapter dapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); dapter.Fill(ds, "T_BuyDetail"); return(ch.DataTableReCoding(ds.Tables[0])); }
/// <summary> /// 将DataSet里的第一个table解密后绑定到控件上 /// </summary> /// <param name="ds"></param> private void bindingDGVByDataTable(DataSet ds) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { CodingHelper codingHelper = new CodingHelper(); superGridControl1.PrimaryGrid.DataSource = codingHelper.DataTableReCoding(ds.Tables[0]); } else { DataTable dt = ds.Tables[0].Clone(); CodingHelper codingHelper = new CodingHelper(); superGridControl1.PrimaryGrid.DataSource = codingHelper.DataTableReCoding(dt); } } }
/// <summary> /// 查询所有信息 /// </summary> /// <param name="isflag">是否显示禁用:true显示所有禁用状态的信息,false仅显示未禁用状态的信息</param> /// <returns></returns> public DataTable SelEmpolyee(bool isflag) { CodingHelper ch = new CodingHelper(); string sql = @"select Emp_Code as 员工工号, Emp_Name as 姓名, r.Role_Name as 角色, Emp_Area as 地址, Emp_CardCode as 卡号, dep.Dt_Name as 所属部门, Emp_Sex as 性别, Emp_Card as 身份证号, Emp_Phone as 联系电话, Emp_Bank as 银行卡号, Emp_OpenBank as 开户行, Emp_Birthday 出生年月, Emp_Email as 邮箱, Emp_Education as 最高学历, Emp_School as 毕业院校, Emp_Entry as 入职时间, Emp_State as 就职状态, Emp_Enable as 禁用状态 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"; if (isflag == false) { sql += " and Emp_Enable=1"; } SqlDataAdapter adapter = new SqlDataAdapter(sql, DbHelperSQL.connectionString); DataSet ds = new DataSet(); adapter.Fill(ds, "T_Empolyee"); return(ch.DataTableReCoding(ds.Tables[0])); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="strWhere">where条件</param> /// <returns></returns> public DataTable GetList(string strWhere) { CodingHelper ch = new CodingHelper(); return(ch.DataTableReCoding(sds.GetList(strWhere).Tables[0])); }
/// <summary> /// 获得数据列表 /// </summary> /// <param name="strWhere">查询的where条件</param> /// <returns>数据列表</returns> public DataTable GetList(string strWhere) { return(ch.DataTableReCoding(dal.GetList(strWhere).Tables[0])); }
/// <summary> /// 查询采购流程表 /// </summary> /// <returns></returns> public DataTable SelBuyDataTable(string code) { return(ch.DataTableReCoding((dal.SelBuyDataTable(code)))); }
/// <summary> /// 查询所有信息 /// </summary> /// <returns>所有数据以DataTable的形式返回</returns> public DataTable SelStockTable() { CodingHelper ch = new CodingHelper(); return(ch.DataTableReCoding(dal.SelStockTable())); }