private HandlingResult ValidateBeforeSave()
{
HandlingResult result = new HandlingResult();
result.Successed = true;
DataDicDetailModel model = new DataDicDetailModel();
model.Code = textBoxSubName.Text.TrimStart().TrimEnd();
if (comboBoxMainType.SelectedValue != null)
{
DataRow dr = ((System.Data.DataRowView)comboBoxMainType.SelectedValue).Row;
model.Source = Guid.Parse(dr["ID"].ToString());
}
if (String.IsNullOrEmpty(model.Code))
{
result.Message = "请录入名称";
result.Successed = false;
}
if (model.Source == null || model.Source == Guid.Empty)
{
result.Message = "请选择类别";
result.Successed = false;
}
model.Id = Guid.NewGuid();
result.Result = model;
return(result);
}
private HandlingResult ValidateSNSave()
{
HandlingResult result = new HandlingResult();
SnModel model = new SnModel();
model.Name = textBoxSnName.Text.TrimStart().TrimEnd();
model.Code = textBoxSnCode.Text.TrimStart().TrimEnd();
model.StoreId = _selStoreId;
if (String.IsNullOrEmpty(model.Name))
{
result.Successed = false;
result.Message += "\r\n请填写SN别名";
}
if (String.IsNullOrEmpty(model.Code))
{
result.Successed = false;
result.Message += "\r\n请填写SN";
}
if (model.StoreId == null || model.StoreId.Equals(Guid.Empty))
{
result.Successed = false;
result.Message += "\r\n请选择门店";
}
model.Id = Guid.NewGuid();
result.Result = model;
return(result);
}
private void Import()
{
_busyState = true;
try
{
if (File.Exists(openFileDialogMain.FileName))
{
ExcelHelper helper = new ExcelHelper();
DataTable dt = helper.Read(openFileDialogMain.FileName);
//机器SN号 交易时间 交易流水号 交易来源 实付金额 应付金额 手续费 状态 银行流水单
BusinessTransFlowAction action = new BusinessTransFlowAction();
HandlingResult result = action.Import(dt);
if (result.Successed)
{
MessageHelper.ShowInformationNotify(this, result.Message);
}
else
{
MessageHelper.ShowErrorNotify(this, "导入失败,请检查文件格式");
}
}
else
{
MessageHelper.ShowErrorNotify(this, "导入的文件不存在,请检查");
}
}
catch (Exception ex)
{
_log.Error(String.Format("\r\n------------导入交易流水数据时出现错误,文件名::{0}\r\n", openFileDialogMain.FileName), ex);
}
_busyState = false;
}
private void Login()
{
UserValidationModel model = new UserValidationModel();
model.LoginName = textBoxName.Text.TrimStart().TrimEnd();
model.Password = textBoxPassWord.Text;
if (String.IsNullOrEmpty(model.LoginName) || String.IsNullOrEmpty(model.Password))
{
labelMessage.Text = "请录入登录信息";
}
else
{
HandlingResult result = new HandlingResult();
ValidationAction action = new ValidationAction();
result = action.ValidateLogin(model);
if (result.Successed)
{
UserInformationModel user = (UserInformationModel)result.Result;
UserInformationContext.ID = user.Id;
UserInformationContext.Name = user.Name;
UserInformationContext.LoginName = user.LoginName;
UserInformationContext.LoginTime = DateTime.Now;
UserInformationContext.LoginPass = true;
UserInformationContext.StoreId = "";
Close();
}
else
{
labelMessage.Text = result.Message;
}
}
}
public HandlingResult Add(SnModel model)
{
HandlingResult result = new HandlingResult();
String querysql = String.Format("SELECT COUNT(1) AS CNT FROM BPSYS_STORESN WHERE CODE='{0}'", model.Code);
String sql =
"INSERT INTO BPSYS_STORESN(ID, STOREID, NAME, CODE, STATUS, CREATOR, CREATORID, CREATEDTIME) VALUES ('{0}', '{1}', '{2}', '{3}', {4}, '{5}', '{6}', '{7}')";
sql = String.Format(sql, model.Id, model.StoreId, model.Name, model.Code, 1,
UserInformationContext.LoginName,
UserInformationContext.ID, DateTime.Now.ToString(ConfigImformationContext.TIME_FORMAT_FULL));
using (DataBaseProcess process = new DataBaseProcess())
{
DataTable dt = process.Query(querysql);
if (dt != null && dt.Rows.Count > 0)
{
result.MsgNumber = Int32.Parse(dt.Rows[0]["CNT"].ToString());
if (result.MsgNumber == 0)
{
result.MsgNumber = process.Exec(sql);
}
else
{
result.MsgNumber = 0;
result.Message = String.Format("SN[{0}]已经存在", model.Code);
}
}
}
result.Successed = result.MsgNumber > 0;
result.Message = result.Successed ? "新增成功" : "新增失败";
return(result);
}
public HandlingResult Update(SnModel model)
{
HandlingResult result = new HandlingResult();
String sql = String.Format("UPDATE BPSYS_STORESN SET NAME='{0}',CODE='{1}' WHERE ID='{2}'", model.Name,
model.Code, model.Id);
String querysql = String.Format("SELECT ID FROM BPSYS_STORESN WHERE CODE='{0}'", model.Code);
using (DataBaseProcess process = new DataBaseProcess())
{
DataTable dt = process.Query(querysql);
if (dt != null && dt.Rows.Count > 0)
{
Guid id = Guid.Parse(dt.Rows[0]["ID"].ToString());
if (id != model.Id)
{
result.MsgNumber = 0;
result.Message = String.Format("SN[{0}]已经存在", model.Code);
}
else
{
result.MsgNumber = process.Exec(sql);
}
}
}
result.Successed = result.MsgNumber > 0;
result.Message = result.Message.Length > 0 ? result.Message : result.Successed ? "更新成功" : "更新失败";
return(result);
}
/// <summary>
/// 标准成功回调函数
/// </summary>
/// <param name="message"></param>
public void SuccessStandardCallBack(Message message)
{
var handlingResult = new HandlingResult {
Result = message
};
PublisQueue(handlingResult);
}
public MessageHandlingResult(
HandlingResult result,
IDictionary <string, object> additionalProperties = null,
Exception ex = null)
{
Result = result;
AdditionalProperties = additionalProperties;
Exception = ex;
}
/// <summary>
/// 标准失败回调函数
/// </summary>
/// <param name="message"></param>
/// <param name="ex"></param>
public void FailStandardCallBack(Message message, Exception ex)
{
var handlingResult = new HandlingResult
{
Result = message,
Exception = ex
};
PublisQueue(handlingResult);
}
public HandlingResult Clear(ReportClearModel model)
{
HandlingResult result = new HandlingResult();
Boolean wherecluse = false;
// SELECT F.*FROM BUSINESS_TRANSFLOW F
//INNER
// JOIN BPSYS_STORESN SN ON SN.CODE = F.RUNNINGNO
// INNER
// JOIN BPSYS_STORE S ON S.ID = SN.STOREID
//WHERE F.EXCTIME BETWEEN '2015-11-30 17:00:00' AND '2015-12-01 19:00:00'
//AND F.SN = '89'
//AND F.EXCSOURCE = '微信'
//AND SN.NAME = '子店1'
//AND S.ID = ''
String delsql = " DELETE FROM BUSINESS_TRANSFLOW WHERE EXISTS ";
String insertsql = " INSERT INTO BUSINESS_TRANSFLOWT ";
String closql = " SELECT F.* FROM BUSINESS_TRANSFLOW F ";
closql += " INNER JOIN BPSYS_STORESN SN ON SN.CODE = F.RUNNINGNO ";
closql += " INNER JOIN BPSYS_STORE S ON S.ID = SN.STOREID ";
closql += " WHERE 1=1 ";
if (model.StoreId != null && model.StoreId != Guid.NewGuid())
{
closql += String.Format(" AND S.ID='{0}' ", model.StoreId);
}
if (model.StartTime.HasValue && model.FinishTime.HasValue)
{
closql += String.Format(" AND F.EXCTIME BETWEEN '{0}' AND '{1}'",
model.StartTime.Value.ToString(TIME_FORMAT), model.FinishTime.Value.ToString(TIME_FORMAT));
}
if (!String.IsNullOrEmpty(model.SN))
{
closql += String.Format(" F.SN={0}", model.SN);
}
if (!String.IsNullOrEmpty(model.SNName))
{
closql += String.Format(" SN.NAME={0}", model.SNName);
}
if (!String.IsNullOrEmpty(model.Source))
{
closql += String.Format(" F.EXCSOURCE={0}", model.Source);
}
insertsql += closql;
delsql += string.Format("(SELECT 1 FROM ( {0} ) T WHERE BUSINESS_TRANSFLOW.ID=T.ID)", closql);
using (DataBaseProcess process = new DataBaseProcess())
{
result.MsgNumber = process.Exec(insertsql);
result.MsgNumber = process.Exec(delsql);
}
result.Successed = result.MsgNumber > 0;
return(result);
}
public HandlingResult Delete(Guid userId)
{
HandlingResult result = new HandlingResult();
String sql = string.Format("UPDATE BPSYS_USER SET STATUS=2' WHERE ID='{0}'", userId);
using (DataBaseProcess process = new DataBaseProcess())
{
result.MsgNumber = process.Exec(sql);
}
result.Successed = result.MsgNumber > 0;
result.Message = result.Successed ? "修改成功" : "修改失败";
return(result);
}
public HandlingResult Update(StoreModel model)
{
HandlingResult result = new HandlingResult();
String sql = String.Format("UPDATE BPSYS_STORE SET NAME='{0}', PHONE='{1}' WHERE ID='{2}'", model.Name, model.Phone, model.Id);
using (DataBaseProcess process = new DataBaseProcess())
{
result.MsgNumber = process.Exec(sql);
}
result.Successed = result.MsgNumber > 0;
result.Message = result.Successed ? "更新成功" : "更新失败";
return(result);
}
private void Query()
{
SumaryReportAction action = new SumaryReportAction();
HandlingResult result = action.Query(_queryModel);
if (result.Result != null)
{
DataTable dt = (DataTable)result.Result;
Int32 rptype = checkBoxReportType.Checked ? (String.IsNullOrEmpty(_queryModel.SN) ? 3 : 2) : 1;
SetListInvork(dt, rptype);
SetSummaryInvok(dt, result.MsgNumber);
}
}
private void Del(Guid userId)
{
HandlingResult result = ValidateBeforeSave();
result = _action.Delete(userId);
if (result.Successed)
{
MessageHelper.ShowErrorNotify(this, result.Message);
}
else
{
MessageHelper.ShowErrorNotify(this, result.Message);
}
}
private async Task RunCleanup(MessageContext context, HandlingResult handlingResult)
{
foreach (var handler in config.CleanupMiddleware)
{
try
{
await handler.Handle(context, handlingResult);
}
catch (Exception eCleanup)
{
logger.HandlerException(eCleanup);
}
}
}
private HandlingResult ValidateStoreSave()
{
HandlingResult result = new HandlingResult();
StoreModel model = new StoreModel();
model.Name = textBoxName.Text.TrimStart().TrimEnd();
model.Phone = textBoxPhone.Text.TrimStart().TrimEnd();
if (String.IsNullOrEmpty(model.Name))
{
result.Successed = false;
result.Message = "请填写门店名称";
}
model.Id = Guid.NewGuid();
result.Result = model;
return(result);
}
public HandlingResult Add(StoreModel model)
{
HandlingResult result = new HandlingResult();
String sql =
"INSERT INTO BPSYS_STORE(ID, NAME, PHONE, CREATOR, CREATORID, CREATEDTIME) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')";
sql = String.Format(sql, model.Id, model.Name, model.Phone, UserInformationContext.LoginName,
UserInformationContext.ID, DateTime.Now.ToString(ConfigImformationContext.TIME_FORMAT_FULL));
using (DataBaseProcess process = new DataBaseProcess())
{
result.MsgNumber = process.Exec(sql);
}
result.Successed = result.MsgNumber > 0;
result.Message = result.Successed ? "新增成功" : "新增失败";
return(result);
}
private HandlingResult Validate()
{
HandlingResult result = new HandlingResult();
_selSN.Name = textBoxName.Text.Trim();
_selSN.Code = textBoxSN.Text.Trim();
if (String.IsNullOrEmpty(_selSN.Name))
{
result.Message += "请填写别名\r\n";
}
if (String.IsNullOrEmpty(_selSN.Code))
{
result.Message += "请填写SN\r\n";
}
result.Successed = result.Message.Length == 0;
return(result);
}
private void Clear()
{
//TODO button enable
ReportClearModel model = new ReportClearModel();
model.StartTime = dateTimePickerStart.Value;
model.FinishTime = dateTimePickerFinish.Value;
model.SN = textBoxSN.Text.TrimStart().TrimEnd();
model.SNName = textBoxSNName.Text.TrimStart().TrimEnd();
model.Source = comboBoxSource.SelectedText;
model.StoreId = comboBoxStore.SelectedIndex >= 0
? Guid.Parse(comboBoxStore.SelectedValue.ToString())
: Guid.Empty;
ReportClearAction action = new ReportClearAction();
HandlingResult result = action.Clear(model);
//TODO message
}
private HandlingResult ValidateBeforeSave()
{
HandlingResult result = new HandlingResult();
result.Successed = true;
UserModel model = new UserModel();
model.Name = textBoxName.Text.TrimStart().TrimEnd();
model.Phone = textBoxPhone.Text.TrimStart().TrimEnd();
model.Password = textBoxPassword.Text;
model.LoginName = textBoxLoginName.Text.TrimStart().TrimEnd();
if (comboBoxStore.SelectedValue != null)
{
model.StoreId = Guid.Parse(comboBoxStore.SelectedValue.ToString());
}
if (String.IsNullOrEmpty(model.LoginName))
{
result.Message += "\r\n请录入登录名";
result.Successed = false;
}
if (String.IsNullOrEmpty(model.Name))
{
result.Message += "\r\n请录入姓名";
result.Successed = false;
}
if (String.IsNullOrEmpty(model.Password))
{
result.Message += "\r\n请录入登录密码";
result.Successed = false;
}
else
{
model.Password = Md5Helper.GetMD5String(model.Password);
}
if (model.StoreId == null || model.StoreId == Guid.Empty)
{
result.Message += "\r\n请选择门店";
result.Successed = false;
}
model.Id = Guid.NewGuid();
result.Result = model;
return(result);
}
public HandlingResult Modify(UserModel model)
{
HandlingResult result = new HandlingResult();
result.Successed = false;
if (model != null)
{
String sql =
String.Format(
"UPDATE BPSYS_USER SET LOGINNAME='{0}', NAME='{1}', PHONE='{2}', STOREID='{3}' WHERE ID='{4}'",
model.LoginName, model.Name, model.Phone, model.StoreId, model.Id);
using (DataBaseProcess process = new DataBaseProcess())
{
result.MsgNumber = process.Exec(sql);
}
}
result.Successed = result.MsgNumber > 0;
result.Message = result.Successed ? "修改成功" : "修改失败";
return(result);
}
private HandlingResult Validate()
{
HandlingResult result = new HandlingResult();
StoreModel model = new StoreModel();
model.Name = textBoxName.Text.Trim();
model.Phone = textBoxPhone.Text.Trim();
model.Id = Store.Id;
if (String.IsNullOrEmpty(model.Name))
{
result.Message += "请填写门店名称\r\n";
}
//if (String.IsNullOrEmpty(model.Phone))
//{
// result.Message += "请填写门店电话\r\n";
//}
result.Successed = result.Message.Length == 0;
result.Result = model;
return(result);
}
public async Task Handle(IMessageContext context, HandlingResult handlingResult)
{
object flowContextObj;
if (!context.Items.TryGetValue(ContextItems.FlowContext, out flowContextObj))
{
return;
}
var flowContext = (FlowContext)flowContextObj;
if (flowContext?.FlowStateLock != null)
{
if (handlingResult.ConsumeResponse == ConsumeResponse.Nack ||
handlingResult.MessageAction == MessageAction.ErrorLog)
{
await flowContext.FlowStateLock.DeleteFlowState();
}
flowContext.FlowStateLock.Dispose();
}
}
public HandlingResult Add(DataDicDetailModel model)
{
HandlingResult result = new HandlingResult();
result.Successed = false;
if (model != null)
{
String sql =
String.Format(
"INSERT INTO BPSYS_DATADICDETAIL(ID, CODE, SOURCE, CREATOR, CREATORID, CREATEDTIME) VALUES ('{0}', '{1}','{2}' , '{3}','{4}','{5}')",
model.Id, model.Code, model.Source, UserInformationContext.LoginName, UserInformationContext.ID,
DateTime.Now.ToString(ConfigImformationContext.TIME_FORMAT_FULL));
using (DataBaseProcess process = new DataBaseProcess())
{
result.MsgNumber = process.Exec(sql);
}
}
result.Successed = result.MsgNumber > 0;
result.Message = result.Successed ? "新增成功" : "新增失败";
return(result);
}
private void Add()
{
HandlingResult result = ValidateBeforeSave();
if (result.Successed)
{
DataDicDetailModel model = (DataDicDetailModel)result.Result;
result = _action.Add(model);
if (result.Successed)
{
MessageHelper.ShowErrorNotify(this, result.Message);
}
else
{
MessageHelper.ShowErrorNotify(this, result.Message);
}
}
else
{
MessageHelper.ShowErrorNotify(this, result.Message);
}
}
private void Modify()
{
HandlingResult result = ValidateBeforeSave();
if (result.Successed)
{
UserModel model = (UserModel)result.Result;
result = _action.Modify(model);
if (result.Successed)
{
MessageHelper.ShowInformationNotify(this, result.Message);
}
else
{
MessageHelper.ShowErrorNotify(this, result.Message);
}
}
else
{
MessageHelper.ShowErrorNotify(this, result.Message);
}
}
public HandlingResult Add(UserModel model)
{
HandlingResult result = new HandlingResult();
result.Successed = false;
if (model != null)
{
String querysql = String.Format("SELECT COUNT(1) AS CNT FROM BPSYS_USER WHERE LOGINNAME='{0}'", model.LoginName);
String sql =
String.Format(
"INSERT INTO BPSYS_USER(ID, LOGINNAME, NAME, PASSWORD, PHONE, STOREID, STATUS, CREATOR, CREATORID, CREATEDTIME) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', {6}, '{7}', '{8}', '{9}')",
model.Id, model.LoginName, model.Name, model.Password, model.Phone, model.StoreId, 1,
UserInformationContext.LoginName, UserInformationContext.ID,
DateTime.Now.ToString(ConfigImformationContext.TIME_FORMAT_FULL));
using (DataBaseProcess process = new DataBaseProcess())
{
DataTable dt = process.Query(querysql);
if (dt != null && dt.Rows.Count > 0)
{
result.MsgNumber = Int32.Parse(dt.Rows[0]["CNT"].ToString());
if (result.MsgNumber == 0)
{
result.MsgNumber = process.Exec(sql);
}
else
{
result.MsgNumber = 0;
result.Message = String.Format("用户[{0}]已经存在", model.LoginName);
}
}
}
}
result.Successed = result.MsgNumber > 0;
if (String.IsNullOrEmpty(result.Message))
{
result.Message = result.Successed ? "新增成功" : "新增失败";
}
return(result);
}
public HandlingResult ValidateLogin(UserValidationModel model)
{
HandlingResult result = new HandlingResult();
result.Successed = false;
DataTable dt = null;
String sql = String.Format("SELECT * FROM BPSYS_USER WHERE LOGINNAME='{0}'", model.LoginName);
using (DataBaseProcess process = new DataBaseProcess())
{
dt = process.Query(sql);
}
if (dt != null && dt.Rows.Count > 0)
{
UserInformationModel usermodel = new UserInformationModel()
{
Id = Guid.Parse(dt.Rows[0]["ID"].ToString()),
LoginName = dt.Rows[0]["LOGINNAME"].ToString(),
Name = dt.Rows[0]["NAME"].ToString(),
StoreId = dt.Rows[0]["STOREID"].ToString(),
};
String pw = Md5Helper.GetMD5String(model.Password);
if (pw.Equals(dt.Rows[0]["PASSWORD"].ToString()))
{
result.Result = usermodel;
result.Successed = true;
}
else
{
result.Message = "用户名或密码错误!";
}
}
else
{
result.Message = "用户名或密码错误";
}
return(result);
}
/// <summary>
/// 发布队列
/// </summary>
/// <param name="message"></param>
private void PublisQueue(HandlingResult message)
{
using (var channel = _bus.CreateModel())
{
channel.QueueDeclare(CallBackQueueConfig.QueueName,
true,
false,
false,
null);
var content = JsonConvert.SerializeObject(message);
var body = Encoding.UTF8.GetBytes(content);
var properties = channel.CreateBasicProperties();
//消息持久性
properties.Persistent = true;
channel.BasicPublish("",
CallBackQueueConfig.RoutingKey,
properties,
body);
}
}
private void AddSN()
{
HandlingResult result = ValidateSNSave();
if (result.Successed)
{
SnModel model = (SnModel)result.Result;
SNAction action = new SNAction();
result = action.Add(model);
if (result.Successed)
{
MessageHelper.ShowInformationNotify(this, result.Message);
}
else
{
MessageHelper.ShowErrorNotify(this, result.Message);
}
}
else
{
MessageHelper.ShowErrorNotify(this, result.Message);
}
}
