/// <summary>
/// 判断是否成功添加用户生产线权限
/// </summary>
private bool IsQueueUserTrimLine(string user_id)
{
List <EapUserTrimLine> list_trim_line = new List <EapUserTrimLine>();
EapUserTrimLine UserLine;
int count = chk_Assembly_Line.Items.Count;
for (int i = 0; i < count; i++)
{
if (chk_Assembly_Line.GetItemChecked(i))
{
UserLine = new EapUserTrimLine();
UserLine.USER_ID = user_id;
UserLine.TRIM_LINE = (chk_Assembly_Line.Items[i] as EapValueListDetail).VLIST_DETAIL_VALUE;
list_trim_line.Add(UserLine);
}
}
if (list_trim_line == null || list_trim_line.Count == 0)
{
return(true);
}
string ret = Bll.GetBll().SaveUserTrimLine(list_trim_line);
if (ret != string.Empty)
{
Func.ShowMessage(MessageType.Error, ret);
Log.Write(MessageType.Error, "用户总装生产线授权失败，原因[" + ret + "]", Eap.Config.GetConfig().user.USER_ID);
return(false);
}
return(true);
}
/// <summary>
/// 创建用户生产线权限
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
internal string CreateUserLine(EapUserTrimLine UserLine)
{
StringBuilder sql = new StringBuilder();
sql.Append(" insert into T_EAP_USER_TRIM_LINE (USER_ID, TRIM_LINE)");
sql.Append(" values (:USER_ID,:TRIM_LINE)");
OracleParameter[] para = {
new OracleParameter(":USER_ID", OracleType.VarChar),
new OracleParameter(":TRIM_LINE", OracleType.Number)
};
para[0].Value = UserLine.USER_ID;
para[1].Value = UserLine.TRIM_LINE;
return Oracle.GetOracle().ExecSql(sql, para);
}
