/// <summary>
/// 插入权限
/// </summary>
/// <param name="wms_Privilege_Model"></param>
/// <returns></returns>
public static int Insert_Privilege(WMS_Privilege_Model wms_Privilege_Model)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_Privilege_Dal.Insert_Privilege(wms_Privilege_Model)));
}
}
/// <summary>
/// 修改权限
/// </summary>
/// <param name="wms_Privilege_Model"></param>
/// <param name="condition"></param>
/// <returns></returns>
public static int Update_Privilege(WMS_Privilege_Model wms_Privilege_Model, string condition)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_Privilege_Dal.Update_Privilege(wms_Privilege_Model, condition)));
}
}
/// <summary>
/// 插入权限
/// </summary>
/// <param name="wms_Privilege_Model"></param>
/// <returns></returns>
public static string Insert_Privilege(WMS_Privilege_Model wms_Privilege_Model)
{
string _insertSql = "INSERT INTO [WMS].[dbo].[WMS_Privilege]"
+ "([PrivilegeNo],[PrivilegeName])VALUES(" + wms_Privilege_Model.PrivilegeNo
+ ",'" + wms_Privilege_Model.PrivilegeName + "')";
return(_insertSql);
}
/// <summary>
/// 修改权限
/// </summary>
/// <param name="wms_Privilege_Model"></param>
/// <param name="condition"></param>
/// <returns></returns>
public static string Update_Privilege(WMS_Privilege_Model wms_Privilege_Model, string condition)
{
string _updateSql = "UPDATE [WMS].[dbo].[WMS_Privilege]"
+ "SET[PrivilegeNo] = " + wms_Privilege_Model.PrivilegeNo
+ ",[PrivilegeName] = '" + wms_Privilege_Model.PrivilegeName
+ "'WHERE " + condition;
return(_updateSql);
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static List <WMS_Privilege_Model> GetPrivilegeList()
{
List <WMS_Privilege_Model> list = new List <WMS_Privilege_Model>();
DataTable dt = WMS_Privilege_Bll.Select_Privilege(string.Empty);
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Privilege_Model wms_Privilege_Model = new WMS_Privilege_Model
{
PrivilegeNo = int.Parse(dt.Rows[i]["PrivilegeNo"].ToString()),
PrivilegeName = dt.Rows[i]["PrivilegeName"].ToString()
};
list.Add(wms_Privilege_Model);
}
return(list);
}
/// <summary>
/// 搜索按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Search_Click(object sender, RoutedEventArgs e)
{
permissionBase.PrivilegeList.Clear();
List <WMS_Privilege_Model> list = new List <WMS_Privilege_Model>();
DataTable dt = WMS_Privilege_Bll.Select_Privilege(" PrivilegeNo = " + int.Parse(SearchText.Text.Trim()));
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Privilege_Model wMS_Privilege_Model = new WMS_Privilege_Model
{
PrivilegeNo = int.Parse(dt.Rows[i]["PrivilegeNo"].ToString()),
PrivilegeName = dt.Rows[i]["PrivilegeName"].ToString()
};
list.Add(wMS_Privilege_Model);
}
foreach (var model in list)
{
permissionBase.PrivilegeList.Add(model);
}
this.PrivilegeDataGrid.ItemsSource = permissionBase.PrivilegeList;
}
/// <summary>
/// 编辑事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void PrivilegeDataGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
wms_Privilege_Model = e.Row.Item as WMS_Privilege_Model;
privilegeNo = wms_Privilege_Model.PrivilegeNo;
}
