www.pudn.com > EMS.rar > BaseInfo.cs
using System;
using System.Collections.Generic;
using System.Text;
//引用类库
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Runtime.InteropServices;
namespace EMS.BaseClass
{
class BaseInfo
{
//[DllImport("shell32")]
//public static extern long ShellExecute()
////(ByVal hWnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
//public static extern long
//[DllImport("NETAPI32")]
//public static extern long NetMessageBufferSend(string Server, byte[] yToName, byte[] yFromName, byte[] yMsg, int lSize);
DataBase data = new DataBase();
#region 添加--往来单位信息
///
/// 添加往来单位
///
///
/// 返回往来单位id
public int AddUnits(cUnitsInfo units)
{
SqlParameter[] prams = {
data.MakeInParam("@unitcode", SqlDbType.VarChar, 5, units.UnitCode),
data.MakeInParam("@fullname", SqlDbType.VarChar, 30, units.FullName),
data.MakeInParam("@tax", SqlDbType.VarChar, 30, units.Tax),
data.MakeInParam("@tel", SqlDbType.VarChar, 20, units.Tel),
data.MakeInParam("@linkman", SqlDbType.VarChar, 10, units.LinkMan),
data.MakeInParam("@address", SqlDbType.VarChar, 60, units.Address),
data.MakeInParam("@accounts", SqlDbType.VarChar, 80, units.Accounts),
};
return (data.RunProc("INSERT INTO tb_units (unitcode, fullname, tax, tel, linkman, address, accounts) VALUES (@unitcode,@fullname,@tax,@tel,@linkman,@address,@accounts)", prams));
}
#endregion
#region 修改--往来单位信息
///
/// 修改往来单位信息
///
///
///
/// 删除往来单位
///
///
/// 返回往来单位id
public int DeleteUnits(cUnitsInfo units)
{
SqlParameter[] prams = {
data.MakeInParam("@unitcode", SqlDbType.VarChar, 5, units.UnitCode),
};
return (data.RunProc("delete from tb_units where unitcode=@unitcode", prams));
}
#endregion
#region 查询--往来单位信息
///
/// 根据--单位编号--得到往来单位信息
///
///
///
///
/// 根据--单位名称--得到往来单位信息
///
///
///
///
/// 得到所有--往来单位信息
///
///
///
/// 添加库存商品基本信息
///
/// 库存商品数据结构类对象
///
/// 修改库存商品信息
///
/// 库存商品数据结构类对象
///
/// 删除库存商品信息
///
/// 库存商品数据结构类对象
///
/// 根据--商品产地--得到库存商品信息
///
/// 库存商品数据结构类对象
/// 映射原表名称
///
/// 根据--商品名称--得到库存商品信息
///
///
///
///
/// 得到所有--库存商品信息
///
///
///
/// 添加--公司职员--信息
///
///
///
/// 修改--公司职员--信息
///
///
///
/// 删除--公司职员--信息
///
///
///
/// 根据--职员所在部门--得到公司职员信息
///
///
///
///
/// 根据--职员姓名--得到公司职员信息
///
///
///
///
/// 得到所有--公司职员信息
///
///
///
/// 得到所有tbName表中信息－－主要用来：得到最大的单据编号然后自动编号
///
/// 数据表名称
///
/// 处理进货单和销售退货单-数据---向主表中添加数据
///
/// 过账单据数据结构类对象
/// 数据库中数据表名称
///
/// 处理进货退货单和销售单-数据---向主表中添加数据
///
/// 过账单据数据结构类对象
/// 数据库中数据表名称
///
/// 向明细表中添加数据－进货单－销售退货单－销售单－进货退货单
///
/// 过账单据数据结构类对象
/// 数据库中数据表名称
///
/// 修改库存数量和加权平均价格
///
/// 库存商品数据结构类对象
///
/// 修改销售商品和进货退货商品--后的库存商品数量
///
///
///
/// 修改库存数量和销售（和进货退货）最后一次价格
///
/// 库存商品数据结构类对象
///
/// 根据商品编号TradeCode,主要得到数量和加权平均价格，用于对其更新。
///
/// 库存商品数据结构类对象
/// 映射虚拟表名称
///
/// 添加数据---往来账本明细表
///
///
///
/// 商品进货分析--不含进货退货
///
///
///
/// 商品进货分析（含退货）
///
///
///
/// 进货商品－－详细统计
///
///
///
///
///
///
/// 进货商品－－统计所有
///
///
///
///
///
///
/// 销售商品－－详细统计
///
///
///
///
///
///
/// 销售商品－－统计所有
///
///
///
///
///
///
/// 统计商品销售状况
///
///
///
/// 明细账本－－－‘商品销售’和‘商品销售退货’
///
///
///
///
///
///
/// 设置排行榜条件－－往来单位-下拉列表
///
///
///
/// 设置排行榜条件－－经手人-下拉列表
///
///
///
/// 按销售金额排行
///
///
///
///
///
///
/// 按销售数量排行
///
///
///
///
///
///
/// 根据单据编号--得到销售明细表中数据
///
///
///
///
/// 根据单据编号--得到销售明细表中数据
///
///
///
///
/// 根据日期－－查询销售主表中数据
///
///
///
///
/// 检索库存商品--并按数量排序
///
///
///
/// 根据商品编号，获得库存商品中所有信息
///
///
///
///
/// 库存商品上下限设置
///
///
///
/// 库存商品下限报警
///
///
/// 库存商品上限报警
///
///
/// 本单位信息设置
///
///
///
/// 得到本单位信息设置
///
///
///
/// 备份数据库
///
///
public void BackUp(string bakUpName)
{
data.RunProc("BACKUP DATABASE db_CMS TO DISK ='"+bakUpName+"'");
}
///
/// 恢复数据库
///
///
public void ReStore(string reStoreName)
{
data.RunProc("use master RESTORE DATABASE db_CMS from disk='"+reStoreName+"'");
}
#endregion
#region 系统数据清理--系统设置
///
/// 根据指定的数据表清除数据表中数据
///
///
public void ClearTable(string tbName_true)
{
data.RunProc("delete from " + tbName_true + "");
}
#endregion
#region 系统操作员及权限设置--系统设置
///
/// 添加系统操作员
///
///
///
public void AddSysUser(string userName,string pwd)
{
data.RunProc("INSERT INTO tb_power (sysuser, password) VALUES ('" + userName + "', '" + pwd + "')");
}
///
/// 删除系统操作员
///
///
public void DeleteSysUser(int ID)
{
data.RunProc("delete from tb_power where id='"+ID+"'");
}
///
/// 获得所有系统用户信息
///
///
/// 根据用户名称---查询系统用户
///
///
///
/// 修改系统用户信息及所对应的权限
///
///
public void UpdateSysUser(cPopedom popedom)
{
SqlParameter[] prams = {
data.MakeInParam("@id", SqlDbType.Int, 4, popedom.ID),
data.MakeInParam("@sysuser", SqlDbType.VarChar, 20, popedom.SysUser),
data.MakeInParam("@password", SqlDbType.VarChar, 20,popedom.Password),
data.MakeInParam("@stock", SqlDbType.Bit, 1, popedom.Stock),
data.MakeInParam("@vendition", SqlDbType.Bit, 1, popedom.Vendition),
data.MakeInParam("@storage", SqlDbType.Bit, 1, popedom.Storage),
data.MakeInParam("@system", SqlDbType.Bit, 1, popedom.SystemSet),
data.MakeInParam("@base", SqlDbType.Bit, 1, popedom.Base_Info),
};
int i = data.RunProc("update tb_power set sysuser=@sysuser,password=@password,stock=@stock,vendition=@vendition,storage=@storage,system=@system,base=@base where id=@id", prams);
}
#endregion
#region 往来单位对账
///
/// 往来单位列表--并统计应收额-增加及减少
///
///
///查询在指定的日期段中--是否存在－－查询结果
///
///
///
///
///
/// 往来对账－－根据单据编号--查询明细表中数据
///
///
///
///
/// 往来对账－－根据单据编号--查询主表中数据
///
///
///
///
/// 系统登录
///
///
///
/// 单位编号
///
public string UnitCode
{
get { return unitcode; }
set { unitcode = value; }
}
///
/// 单位全称
///
public string FullName
{
get { return fullname; }
set { fullname = value; }
}
///
/// 单位税号
///
public string Tax
{
get { return tax; }
set { tax = value; }
}
///
/// 联系人
///
public string LinkMan
{
get { return linkman; }
set { linkman = value; }
}
///
/// 联系电话
///
public string Tel
{
get { return tel; }
set { tel = value; }
}
///
/// 单位地址
///
public string Address
{
get { return address; }
set { address = value; }
}
///
/// 开户行及账号
///
public string Accounts
{
get { return accounts; }
set { accounts = value; }
}
///
/// 累计应收款
///
public float Gathering
{
get { return gathering; }
set { gathering = value; }
}
///
/// 累计应付款
///
public float Payment
{
get { return payment; }
set { payment = value; }
}
}
#endregion
#region 定义库存商品--数据结构
public class cStockInfo
{
private string tradecode = "";
private string fullname = "";
private string tradetpye = "";
private string standard = "";
private string tradeunit = "";
private string produce = "";
private float qty = 0;
private float price = 0;
private float averageprice = 0;
private float saleprice = 0;
private float check = 0;
private float upperlimit = 0;
private float lowerlimit = 0;
///
/// 商品编号
///
public string TradeCode
{
get { return tradecode; }
set { tradecode = value; }
}
///
/// 单位全称
///
public string FullName
{
get { return fullname; }
set { fullname = value; }
}
///
/// 商品型号
///
public string TradeType
{
get { return tradetpye; }
set { tradetpye = value; }
}
///
/// 商品规格
///
public string Standard
{
get { return standard; }
set { standard = value; }
}
///
/// 商品单位
///
public string Unit
{
get { return tradeunit; }
set { tradeunit = value; }
}
///
/// 商品产地
///
public string Produce
{
get { return produce; }
set { produce = value; }
}
///
/// 库存数量
///
public float Qty
{
get { return qty; }
set { qty = value; }
}
///
/// 进货时最后一次价格
///
public float Price
{
get { return price; }
set { price = value; }
}
///
/// 加权平均价格
///
public float AveragePrice
{
get { return averageprice; }
set { averageprice = value; }
}
///
/// 销售时的最后一次销价
///
public float SalePrice
{
get { return saleprice; }
set { saleprice = value; }
}
///
/// 盘点数量
///
public float Check
{
get { return check; }
set { check = value; }
}
///
/// 库存报警上限
///
public float UpperLimit
{
get { return upperlimit; }
set { upperlimit = value; }
}
///
/// 库存报警下限
///
public float LowerLimit
{
get { return lowerlimit; }
set { lowerlimit = value; }
}
}
#endregion
#region 定义公司职员--数据结构
public class cEmployeeInfo
{
private string employeecode = "";
private string fullname = "";
private string sex = "";
private string dept = "";
private string tel = "";
private string memo = "";
///
/// 职员编号
///
public string EmployeeCode
{
get { return employeecode; }
set { employeecode = value; }
}
///
/// 职员姓名
///
public string FullName
{
get { return fullname; }
set { fullname = value; }
}
///
/// 职员性别
///
public string Sex
{
get { return sex; }
set { sex = value; }
}
///
/// 所在部门
///
public string Dept
{
get { return dept; }
set { dept = value; }
}
///
/// 职员电话
///
public string Tel
{
get { return tel; }
set { tel = value; }
}
///
/// 备注信息
///
public string Memo
{
get { return memo; }
set { memo = value; }
}
}
#endregion
#region 定义过账单据--数据结构
public class cBillInfo
{
//主表结构
private DateTime billdate=DateTime.Now;
private string billcode = "";
private string units = "";
private string handle = "";
private string summary = "";
private float fullpayment = 0;
private float payment = 0;
//明细表结构
private string tradecode = "";
private string fullname = "";
private string tradeunit = "";
private float qty = 0;
private float price = 0;
private float tsum = 0;
///
/// 录单日期
///
public DateTime BillDate
{
get { return billdate; }
set { billdate = value; }
}
///
/// 单据编号
///
public string BillCode
{
get { return billcode; }
set { billcode = value; }
}
///
/// 供货单位
///
public string Units
{
get { return units; }
set { units = value; }
}
///
/// 经手人
///
public string Handle
{
get { return handle; }
set { handle = value; }
}
///
/// 摘要
///
public string Summary
{
get { return summary; }
set { summary = value; }
}
///
/// 应付金额
///
public float FullPayment
{
get { return fullpayment; }
set { fullpayment = value; }
}
///
/// 实付金额
///
public float Payment
{
get { return payment; }
set { payment = value; }
}
//***************明细表结构******************//
///
/// 商品编号
///
public string TradeCode
{
get { return tradecode; }
set { tradecode = value; }
}
///
/// 商品名称
///
public string FullName
{
get { return fullname; }
set { fullname = value; }
}
///
/// 商品单位
///
public string TradeUnit
{
get { return tradeunit; }
set { tradeunit = value; }
}
///
/// 数量
///
public float Qty
{
get { return qty; }
set { qty = value; }
}
///
/// 价格
///
public float Price
{
get { return price; }
set { price = value; }
}
///
/// 金额=数量*价格
///
public float TSum
{
get { return tsum; }
set { tsum = value; }
}
}
#endregion
#region 定义往来账本明细--数据结构
public class cCurrentAccount
{
private DateTime billdate = DateTime.Now;
private string billcode = "";
private float addgathering=0; //应收增加
private float factaddfee = 0; //实际增加
private float reducegathering = 0; //应收减少
private float factreducegathering = 0; //实际减少
private float balance = 0; //应收与增加 差额
private string units = "";
///
/// 录单日期
///
public DateTime BillDate
{
get { return billdate; }
set { billdate = value; }
}///
/// 单据编号
///
public string BillCode
{
get { return billcode; }
set { billcode = value; }
}///
/// 应收增加
///
public float AddGathering
{
get { return addgathering; }
set { addgathering = value; }
}///
/// 实际增加
///
public float FactAddFee
{
get { return factaddfee; }
set { factaddfee = value; }
}///
/// 应收减少
///
public float ReduceGathering
{
get { return reducegathering; }
set { reducegathering = value; }
}///
/// 实际减少
///
public float FactReduceGathering
{
get { return factreducegathering; }
set { factreducegathering = value; }
}///
/// 余额(应收金额-实际金额)
///
public float Balance
{
get { return balance; }
set { balance = value; }
}///
/// 往来单位
///
public string Units
{
get { return units; }
set { units = value; }
}
}
#endregion
#region 定义本单位信息设置--数据结构
public class cUnits
{
private string fullname = "";
private string tax = "";
private string tel = "";
private string linkman = "";
private string address = "";
private string accounts = "";
///
/// 单位全称
///
public string FullName
{
get { return fullname; }
set { fullname = value; }
}
///
/// 税号
///
public string Tax
{
get { return tax; }
set { tax = value; }
}
///
/// 单位电话
///
public string Tel
{
get { return tel; }
set { tel = value; }
}
///
/// 联系人
///
public string Linkman
{
get { return linkman; }
set { linkman = value; }
}
///
/// 联系地址
///
public string Address
{
get { return address; }
set { address = value; }
}
///
/// 开户行及账号
///
public string Accounts
{
get { return accounts; }
set { accounts = value; }
}
}
#endregion
#region 定义往来账明细表－－－数据结构
public class cCurrentaccount
{
private DateTime billdate = DateTime.Now;
private string billcode = "";
private float addgathering = 0;
private float factaddfee = 0;
private float reducegathering = 0;
private float factfee = 0;
private float balance = 0;
private string units = "";
///
/// 录单日期
///
public DateTime BillDate
{
get { return billdate; }
set { billdate = value; }
}
///
/// 单据编号
///
public string BillCode
{
get { return billcode; }
set { billcode = value; }
}
///
/// 应收增加
///
public float AddGathering
{
get { return addgathering; }
set { addgathering = value; }
}
///
/// 实际增加
///
public float FactAddfee
{
get { return factaddfee; }
set { factaddfee = value; }
}
///
/// 应收减少
///
public float ReduceGathering
{
get { return reducegathering; }
set { reducegathering = value; }
}
///
/// 实际减少
///
public float FactFee
{
get { return factfee; }
set { factfee = value; }
}
///
/// 应收余额
///
public float Balance
{
get { return balance; }
set { balance = value; }
}
///
/// 往来单位
///
public string Units
{
get { return units; }
set { units = value; }
}
}
#endregion
#region 定义权限－－数据结构
public class cPopedom
{
private int id = 0;
private string sysuser = "";
private string password = "";
Boolean stock = false;
Boolean vendition = false;
Boolean storage = false;
Boolean system=false;
Boolean base_info=false;
///
/// ID
///
public int ID
{
get { return id; }
set { id = value; }
}
///
/// 用户名称
///
public string SysUser
{
get { return sysuser; }
set { sysuser = value; }
}
///
/// 用户密码
///
public string Password
{
get { return password; }
set { password = value; }
}
///
/// 进货权限
///
public Boolean Stock
{
get { return stock; }
set { stock = value; }
}
///
/// 销售权限
///
public Boolean Vendition
{
get { return vendition; }
set { vendition = value; }
}
///
/// 库存权限
///
public Boolean Storage
{
get { return storage; }
set { storage = value; }
}
///
/// 系统设置权限
///
public Boolean SystemSet
{
get { return system; }
set { system = value; }
}
///
/// 基本信息权限
///
public Boolean Base_Info
{
get { return base_info; }
set { base_info = value; }
}
}
#endregion
}