📄 baseinfo.cs.bak
字号:
#region 库存管理--库存状况
/// <summary>
/// 检索库存商品--并按数量排序
/// </summary>
/// <param name="tbName"></param>
/// <returns></returns>
public DataSet setStockStatus(string tbName)
{
return (data.RunProcReturn("select * from tb_stock order by qty",tbName));
}
/// <summary>
/// 根据商品编号，获得库存商品中所有信息
/// </summary>
/// <param name="tradeCode"></param>
/// <param name="tbName"></param>
/// <returns></returns>
public DataSet GetStockLimitByTradeCode(string tradeCode,string tbName)
{
return(data.RunProcReturn("select * from tb_Stock where tradecode='"+tradeCode+"'",tbName));
}
/// <summary>
/// 库存商品上下限设置
/// </summary>
/// <param name="stock"></param>
/// <returns></returns>
public int UpdateStockLimit(cStockInfo stock)
{
SqlParameter[] prams = {
data.MakeInParam("@tradecode", SqlDbType.VarChar,5,stock.TradeCode),
data.MakeInParam("@upperlimit", SqlDbType.Float, 8, stock.UpperLimit),
data.MakeInParam("@lowerlimit", SqlDbType.Float, 8, stock.LowerLimit),
};
return (data.RunProc("update tb_stock set upperlimit=@upperlimit,lowerlimit=@lowerlimit where tradecode=@tradecode", prams));
}
#endregion
#region 库存商品上下限报警
/// <summary>
/// 库存商品下限报警
/// </summary>
/// <returns></returns>
public DataSet GetLowerLimit()
{
return (data.RunProcReturn("SELECT tradecode as 商品编号, fullname as 商品名称, qty as 库存数量,upperlimit as 库存上限,lowerlimit as 库存下限 from tb_stock WHERE (qty < lowerlimit) and lowerlimit > 0", "tb_stock"));
}
/// <summary>
/// 库存商品上限报警
/// </summary>
/// <returns></returns>
public DataSet GetUpperLimit()
{
return (data.RunProcReturn("SELECT tradecode as 商品编号, fullname as 商品名称, qty as 库存数量,upperlimit as 库存上限,lowerlimit as 库存下限 FROM tb_stock WHERE (upperlimit < qty) and upperlimit>0","tb_stock"));
}
#endregion
#region 库存盘点
public int CheckStock(cStockInfo stock)
{
SqlParameter[] prams = {
data.MakeInParam("@tradecode", SqlDbType.VarChar, 5, stock.TradeCode),
data.MakeInParam("@check", SqlDbType.Float, 8,stock.Check),
};
return (data.RunProc("update tb_stock set stockcheck=@check where tradecode=@tradecode", prams));
}
#endregion
#region 本单位信息设置--系统设置
/// <summary>
/// 本单位信息设置
/// </summary>
/// <param name="units"></param>
/// <returns></returns>
public int UpdateSysUnits(cUnits units)
{
SqlParameter[] prams = {
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("update tb_unit set fullname=@fullname,tax=@tax,tel=@tel,linkman=@linkman,address=@address,accounts=@accounts", prams));
}
/// <summary>
/// 得到本单位信息设置
/// </summary>
/// <param name="tbName"></param>
/// <returns></returns>
public DataSet GetAllUnit()
{
return (data.RunProcReturn("select * from tb_unit","tb_unit"));
}
#endregion
#region 数据库备份与恢复--系统设置
/// <summary>
/// 备份数据库
/// </summary>
/// <param name="bakUpName"></param>
public void BackUp(string bakUpName)
{
data.RunProc("BACKUP DATABASE db_CMS TO DISK ='"+bakUpName+"'");
}
/// <summary>
/// 恢复数据库
/// </summary>
/// <param name="reStoreName"></param>
public void ReStore(string reStoreName)
{
data.RunProc("use master RESTORE DATABASE db_CMS from disk='"+reStoreName+"'");
}
#endregion
#region 系统数据清理--系统设置
/// <summary>
/// 根据指定的数据表清除数据表中数据
/// </summary>
/// <param name="tbName_true"></param>
public void ClearTable(string tbName_true)
{
data.RunProc("delete from " + tbName_true + "");
}
#endregion
#region 系统操作员及权限设置--系统设置
/// <summary>
/// 添加系统操作员
/// </summary>
/// <param name="userName"></param>
/// <param name="pwd"></param>
public void AddSysUser(string userName,string pwd)
{
data.RunProc("INSERT INTO tb_power (sysuser, password) VALUES ('" + userName + "', '" + pwd + "')");
}
/// <summary>
/// 删除系统操作员
/// </summary>
/// <param name="ID"></param>
public void DeleteSysUser(int ID)
{
data.RunProc("delete from tb_power where id='"+ID+"'");
}
/// <summary>
/// 获得所有系统用户信息
/// </summary>
/// <returns></returns>
public DataSet GetAllUser()
{
return(data.RunProcReturn("select * from tb_power","tb_Power"));
}
/// <summary>
/// 根据用户名称---查询系统用户
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public bool FindUserName(string userName)
{
DataSet ds = null;
ds = data.RunProcReturn("select * from tb_power where sysuser='" + userName + "'", "tb_power");
if (ds.Tables[0].Rows.Count > 0)
{ return true; }
else
{ return false; }
}
/// <summary>
/// 修改系统用户信息及所对应的权限
/// </summary>
/// <param name="popedom"></param>
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 往来单位对账
/// <summary>
/// 往来单位列表--并统计应收额-增加及减少
/// </summary>
/// <returns></returns>
public DataSet GetUnitsList()
{
return (data.RunProcReturn("SELECT units as 往来单位, SUM(addgathering) AS 应收增加, SUM(reducegathering) AS 应收减少 FROM tb_currentaccount GROUP BY units", "tb_currentaccount"));
}
/// <summary>
///查询在指定的日期段中--是否存在－－查询结果
/// </summary>
/// <param name="units"></param>
/// <param name="starDateTime"></param>
/// <param name="endDateTime"></param>
/// <returns></returns>
public DataSet FindCurrentAccountDate(string units, DateTime starDateTime,DateTime endDateTime)
{
return (data.RunProcReturn("SELECT * FROM tb_currentaccount WHERE units='" + units + "' AND billdate BETWEEN '" +starDateTime+"'AND '" +endDateTime+ "'","tb_currentaccount"));
}
/// <summary>
/// 往来对账－－根据单据编号--查询明细表中数据
/// </summary>
/// <param name="billcode"></param>
/// <param name="tb_Detailed_true"></param>
/// <returns></returns>
public DataSet FindDetailde(string tb_Detailed_true, string billcode)
{
return (data.RunProcReturn("select * from "+tb_Detailed_true+" where (billcode='" + billcode + "')ORDER BY tsum","detailed"));
}
/// <summary>
/// 往来对账－－根据单据编号--查询主表中数据
/// </summary>
/// <param name="tb_Main_true"></param>
/// <param name="billcode"></param>
/// <returns></returns>
public DataSet FindMain(string tb_Main_true, string billcode)
{
return (data.RunProcReturn("select * from "+tb_Main_true+" where billcode='" + billcode + "'","main"));
}
#endregion
#region 辅助工具管理
//ShellExecute Me.hWnd, "open", "http://www.mingrisoft.com", 1, 1, 5
public void OpenInernet()
{
}
#endregion
#region 系统登录
/// <summary>
/// 系统登录
/// </summary>
/// <param name="popedom"></param>
/// <returns></returns>
public DataSet Login(cPopedom popedom)
{
SqlParameter[] prams = {
data.MakeInParam("@sysuser", SqlDbType.VarChar, 20, popedom.SysUser),
data.MakeInParam("@password", SqlDbType.VarChar, 20,popedom.Password),
};
return (data.RunProcReturn("SELECT * FROM tb_power WHERE (sysuser = @sysuser) AND (password = @password)",prams, "tb_power"));
}
#endregion
}
#region 定义往来单位--数据结构
public class cUnitsInfo
{
private string unitcode = "";
private string fullname = "";
private string tax = "";
private string tel = "";
private string linkman = "";
private string address = "";
private string accounts = "";
private float gathering = 0;
private float payment = 0;
/// <summary>
/// 单位编号
/// </summary>
public string UnitCode
{
get { return unitcode; }
set { unitcode = value; }
}
/// <summary>
/// 单位全称
/// </summary>
public string FullName
{
get { return fullname; }
set { fullname = value; }
}
/// <summary>
/// 单位税号
/// </summary>
public string Tax
{
get { return tax; }
set { tax = value; }
}
/// <summary>
/// 联系人
/// </summary>
public string LinkMan
{
get { return linkman; }
set { linkman = value; }
}
/// <summary>
/// 联系电话
/// </summary>
public string Tel
{
get { return tel; }
set { tel = value; }
}
/// <summary>
/// 单位地址
/// </summary>
public string Address
{
get { return address; }
set { address = value; }
}
/// <summary>
/// 开户行及账号
/// </summary>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -