/// <summary>
/// 表格读取
/// </summary>
public void SYS_Grid_Get(ref DataType_Grid model)
{
DataTable table = ProcProxy.ExecuteDataSet("P_SYS_Grid_Get", model).Tables[0];
//
TY.Helper.FormHelper.DataBinding_DataSourceToModel(table, model);
}
/// <summary>
/// 参数读取
/// </summary>
public void SYS_Param_Get(ref DataType_Param model)
{
DataTable table = ProcProxy.ExecuteDataSet("P_SYS_Param_Get", model).Tables[0];
TY.Helper.FormHelper.DataBinding_DataSourceToModel(table, model);
//读取应用程序的版本号
model.WSVersion = Assembly.GetExecutingAssembly().GetName().Version.ToString();
}
public static void ExecuteNoQuery(string procname, ref object model)
{
DbCommand dbcmd = db.GetStoredProcCommand(procname);
dbcmd.CommandTimeout = 300;
// 利用模型的值为存储过程出入口参数赋值（注：模型的值由客户端传递）
ProcProxy.AddInParameterToDbCommand(procname, dbcmd, ref model);
db.ExecuteDataSet(dbcmd);
// 取得存储过程出口参数为模型赋值
ProcProxy.GetOutParameterFromDbCommand(procname, dbcmd, ref model);
}
public static DataSet ExecuteDataSet(string procname, object model)
{
DbCommand dbcmd = db.GetStoredProcCommand(procname);
dbcmd.CommandTimeout = 300;
// 为存储过程出入口参数赋值
if (model != null)
{
ProcProxy.AddInParameterToDbCommand(procname, dbcmd, ref model);
}
return(db.ExecuteDataSet(dbcmd));
}
public static DataSet ExecuteDataSet(string procname, ref object model)
{
DbCommand dbcmd = db.GetStoredProcCommand(procname);
dbcmd.CommandTimeout = 300;
// 为存储过程出入口参数赋值
ProcProxy.AddInParameterToDbCommand(procname, dbcmd, ref model);
DataSet dst = db.ExecuteDataSet(dbcmd);
// 取得存储过程出口参数为模型赋值
ProcProxy.GetOutParameterFromDbCommand(procname, dbcmd, ref model);
return(dst);
}
public void STK_库存入库_Edit(ref DataType_库存管理 model)
{
object m = model;
ProcProxy.ExecuteNoQuery("P_STK_库存入库_Edit", ref m);
}
public void BAS_期初库存_Edit(ref DataType_库存管理 model)
{
object m = model;
ProcProxy.ExecuteNoQuery("P_BAS_期初库存_Edit", ref m);
}
/// <summary>
/// 期初
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataSet BAS_期初库存_List(DataType_库存管理 model)
{
return(ProcProxy.ExecuteDataSet("P_BAS_期初库存_List", model));
}
/// <summary>
/// 供应商
/// </summary>
public DataSet BAS_供应商_List(DataType_供应商 model)
{
return(ProcProxy.ExecuteDataSet("P_BAS_供应商_List", model));
}
public void BAS_储物箱_Edit(ref DataType_仓库 model)
{
object m = model;
ProcProxy.ExecuteNoQuery("P_BAS_储物箱_Edit", ref m);
}
/// <summary>
/// 退出登录
/// </summary>
public void SYS_Logout(DataType_User model)
{
object m = model;
ProcProxy.ExecuteNoQuery("P_SYS_Logout", ref m);
}
/// <summary>
/// 表格设置--保存用户对表格配置
/// </summary>
public void SYS_Grid_Set(ref DataType_Grid model)
{
object m = model;
ProcProxy.ExecuteNoQuery("P_SYS_Grid_Set", ref m);
}
/// <summary>
/// 角色编辑
/// </summary>
public void Sys_Role_Edit(ref DataType_Role model)
{
object m = model;
ProcProxy.ExecuteNoQuery("P_SYS_Role_Edit", ref m);
}
/// <summary>
/// 角色列表
/// </summary>
public DataSet Sys_Role_List(DataType_Role model)
{
return(ProcProxy.ExecuteDataSet("P_SYS_Role_List", model));
}
/// <summary>
/// 账单
/// </summary>
//public void STK_库存总账_Edit(ref DataType_会计期间 model)
//{
// object m = model;
// ProcProxy.ExecuteNoQuery("P_STK_期末结账_Edit", ref m);
//}
public DataSet STK_库存总账_List(DataType_库存管理 model)
{
return(ProcProxy.ExecuteDataSet("P_STK_库存总账_List", model));
}
/// <summary>
/// 系统登录用户的菜单
/// </summary>
public DataSet SYS_Login_Menu(ref DataType_User model)
{
object m = model;
return(ProcProxy.ExecuteDataSet("P_SYS_Login_Menu", ref m));
}
/// <summary>
/// 存货_类别
/// </summary>
public DataSet BAS_存货_类别_List(DataType_存货_类别 model)
{
return(ProcProxy.ExecuteDataSet("P_BAS_存货_类别_List", model));
}
/// <summary>
/// 用户列表
/// </summary>
public DataSet Sys_User_List(DataType_User model)
{
return(ProcProxy.ExecuteDataSet("P_SYS_User_List", model));
}
public DataSet BAS_存货_类别_Down(ref DataType_存货_类别 model)
{
object m = model;
return(ProcProxy.ExecuteDataSet("P_BAS_存货_类别_Down", ref m));
}