public CustomerOrderHistoryList()
{
try
{
CustomerOrderViewModel customerOrderViewModel = new CustomerOrderViewModel();
InitializeComponent();
CenterWindowOnScreen();
dpFromDate.SelectedDate = System.DateTime.Now;
dpToDate.SelectedDate = System.DateTime.Now;
customerOrderHistoryModel = customerOrderViewModel.GetCustomerOrderHistoryList(dpFromDate.SelectedDate.Value.ToString(CommonMethods.DateFormat), dpToDate.SelectedDate.Value.ToString(CommonMethods.DateFormat));
if (customerOrderHistoryModel.Count > 0)
{
lblInvoiceCount.Content = customerOrderHistoryModel[0].InvoiceCount;
lblInvoiceTotal.Content = customerOrderHistoryModel[0].InvoiceTotal;
}
else
{
lblInvoiceCount.Content = "0";
lblInvoiceTotal.Content = "0.00";
}
this.dgOrderList.ItemsSource = customerOrderHistoryModel;
}
catch (Exception ex)
{
SystemError.Register(ex);
}
}
private void btnChangePaymentMethod_Click(object sender, RoutedEventArgs e)
{
try
{
var order = (CustomerOrderHistoryModel)dgOrderList.SelectedItem;
if (string.IsNullOrEmpty(order.Payment) || order.Payment.Contains(","))
{
var messageBoxResult = WpfMessageBox.Show(StatusMessages.CustomerOrderHistory, StatusMessages.PaymentMethodModifyNotAllow, MessageBoxButton.OK, EnumUtility.MessageBoxImage.Warning);
cmbSelectPaymentMethod.Focus();
return;
}
ppChangePaymentMethod.IsOpen = true;
CustomerOrderViewModel customerOrderViewModel = new CustomerOrderViewModel();
List <PaymentMethodModel> paymentMethodModels = new List <PaymentMethodModel>();
paymentMethodModels = customerOrderViewModel.GetPaymentMethod();
cmbSelectPaymentMethod.ItemsSource = paymentMethodModels;
cmbSelectPaymentMethod.Text = "Select Payment";
cmbSelectPaymentMethod.IsEditable = true;
cmbSelectPaymentMethod.IsReadOnly = true;
cmbSelectPaymentMethod.SelectedValuePath = "Id";
cmbSelectPaymentMethod.DisplayMemberPath = "PaymentMethodName";
}
catch (Exception ex)
{
SystemError.Register(ex);
}
}
public bool Open()
{
ReadXml();
conn = new SqlConnection();
//conn.ConnectionString = "server=SQLOLEDB.1;Persist Security Info=True;User ID=" + username + ";pwd=" + password + ";Initial Catalog=" + catalog + ";Data Source=" + server;
conn.ConnectionString = @"server=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=YY_DB;Data Source=.";
conn.Open();
DataBase_State = "数据库打开成功！[" + DateTime.Now.ToString() + "]\r\n";
if (conn.State == ConnectionState.Closed)
{
try
{
conn.Open();
DataBase_State = "数据库打开成功！[" + DateTime.Now.ToString() + "]\r\n";
return(true);
}
catch (Exception ex)
{
SystemError.SystemLog(ex.Message);
DataBase_State = "数据库打开失败！[" + DateTime.Now.ToString() + "]\r\n";
return(false);
}
}
return(true);
}
public DataTable Select(string TableName, string[] Fields, string Where)
{
DataTable dt = new DataTable();
StringBuilder sb_Sql = new StringBuilder();
StringBuilder sb_field = new StringBuilder();
for (int i = 0; i < Fields.Length; i++)
{
sb_field.Append(Fields[i]);
sb_field.Append(",");
}
sb_field.Remove(sb_field.Length - 1, 1);
sb_Sql.Append("select ");
sb_Sql.Append(sb_field.ToString());
sb_Sql.Append(" from ");
sb_Sql.Append(TableName);
sb_Sql.Append(" ");
sb_Sql.Append(Where);
try
{
using (SqlDataAdapter da = new SqlDataAdapter(sb_Sql.ToString(), conn))
{
da.Fill(dt);
da.Dispose();
}
}
catch (Exception ex)
{
SystemError.SystemLog(ex.Message);
dt = null;
}
return(dt);
}
private void btnSearchOrderList_Click(object sender, RoutedEventArgs e)
{
try
{
List <CustomerOrderHistoryModel> customerOrderHistoryModel = new List <CustomerOrderHistoryModel>();
CustomerOrderViewModel customerOrderViewModel = new CustomerOrderViewModel();
customerOrderHistoryModel = customerOrderViewModel.GetCustomerOrderHistoryList(dpFromDate.SelectedDate.Value.ToString(CommonMethods.DateFormat), dpToDate.SelectedDate.Value.ToString(CommonMethods.DateFormat));
this.dgOrderList.ItemsSource = customerOrderHistoryModel;
if (customerOrderHistoryModel.Count > 0)
{
lblInvoiceCount.Content = customerOrderHistoryModel[0].InvoiceCount;
lblInvoiceTotal.Content = customerOrderHistoryModel[0].InvoiceTotal;
}
else
{
lblInvoiceCount.Content = "0";
lblInvoiceTotal.Content = "0.00";
}
}
catch (Exception ex)
{
SystemError.Register(ex);
}
}
/// <summary>
/// 增、删、改操作数据库的方法（存储过程）
/// </summary>
/// <param name="ProcedureName">存储过程名</param>
/// <param name="VariableName">参数集合</param>
/// <param name="Values">值集合</param>
/// <returns>返回操作状态（true成功，false失败）</returns>
public bool ExecProcedure(string ProcedureName, string[] VariableName, object[] Values)
{
bool Bool = true;
try
{
MySqlCommand cmd = new MySqlCommand(ProcedureName, conn);
for (int i = 0; i < VariableName.Length; i++)
{
cmd.Parameters.Add("?" + VariableName[i], Values[i]);
}
cmd.CommandType = CommandType.StoredProcedure;
Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
Close();
}
catch (Exception ex)
{
SystemError.SystemLog(ex.Message);
Bool = false;
}
return(Bool);
}
//private void AddMockedData()
//{
// var ctx = this.DataContext as ErrorLogViewModel;
// ctx.LogError(ErrorType.Error, ErrorCategory.PipingErrors, new List<string>{
// "Sample 1 piping error",
// });
// ctx.LogError(ErrorType.Message, ErrorCategory.PipingErrors, new List<string>{
// "Sample 2 piping message adfasd asd fasd fasdf asdfas",
// });
// ctx.LogError(ErrorType.Warning, ErrorCategory.PipingErrors, new List<string>{
// "Sample 3 piping warning",
// });
//}
/// <summary>
/// Logs system errors
/// </summary>
/// <param name="Err">Error Type</param>
/// <param name="ErrCat">Category</param>
/// <param name="ErrMsg">Message</param>
public static void LogError(ErrorType Err, ErrorCategory ErrCat, string ErrMsg)
{
if (string.IsNullOrEmpty(ErrMsg))
{
return;
}
var evm = new ErrorLogViewModel();
if (!(evm.GetPipingError.Any(x => x.Description == ErrMsg)))
{
var imgpath = string.Empty;
if (ErrorType.Error == Err)
{
imgpath = "..\\..\\Image\\TypeImages\\Error.png";
}
else
{
imgpath = "..\\..\\Image\\TypeImages\\Warning.png";
}
var err = new SystemError()
{
Type = Err,
Category = ErrCat,
Description = ErrMsg
};
evm.GetPipingError.Add(err);
}
else
{
return;
}
}
public SqlDataReader GetSingleUser(int nUserID)
{
///定义类SQLHelper
SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
///定义保存从数据库获取的结果的DataReader
SqlDataReader dr = null;
///创建访问数据库的参数
SqlParameter[] paramList =
{
sqlHelper.CreateInParam("@UserID", SqlDbType.Int, 4, nUserID)
};
try
{
///执行存储过程
sqlHelper.RunProc("Pr_GetSingleUser", paramList, out dr);
}
catch (Exception ex)
{
///抛出执行数据库异常
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message, ex);
}
///返回从数据库获取的结果
return(dr);
}
public SqlDataReader GetUserLogin(string sUserName, string sPassword)
{
///定义类SQLHelper
SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
///定义保存从数据库获取的结果的DataReader
SqlDataReader dr = null;
///创建访问数据库的参数
SqlParameter[] paramList =
{
sqlHelper.CreateInParam("@UserName", SqlDbType.VarChar, 200, sUserName),
sqlHelper.CreateInParam("@Password", SqlDbType.VarChar, 255, sPassword)
};
try
{
///执行存储过程
sqlHelper.RunProc("Pr_GetUserLogin", paramList, out dr);
}
catch (Exception ex)
{
///抛出执行数据库异常
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message, ex);
}
///返回从数据库获取的结果
return(dr);
}
public static void UploadError(string msg, string innserMsg)
{
SQLDomainDataProvider provider = BenQGuru.eMES.Common.DomainDataProvider.DomainDataProviderManager.DomainDataProvider() as SQLDomainDataProvider;
SystemSettingFacade facade = new SystemSettingFacade(provider);
SystemError systemError = facade.CreateNewSystemError();
systemError.SystemErrorCode = Guid.NewGuid().ToString();
systemError.ErrorMessage = FormatHelper.CleanString(msg, 100);
systemError.InnerErrorMessage = FormatHelper.CleanString(innserMsg, 100);
systemError.TriggerModuleCode = SessionHelper.Current(HttpContext.Current.Session).ModuleCode;
systemError.SendUser = SessionHelper.Current(HttpContext.Current.Session).UserCode;
if (systemError.SendUser == null || systemError.SendUser == string.Empty)
{
systemError.SendUser = "******";
}
systemError.SendDate = FormatHelper.TODateInt(DateTime.Now);
systemError.SendTime = FormatHelper.TOTimeInt(DateTime.Now);
systemError.IsResolved = FormatHelper.BooleanToString(false);
systemError.MaintainUser = SessionHelper.Current(HttpContext.Current.Session).UserCode;
if (systemError.MaintainUser == null || systemError.MaintainUser == string.Empty)
{
systemError.MaintainUser = "******";
}
facade.AddSystemError(systemError);
provider.PersistBroker.CloseConnection();
}
/// <summary>
/// 用户是否存在
/// </summary>
/// <param name="sUserName"></param>
/// <returns></returns>
public bool Login_Admin(string sUserName)
{
SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
SqlParameter[] ParamList = { sqlHelper.CreateInParam("@UserName", SqlDbType.NVarChar, 50, sUserName) };
SqlDataReader rec = null;
try
{
sqlHelper.RunProc("Login_Admin", ParamList, out rec);
}
catch (Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message, ex);
}
bool Bool = false;
while (rec.Read())
{
if (sUserName == rec["UserName"].ToString())
{
Bool = true;
}
}
return(Bool);
}
/// <summary>
/// 查看分类
/// </summary>
/// <param name="nParentID"></param>
/// <returns></returns>
public List <ProductClass> Get_ProductClass(int nParentID)
{
SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
SqlParameter[] ParamList =
{
sqlHelper.CreateInParam("@ParentID", SqlDbType.Int, 4, nParentID)
};
SqlDataReader rec = null;
try
{
sqlHelper.RunProc("Get_ProductClass", ParamList, out rec);
}
catch (Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message, ex);
}
List <ProductClass> List_ProductClass = new List <ProductClass>();
while (rec.Read())
{
Model.ProductClass productClass = new ProductClass();
productClass.ClassID = Int32.Parse(rec["ClassID"].ToString());
productClass.ClassName = rec["ClassName"].ToString();
productClass.ParentID = Int32.Parse(rec["ParentID"].ToString());
productClass.ParentOrder = Int32.Parse(rec["ParentOrder"].ToString());
List_ProductClass.Add(productClass);
productClass = null;
}
return(List_ProductClass);
}
public bool Insert(string TableName, string[] Fields, object[] Values)
{
bool Bool = true;
StringBuilder sb_Str = new StringBuilder();
StringBuilder sb_Field = new StringBuilder();
StringBuilder sb_Sql = new StringBuilder();
try
{
for (int i = 0; i < Fields.Length; i++)
{
sb_Field.Append(Fields[i]);
sb_Field.Append(",");
sb_Str.Append("@");
sb_Str.Append(Fields[i]);
sb_Str.Append(",");
}
sb_Field.Remove(sb_Field.Length - 1, 1);
sb_Str.Remove(sb_Str.Length - 1, 1);
sb_Sql.Append("insert into ");
sb_Sql.Append(TableName);
sb_Sql.Append("(");
sb_Sql.Append(sb_Field);
sb_Sql.Append(") values(");
sb_Sql.Append(sb_Str);
sb_Sql.Append(")");
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(sb_Sql.ToString(), connection))
{
for (int i = 0; i < Fields.Length; i++)
{
cmd.Parameters.Add("@" + Fields[i], Values[i]);
}
try
{
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
catch (System.Data.SqlClient.SqlException e)
{
connection.Close();
throw e;
}
}
}
}
catch (Exception ex)
{
SystemError.SystemLog(ex.Message);
Bool = false;
}
return(Bool);
}
public static void PutToErrorQueue(SystemError error)
{
string xmlString = error.SerializeToXml();
CloudQueueMessage message = new CloudQueueMessage(xmlString);
CurrErrorQueue.AddMessage(message);
}
/// <summary>
/// 查看单个
/// </summary>
/// <param name="nID"></param>
/// <returns></returns>
public Job Get_SingJob(int nID)
{
SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
SqlParameter[] ParamList = { sqlHelper.CreateInParam("@ID", SqlDbType.Int, 4, nID) };
SqlDataReader rec = null;
try
{
sqlHelper.RunProc("Get_SingJob", ParamList, out rec);
}
catch (Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message, ex);
}
Job job = new Job();
while (rec.Read())
{
job.ID = Int32.Parse(rec["ID"].ToString());
job.Title = rec["Title"].ToString();
job.Content = rec["Content"].ToString();
job.Updatatime = DateTime.Parse(rec["Updatatime"].ToString());
job.Click = Int32.Parse(rec["Click"].ToString());
}
return(job);
}
protected void cmdUploadError_ServerClick(object sender, System.EventArgs e)
{
SystemSettingFacade facade = new SystemSettingFacade(base.DataProvider);
SystemError systemError = facade.CreateNewSystemError();
systemError.SystemErrorCode = Guid.NewGuid().ToString();
systemError.ErrorMessage = FormatHelper.CleanString(this.GetRequestParam("msg"), 100);
systemError.InnerErrorMessage = FormatHelper.CleanString(this.GetRequestParam("innermsg"), 100);
systemError.TriggerModuleCode = SessionHelper.Current(this.Session).ModuleCode;
systemError.SendUser = this.GetUserCode();
if (systemError.SendUser == null || systemError.SendUser == string.Empty)
{
systemError.SendUser = "******";
}
systemError.SendDate = FormatHelper.TODateInt(DateTime.Now);
systemError.SendTime = FormatHelper.TOTimeInt(DateTime.Now);
systemError.IsResolved = FormatHelper.BooleanToString(false);
systemError.MaintainUser = this.GetUserCode();
if (systemError.MaintainUser == null || systemError.MaintainUser == string.Empty)
{
systemError.MaintainUser = "******";
}
facade.AddSystemError(systemError);
string scriptString = "<script language=JavaScript>window.name+='[back]';window.parent.history.back(-1);</script>";
if (!this.IsClientScriptBlockRegistered("clientScript"))
{
this.RegisterClientScriptBlock("clientScript", scriptString);
}
}
public int AddUser(string sUserName, string sPassword, string sEmail, int nRoleID)
{
///定义类SQLHelper
SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
///创建访问数据库的参数
SqlParameter[] paramList =
{
sqlHelper.CreateInParam("@UserName", SqlDbType.VarChar, 200, sUserName),
sqlHelper.CreateInParam("@Password", SqlDbType.VarChar, 255, sPassword),
sqlHelper.CreateInParam("@Email", SqlDbType.VarChar, 200, sEmail),
sqlHelper.CreateInParam("@RoleID", SqlDbType.Int, 4, nRoleID)
};
try
{
///执行存储过程
return(sqlHelper.RunProc("Pr_AddUser", paramList));
}
catch (Exception ex)
{
///抛出执行数据库异常
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message, ex);
}
}
/// <summary>
/// 查询操作数据库的方法（存储过程）
/// </summary>
/// <param name="ProcedureName">存储过程名</param>
/// <param name="VariableName">参数集合</param>
/// <param name="Values">值集合</param>
/// <returns>返回DataTable的集合</returns>
public DataTable ExecProcedureSelect(string ProcedureName, string[] VariableName, object[] Values)
{
DataTable dt = new DataTable();
try
{
using (SqlDataAdapter da = new SqlDataAdapter())
{
SqlCommand cmd = new SqlCommand(ProcedureName, conn);
cmd.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < VariableName.Length; i++)
{
cmd.Parameters.AddWithValue("@" + VariableName[i], Values[i]);
}
da.SelectCommand = cmd;
da.Fill(dt);
da.Dispose();
}
}
catch (Exception ex)
{
SystemError.SystemLog(ex.Message);
dt = null;
}
return(dt);
}
private static void SaveLog(string issuedBy, SeverityEnum severity, SystemError sys, string issuedMessage)
{
if (issuedMessage.Length >= 4000)
{
issuedMessage = issuedMessage.Substring(0, 4000);
}
var options = new TransactionOptions {
IsolationLevel = IsolationLevel.ReadCommitted
};
using (var exceptionLogScope = new TransactionScope(TransactionScopeOption.RequiresNew, options))
{
using (var container = new TransactionModelContainer())
{
container.ErrorLogs.AddObject(new ErrorLog
{
IssuedBy = issuedBy,
IssuedDate = DateTime.Now,
IssuedMessage = issuedMessage,
Severity = (byte)severity,
SystemErrorId = (byte)sys,
SystemErrorName = sys.ToString(),
});
container.SaveChanges();
exceptionLogScope.Complete();
}
}
}
/// <summary>
/// 查看全部
/// </summary>
/// <returns></returns>
public List <Admin> Get_Admin()
{
SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
SqlDataReader rec = null;
try
{
sqlHelper.RunProc("Get_Admin", out rec);
}
catch (Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message, ex);
}
List <Admin> List_Admin = new List <Admin>();
while (rec.Read())
{
Admin admin = new Admin();
admin.ID = Int32.Parse(rec["ID"].ToString());
admin.UserName = rec["UserName"].ToString();
admin.Password = rec["Password"].ToString();
admin.LastLoginIP = rec["LastLoginIP"].ToString();
admin.LastLoginTime = DateTime.Parse(rec["LastLoginTime"].ToString());
List_Admin.Add(admin);
admin = null;
}
return(List_Admin);
}
/// <summary>
/// 查看单个
/// </summary>
/// <param name="nID"></param>
/// <returns></returns>
public Admin Get_SingAdmin(string sUserName)
{
SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
SqlParameter[] ParamList = { sqlHelper.CreateInParam("@UserName", SqlDbType.NVarChar, 50, sUserName) };
SqlDataReader rec = null;
try
{
sqlHelper.RunProc("Get_SingAdmin", ParamList, out rec);
}
catch (Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message, ex);
}
Admin admin = new Admin();
while (rec.Read())
{
admin.ID = Int32.Parse(rec["ID"].ToString());
admin.UserName = rec["UserName"].ToString();
admin.Password = rec["Password"].ToString();
admin.LastLoginIP = rec["LastLoginIP"].ToString();
admin.LastLoginTime = DateTime.Parse(rec["LastLoginTime"].ToString());
}
return(admin);
}
public static IList <T> Select(string TableName, string[] Fields, string Where)
{
DataTable dt = new DataTable();
StringBuilder sb_Sql = new StringBuilder();
StringBuilder sb_field = new StringBuilder();
for (int i = 0; i < Fields.Length; i++)
{
sb_field.Append(Fields[i]);
sb_field.Append(",");
}
sb_field.Remove(sb_field.Length - 1, 1);
sb_Sql.Append("select ");
sb_Sql.Append(sb_field.ToString());
sb_Sql.Append(" from ");
sb_Sql.Append(TableName);
sb_Sql.Append(" ");
sb_Sql.Append(Where);
try
{
MySqlDataAdapter da = new MySqlDataAdapter(sb_Sql.ToString(), new MySqlConnection()); //MySqlData.conn
da.Fill(dt);
da.Dispose();
}
catch (Exception ex)
{
SystemError.SystemLog(ex.Message);
dt = null;
}
return(ModelConvertHelper <T> .ConvertToModel(dt));
}
private void ChangeKOTAllItemStatus(object sender, RoutedEventArgs e)
{
try
{
KitchenViewModel kitchenViewModel = new KitchenViewModel();
var btnChangeStatus = sender as Button;
string kotId = btnChangeStatus.Name.Substring(4);
if (btnChangeStatus.Content.ToString() == "C")
{
kitchenViewModel.ChangeAllKOTItemStatus(kotId, (int)EnumUtility.KOTStatus.Cooking);
}
else if (btnChangeStatus.Content.ToString() == "P")
{
kitchenViewModel.ChangeAllKOTItemStatus(kotId, (int)EnumUtility.KOTStatus.Pending);
}
else if (btnChangeStatus.Content.ToString() == "D")
{
kitchenViewModel.ChangeAllKOTItemStatus(kotId, (int)EnumUtility.KOTStatus.Completed);
}
GetKitchenPending(KitchenOrder);
}
catch (Exception ex)
{
SystemError.Register(ex);
}
}
public bool Delete_W(object obj, string Where)
{
string TableName;
Type t = obj.GetType();
TableName = t.Name;
bool Bool = true;
try
{
MySqlCommand cmd = new MySqlCommand("delete from " + TableName + " " + Where, conn);
Open();
cmd.ExecuteNonQuery();
Close();
}
catch (Exception ex)
{
SystemError.SystemLog(ex.Message);
Bool = false;
Close();
}
return(Bool);
}
protected override void ExcuteSelf()
{
IContract iContract = new ContractDal();
GetEmployee getEmployee = new GetEmployee();
List<Employee> employeeList = new List<Employee>();
employeeList.AddRange(
getEmployee.GetEmployeeBasicInfoByBasicCondition(_EmployeeName, EmployeeTypeEnum.NormalEmployee, -1,
_DepartmentID,
true,-1));
employeeList.AddRange(
getEmployee.GetEmployeeBasicInfoByBasicCondition(_EmployeeName, EmployeeTypeEnum.ProbationEmployee, -1,
_DepartmentID,
true,-1));
employeeList.AddRange(
getEmployee.GetEmployeeBasicInfoByBasicCondition(_EmployeeName, EmployeeTypeEnum.BorrowedEmployee, -1,
_DepartmentID,
true,-1));
employeeList.AddRange(
getEmployee.GetEmployeeBasicInfoByBasicCondition(_EmployeeName, EmployeeTypeEnum.PartTimeEmployee, -1,
_DepartmentID,
true,-1));
employeeList.AddRange(
getEmployee.GetEmployeeBasicInfoByBasicCondition(_EmployeeName, EmployeeTypeEnum.PracticeEmployee, -1,
_DepartmentID,
true,-1));
employeeList.AddRange(
getEmployee.GetEmployeeBasicInfoByBasicCondition(_EmployeeName, EmployeeTypeEnum.Retirement, -1,
_DepartmentID,
true,-1));
employeeList.AddRange(
getEmployee.GetEmployeeBasicInfoByBasicCondition(_EmployeeName, EmployeeTypeEnum.RetirementHire, -1,
_DepartmentID,
true,-1));
employeeList.AddRange(
getEmployee.GetEmployeeBasicInfoByBasicCondition(_EmployeeName, EmployeeTypeEnum.WorkEmployee, -1,
_DepartmentID,
true,-1));
employeeList = HrmisUtility.RemoteUnAuthEmployee(employeeList, AuthType.HRMIS, _Account, _Powers);
foreach (Employee employee in employeeList)
{
string description = string.Empty;
Contract contract = iContract.GetLastContractInAllTypeByAccountID(employee.Account.Id, _CurrentDate);
if (contract == null)
{
description = string.Format("{0}目前没有合同信息", employee.Account.Name);
}
if (string.IsNullOrEmpty(description))
{
continue;
}
SystemError error = new SystemError(description, ErrorType.EmployeeContractError, employee.Account.Id);
error.ErrorEmployee = employee;
error.EditUrl =
string.Format("{0}employeeID={1}",
ErrorType.EmployeeContractError.EditPageUrl,
SecurityUtil.DECEncrypt(employee.Account.Id.ToString()));
_SystemErrorList.Add(error);
}
}
/// <summary>
/// 按分类查看总数
/// </summary>
/// <param name="nClassID"></param>
/// <returns></returns>
public int Get_NewsNum(int nClassID)
{
SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
SqlParameter[] ParamList =
{
sqlHelper.CreateInParam("@startIndex", SqlDbType.Int, 4, 1),
sqlHelper.CreateInParam("@endIndex", SqlDbType.Int, 4, 1),
sqlHelper.CreateInParam("@Classid", SqlDbType.Int, 4, nClassID),
sqlHelper.CreateInParam("@docount", SqlDbType.Bit, 1, 1)
};
SqlDataReader rec = null;
try
{
sqlHelper.RunProc("Get_ClassNews", ParamList, out rec);
}
catch (Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message, ex);
}
int Num = 0;
while (rec.Read())
{
Num = Int32.Parse(rec["Counts"].ToString());
}
return(Num);
}
/// <summary>
/// 查看全部
/// </summary>
/// <param name="nstartIndex"></param>
/// <param name="endIndex"></param>
/// <returns></returns>
public List <Job> Get_Job(int nstartIndex, int nendIndex)
{
SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();
SqlParameter[] ParamList =
{
sqlHelper.CreateInParam("@startIndex", SqlDbType.Int, 4, nstartIndex),
sqlHelper.CreateInParam("@endIndex", SqlDbType.Int, 4, nendIndex),
sqlHelper.CreateInParam("@docount", SqlDbType.Bit, 1, 0)
};
SqlDataReader rec = null;
try
{
sqlHelper.RunProc("Get_Job", ParamList, out rec);
}
catch (Exception ex)
{
SystemError.CreateErrorLog(ex.Message);
throw new Exception(ex.Message, ex);
}
List <Job> List_Job = new List <Job>();
while (rec.Read())
{
Job job = new Job();
job.ID = Int32.Parse(rec["ID"].ToString());
job.Title = rec["Title"].ToString();
job.Content = rec["Content"].ToString();
job.Updatatime = DateTime.Parse(rec["Updatatime"].ToString());
job.Click = Int32.Parse(rec["Click"].ToString());
List_Job.Add(job);
job = null;
}
return(List_Job);
}
/// <summary>
/// 删除操作数据库的方法
/// </summary>
/// <param name="sqlDel">删除操作的SQL语句</param>
/// <returns>返回操作状态（true成功，false失败）</returns>
public bool Delete(string sqlDel)
{
bool Bool = true;
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(sqlDel, connection))
{
try
{
//Open();
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
//Close();
}
catch (Exception ex)
{
connection.Close();
SystemError.SystemLog(ex.Message);
Bool = false;
}
}
}
return(Bool);
}
public static void ReportEnvelopeWithException(QueueEnvelope envelope, Exception exception)
{
SystemError error = GetErrorFromExcetion(exception);
error.MessageContent = envelope;
ReportError(error);
}
/// <summary>
/// 得到自增列的信息
/// </summary>
/// <param name="TableName">表名</param>
/// <returns></returns>
public DataTable GetIncrementColumn(string TableName)
{
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
sb.Append("select so.name Table_name,sc.name Column_name,");
sb.Append("ident_current(so.name) curr_value,");
sb.Append("ident_incr(so.name)incr_value,"); //增量
sb.Append("ident_seed(so.name) seed_value "); //种子
sb.Append("from sysobjects so inner join syscolumns sc ");
sb.Append("on so.id=sc.id and columnproperty(sc.id,sc.name,'IsIdentity')=1 where upper(so.name)=upper('" + TableName + "')");
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlDataAdapter da = new SqlDataAdapter(sb.ToString(), connection))
{
da.Fill(dt);
da.Dispose();
}
}
}
catch (Exception ex)
{
SystemError.SystemLog(ex.Message);
dt = null;
}
return(dt);
}
public void Save()
{
ISystemErrorRepository iSystemErrorRepository = new SystemErrorRepository(this.connectionString);
SystemError systemError = new SystemError
(
new AppActs.DomainModel.Exception.DeviceException("message", "stackTrace", "source", "data"),
new AppActs.DomainModel.System(AppActs.DomainModel.Enum.PlatformType.iOS, "1.1"),
DateTime.Now,
"6.5"
);
iSystemErrorRepository.Save(this.Application.Id, this.Device.Id, systemError);
}
public static SystemError GetErrorFromExcetion(Exception exception)
{
SystemError error = new SystemError
{
ErrorTitle = "Exception: " + exception.GetType().Name,
OccurredAt = DateTime.UtcNow,
SystemErrorItems = new SystemErrorItemCollection()
};
error.SystemErrorItems.CollectionContent.Add(new SystemErrorItem()
{
ShortDescription = exception.Message,
LongDescription = exception.ToString()
});
return error;
}
private static SystemError GetErrorFromMessage(CloudQueueMessage message)
{
SystemError error = new SystemError
{
ErrorTitle = "Cloud Message: " + message.Id,
OccurredAt = DateTime.UtcNow,
SystemErrorItems = new SystemErrorItemCollection()
};
error.SystemErrorItems.CollectionContent.Add(new SystemErrorItem()
{
ShortDescription = "Message content",
LongDescription = message.AsString
});
return error;
}
public RspError(SystemError error)
{
switch (error) {
case SystemError.NoPermission: {
this.Name = error.ToString();
this.Message = "没有权限";
}
break;
case SystemError.RunTimeError: {
this.Name = error.ToString();
this.Message = "运行环境出错";
}
break;
case SystemError.SessionTimeout: {
this.Name = error.ToString();
this.Message = "会话过期";
}
break;
case SystemError.ServiceException: {
this.Name = error.ToString();
this.Message = "服务端方法异常";
}
break;
case SystemError.NoMatchService: {
this.Name = error.ToString();
this.Message = "没有匹配到相应的服务";
}
break;
case SystemError.NoMatchParam: {
this.Name = error.ToString();
this.Message = "没有匹配到参数";
}
break;
case SystemError.ParamIndex: {
this.Name = error.ToString();
this.Message = "参数索引顺序错误";
}
break;
default: {
this.Name = SystemError.UnKnown.ToString();
this.Message = "未知错误";
}
break;
}
}
public static void ReportError(SystemError error)
{
QueueSupport.PutToErrorQueue(error);
}
public override void OnError(SystemError arg0)
{
UnityEngine.Debug.Log(string.Format("An error occured! {0} (#{1})", arg0.Error, arg0.ErrorCode));
}
private static void SaveLog(string issuedBy, SeverityEnum severity, SystemError sys, string issuedMessage)
{
if (issuedMessage.Length >= 4000)
{
issuedMessage = issuedMessage.Substring(0, 4000);
}
var options = new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted };
using (var exceptionLogScope = new TransactionScope(TransactionScopeOption.RequiresNew, options))
{
using (var container = new TransactionModelContainer())
{
container.ErrorLogs.AddObject(new ErrorLog
{
IssuedBy = issuedBy,
IssuedDate = DateTime.Now,
IssuedMessage = issuedMessage,
Severity = (byte)severity,
SystemErrorId = (byte)sys,
SystemErrorName = sys.ToString(),
});
container.SaveChanges();
exceptionLogScope.Complete();
}
}
}
public static void Log(string issuedBy, Exception ex, SystemError sys, SeverityEnum severity = SeverityEnum.HIGH)
{
SaveLog(issuedBy, severity, sys, GetStackTraceMessage(ex));
}
public static void Log(string issuedBy, string issuedMessage, SystemError sys, SeverityEnum severity = SeverityEnum.HIGH)
{
SaveLog(issuedBy, severity, sys, issuedMessage);
}
public RspError(SystemError error, string message)
{
this.Name = error.ToString();
this.Message = message;
}
public static void PutToErrorQueue(SystemError error)
{
string xmlString = error.SerializeToXml();
CloudQueueMessage message = new CloudQueueMessage(xmlString);
CurrErrorQueue.AddMessage(message);
}
