/// <summary>
/// 更新角色
/// </summary>
/// <returns></returns>
public static int Update_Character(WMS_Character_Model wms_Character_Model, string condition)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_Character_Dal.Update_Character(wms_Character_Model, condition)));
}
}
/// <summary>
/// 搜索按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Search_Click(object sender, RoutedEventArgs e)
{
characterBase.CharacterList.Clear();
List <WMS_Character_Model> list = new List <WMS_Character_Model>();
DataTable dt = WMS_Character_Bll.Select_Character(" LoginName = '" + SearchText.Text.Trim() + "'");
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Character_Model wms_Character_Model = new WMS_Character_Model
{
LoginName = dt.Rows[i]["LoginName"].ToString(),
UserName = dt.Rows[i]["UserName"].ToString(),
PartmentNo = int.Parse(dt.Rows[i]["PartmentNo"].ToString()),
UserPrivilege = dt.Rows[i]["UserPrivilege"].ToString(),
CreatPerson = dt.Rows[i]["CreatPerson"].ToString(),
CreatTime = dt.Rows[i]["CreatTime"].ToString(),
ModifyPerson = dt.Rows[i]["ModifyPerson"].ToString(),
ModifyTime = dt.Rows[i]["ModifyTime"].ToString()
};
list.Add(wms_Character_Model);
}
foreach (var model in list)
{
characterBase.CharacterList.Add(model);
}
this.CharacterDataDrid.ItemsSource = characterBase.CharacterList;
}
/// <summary>
/// 插入角色
/// </summary>
/// <returns></returns>
public static int Insert_Character(WMS_Character_Model wms_Character_Model)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_Character_Dal.Insert_Character(wms_Character_Model)));
}
}
/// <summary>
/// 更新角色
/// </summary>
/// <returns></returns>
public static string Update_Character(WMS_Character_Model wms_Character_Model, string condition)
{
string _updateSql = "UPDATE [WMS].[dbo].[WMS_Character]"
+ "SET[LoginName] = '" + wms_Character_Model.LoginName
+ "',[UserName] = '" + wms_Character_Model.UserName
+ "',[PartmentNo] = " + wms_Character_Model.PartmentNo
+ ",[UserPrivilege] = '" + wms_Character_Model.UserPrivilege
+ "',[CreatPerson] = '" + wms_Character_Model.CreatPerson
+ "',[CreatTime] = '" + wms_Character_Model.CreatTime
+ "',[ModifyPerson] = '" + wms_Character_Model.ModifyPerson
+ "',[ModifyTime] = '" + wms_Character_Model.ModifyTime
+ "' WHERE " + condition;
return(_updateSql);
}
/// <summary>
/// 插入角色
/// </summary>
/// <returns></returns>
public static string Insert_Character(WMS_Character_Model wms_Character_Model)
{
string _insertSql = "INSERT INTO [WMS].[dbo].[WMS_Character]"
+ "([LoginName],[UserName],[PartmentNo],[UserPrivilege]"
+ ",[CreatPerson],[CreatTime],[ModifyPerson],[ModifyTime])"
+ "VALUES('" + wms_Character_Model.LoginName + "','"
+ wms_Character_Model.UserName + "','" + wms_Character_Model.PartmentNo
+ "','" + wms_Character_Model.UserPrivilege + "','"
+ wms_Character_Model.CreatPerson + "','"
+ wms_Character_Model.CreatTime + "','"
+ wms_Character_Model.ModifyPerson + "','"
+ wms_Character_Model.ModifyTime + "')";
return(_insertSql);
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static List <WMS_Character_Model> GetUserInfoList()
{
List <WMS_Character_Model> list = new List <WMS_Character_Model>();
DataTable dt = WMS_Character_Bll.Select_Character(" LoginName = '" + LoginViewModel.loginName + "'");
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Character_Model wMS_UserInfo_Model = new WMS_Character_Model
{
LoginName = dt.Rows[i]["LoginName"].ToString(),
UserName = dt.Rows[i]["UserName"].ToString(),
PartmentNo = int.Parse(dt.Rows[i]["PartmentNo"].ToString())
};
list.Add(wMS_UserInfo_Model);
}
return(list);
}
/// <summary>
/// 获取角色列表
/// </summary>
/// <returns></returns>
public static List <WMS_Character_Model> GetCharacterList()
{
List <WMS_Character_Model> list = new List <WMS_Character_Model>();
DataTable dt = WMS_Character_Bll.Select_Character(string.Empty);
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Character_Model wms_Character_Model = new WMS_Character_Model
{
LoginName = dt.Rows[i]["LoginName"].ToString(),
UserName = dt.Rows[i]["UserName"].ToString(),
PartmentNo = int.Parse(dt.Rows[i]["PartmentNo"].ToString()),
UserPrivilege = dt.Rows[i]["UserPrivilege"].ToString(),
CreatPerson = dt.Rows[i]["CreatPerson"].ToString(),
CreatTime = dt.Rows[i]["CreatTime"].ToString(),
ModifyPerson = dt.Rows[i]["ModifyPerson"].ToString(),
ModifyTime = dt.Rows[i]["ModifyTime"].ToString()
};
list.Add(wms_Character_Model);
}
return(list);
}
/// <summary>
/// 编辑文本最后一列结束事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CharacterDataDrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
wMS_Character_Model = e.Row.Item as WMS_Character_Model;
loginName = wMS_Character_Model.LoginName;
}
