public int Update(P_PREUPLOADORDER entity)
{
var res = UploadOrderDao.Update(entity);
if (entity.IsReopen == 1)
{
groupMemberDao.UpdateServPauseDetail(entity.HTCode, 4);
var nowDate = DateTime.Now;
nowDate = nowDate.AddHours(-168);
var userId = entity.ApplierMUDID;
if (entity.IsTransfer == 1)
{
userId = entity.TransferUserMUDID;
}
var orderList = orderDao.LoadFailOrder(nowDate, userId);
if (orderList.Count < 1)
{
var group = groupMemberDao.FindByUser(userId);
if (group != null)
{
if (group.State == 0 && group.State1 == 0 && group.State2 == 0)
{
groupMemberDao.DelByState3(userId);
}
else
{
groupMemberDao.UpdateState3(userId);
}
}
}
}
return(res);
}
public int Add(P_PREUPLOADORDER entity)
{
var res = UploadOrderDao.Add(entity);
if (res > 0)
{
groupMemberDao.UpdateServPauseDetail(entity.HTCode, 2);
}
return(res);
}
/// <summary>
/// 新增文件上传信息
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(P_PREUPLOADORDER entity)
{
var sqlServerTemplate = sqlServerTemplFactory.CreateDbTemplate();
using (var conn = sqlServerTemplate.GetSqlConnection())
{
conn.Open();
var data = sqlServerTemplate.Find <P_PREUPLOADORDER>("SELECT * FROM dbo.P_PreUploadOrder WHERE HTCode=@HTCode", new SqlParameter[]
{
SqlParameterFactory.GetSqlParameter("HTCode", entity.HTCode)
});
if (data != null)
{
return(0);
}
else
{
var res = sqlServerTemplate.ExecuteNonQuery(
"INSERT INTO P_PreUploadOrder (ID,ApplierName,ApplierMUDID,CreateDate,ModifyDate,HTCode,BUHeadName,BUHeadMUDID,IsReAssign,State,MMCoEImageOne,MMCoEImageTwo,MMCoEImageThree,FileType,IsAttentSame,AttentSameReason,SpecialReason,IsAddFile,IsMeetingInfoSame, MeetingInfoSameReason,Memo,IsTransfer,TransferOperatorMUDID,TransferOperatorName,TransferUserMUDID,TransferUserName,TransferOperateDate,ActionState) VALUES(@ID,@ApplierName,@ApplierMUDID,@CreateDate,@ModifyDate,@HTCode,@BUHeadName,@BUHeadMUDID,@IsReAssign,@State,@MMCoEImageOne,@MMCoEImageTwo,@MMCoEImageThree,@FileType,@IsAttentSame,@AttentSameReason,@SpecialReason,@IsAddFile,@IsMeetingInfoSame,@MeetingInfoSameReason,@Memo,@IsTransfer,@TransferOperatorMUDID,@TransferOperatorName,@TransferUserMUDID,@TransferUserName,@TransferOperateDate,'0') ",
new SqlParameter[]
{
SqlParameterFactory.GetSqlParameter("@ID", entity.ID),
SqlParameterFactory.GetSqlParameter("@ApplierName", entity.ApplierName),
SqlParameterFactory.GetSqlParameter("@ApplierMUDID", entity.ApplierMUDID),
SqlParameterFactory.GetSqlParameter("@CreateDate", entity.CreateDate),
SqlParameterFactory.GetSqlParameter("@ModifyDate", entity.ModifyDate),
SqlParameterFactory.GetSqlParameter("@HTCode", entity.HTCode),
SqlParameterFactory.GetSqlParameter("@BUHeadName", entity.BUHeadName),
SqlParameterFactory.GetSqlParameter("@BUHeadMUDID", entity.BUHeadMUDID),
SqlParameterFactory.GetSqlParameter("@IsReAssign", entity.IsReAssign),
SqlParameterFactory.GetSqlParameter("@State", entity.State),
SqlParameterFactory.GetSqlParameter("@MMCoEImageOne", entity.MMCoEImageOne),
SqlParameterFactory.GetSqlParameter("@MMCoEImageTwo", entity.MMCoEImageTwo),
SqlParameterFactory.GetSqlParameter("@MMCoEImageThree", entity.MMCoEImageThree),
SqlParameterFactory.GetSqlParameter("@FileType", entity.FileType),
SqlParameterFactory.GetSqlParameter("@IsAttentSame", entity.IsAttentSame),
SqlParameterFactory.GetSqlParameter("@AttentSameReason", entity.AttentSameReason),
SqlParameterFactory.GetSqlParameter("@SpecialReason", entity.SpecialReason),
SqlParameterFactory.GetSqlParameter("@IsAddFile", entity.IsAddFile),
SqlParameterFactory.GetSqlParameter("@IsMeetingInfoSame", entity.IsMeetingInfoSame),
SqlParameterFactory.GetSqlParameter("@MeetingInfoSameReason", entity.MeetingInfoSameReason),
SqlParameterFactory.GetSqlParameter("@Memo", entity.Memo),
SqlParameterFactory.GetSqlParameter("@IsTransfer", entity.IsTransfer),
SqlParameterFactory.GetSqlParameter("@TransferOperatorMUDID", entity.TransferOperatorMUDID),
SqlParameterFactory.GetSqlParameter("@TransferOperatorName", entity.TransferOperatorName),
SqlParameterFactory.GetSqlParameter("@TransferUserMUDID", entity.TransferUserMUDID),
SqlParameterFactory.GetSqlParameter("@TransferUserName", entity.TransferUserName),
SqlParameterFactory.GetSqlParameter("@TransferOperateDate", entity.TransferOperateDate),
});
return(res);
}
}
}
public int Add(P_PREUPLOADORDER entity)
{
var res1 = orderService.UpdateOrderUpload(1, entity.HTCode); //更改订单表中的上传文件状态
if (res1 > 0)
{
var res = uploadOrderService.Add(entity); //添加上传文件
return(res);
}
else
{
return(0);
}
}
/// <summary>
/// 编辑文件上传信息
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Update(P_PREUPLOADORDER entity)
{
var sqlServerTemplate = sqlServerTemplFactory.CreateDbTemplate();
using (var conn = sqlServerTemplate.GetSqlConnection())
{
conn.Open();
return(sqlServerTemplate.ExecuteNonQuery(
"UPDATE P_PreUploadOrder SET ModifyDate=@ModifyDate,BUHeadName=@BUHeadName," +
"BUHeadMUDID=@BUHeadMUDID,BUHeadApproveDate=@BUHeadApproveDate," +
"State=@State,MMCoEImageOne=@MMCoEImageOne," +
"MMCoEImageTwo=@MMCoEImageTwo,MMCoEImageThree=@MMCoEImageThree ," +
"FileType=@FileType,IsAttentSame=@IsAttentSame,AttentSameReason=@AttentSameReason,SpecialReason=@SpecialReason,IsAddFile=@IsAddFile,IsMeetingInfoSame=@IsMeetingInfoSame,MeetingInfoSameReason=@MeetingInfoSameReason,Memo=@Memo," +
"IsTransfer=@IsTransfer,TransferOperatorMUDID=@TransferOperatorMUDID,TransferOperatorName=@TransferOperatorName,TransferUserMUDID=@TransferUserMUDID,TransferUserName=@TransferUserName,TransferOperateDate=@TransferOperateDate,ActionState='0' WHERE ID=@ID ",
new SqlParameter[]
{
SqlParameterFactory.GetSqlParameter("@ID", entity.ID),
SqlParameterFactory.GetSqlParameter("@ModifyDate", entity.ModifyDate),
SqlParameterFactory.GetSqlParameter("@BUHeadName", entity.BUHeadName),
SqlParameterFactory.GetSqlParameter("@BUHeadMUDID", entity.BUHeadMUDID),
SqlParameterFactory.GetSqlParameter("@BUHeadApproveDate", entity.BUHeadApproveDate),
SqlParameterFactory.GetSqlParameter("@State", entity.State),
SqlParameterFactory.GetSqlParameter("@MMCoEImageOne", entity.MMCoEImageOne),
SqlParameterFactory.GetSqlParameter("@MMCoEImageTwo", entity.MMCoEImageTwo),
SqlParameterFactory.GetSqlParameter("@MMCoEImageThree", entity.MMCoEImageThree),
SqlParameterFactory.GetSqlParameter("@FileType", entity.FileType),
SqlParameterFactory.GetSqlParameter("@IsAttentSame", entity.IsAttentSame),
SqlParameterFactory.GetSqlParameter("@AttentSameReason", entity.AttentSameReason),
SqlParameterFactory.GetSqlParameter("@SpecialReason", entity.SpecialReason),
SqlParameterFactory.GetSqlParameter("@IsAddFile", entity.IsAddFile),
SqlParameterFactory.GetSqlParameter("@IsMeetingInfoSame", entity.IsMeetingInfoSame),
SqlParameterFactory.GetSqlParameter("@MeetingInfoSameReason", entity.MeetingInfoSameReason),
SqlParameterFactory.GetSqlParameter("@Memo", entity.Memo),
SqlParameterFactory.GetSqlParameter("@IsTransfer", entity.IsTransfer),
SqlParameterFactory.GetSqlParameter("@TransferOperatorMUDID", entity.TransferOperatorMUDID),
SqlParameterFactory.GetSqlParameter("@TransferOperatorName", entity.TransferOperatorName),
SqlParameterFactory.GetSqlParameter("@TransferUserMUDID", entity.TransferUserMUDID),
SqlParameterFactory.GetSqlParameter("@TransferUserName", entity.TransferUserName),
SqlParameterFactory.GetSqlParameter("@TransferOperateDate", entity.TransferOperateDate),
}));
}
}
public void SendOrderRejectMessageToUser(string Comments, P_PREUPLOADORDER order)
{
var channel = WxMessageClientChannelFactory.GetChannel();
channel.SendOrderRejectMessageToUser(Comments, order);
}
//文件上传操作部分
public void SendOrderStateChangeMessageToUser(P_PREUPLOADORDER order)
{
var channel = WxMessageClientChannelFactory.GetChannel();
channel.SendOrderStateChangeMessageToUser(order);
}
public int Update(P_PREUPLOADORDER entity)
{
return(uploadOrderService.Update(entity));
}
public void SendOrderRejectMessageToUser(string Comments, P_PREUPLOADORDER order)
{
wxMessageHandler.SendOrderRejectMessageToUser(Comments, order);
}
public void SendOrderStateChangeMessageToUser(P_PREUPLOADORDER order)
{
wxMessageHandler.SendOrderStateChangeMessageToUser(order);
}
public JsonResult _Submit(string htCode, string MMCoEImageOne, string MMCoEImageTwo, string MMCoEImageThree, int FileType, int IsAttentSame, string AttentSameReason, string SpecialReason, int IsAddFile, int IsMeetingInfoSame, string MeetingInfoSameReason, string Memo)
{
//用户信息
P_USERINFO userInfo = Session[MealH5.Util.ConstantHelper.CURRENTWXUSER] as P_USERINFO;
var uploadChannel = UploadOrderApiClientChannelFactory.GetChannel();
var userInfoChannel = UserInfoClientChannelFactory.GetChannel();
var orderChannel = OrderApiClientChannelFactory.GetChannel();
//DM
var uploadInfo = uploadChannel.FindApproveInfo(userInfo.UserId);
if (uploadInfo == null || uploadInfo.UserId == null)
{
return(Json(new { state = 0, txt = "您的直线经理信息有误，请隔日再尝试提交。", errCode = 6666 }));
}
var uploadInfoDMDelegate = userInfoChannel.isAgent(uploadInfo.UserId);
//RM
var uploaderRMInfo = new WP_QYUSER();
var uploaderRDInfo = new WP_QYUSER();
P_UserDelegate uploaderRDDelegate = null;
if (uploadInfo != null && uploadInfo.UserId != null)
{
uploaderRMInfo = uploadChannel.FindApproveInfo(uploadInfo.UserId);
if (uploaderRMInfo != null && uploaderRMInfo.UserId != null)
{
//RD/SD
uploaderRDInfo = uploadChannel.FindApproveInfo(uploaderRMInfo.UserId);
uploaderRDDelegate = userInfoChannel.isAgent(uploaderRDInfo.UserId);
}
}
var orderInfo = orderChannel.FindOrderByCN(htCode);
var orderUpload = new P_PREUPLOADORDER();
orderUpload.ID = Guid.NewGuid();
orderUpload.ApplierName = orderInfo.IsTransfer == 0 ? userInfo.Name : orderInfo.Consignee; //登录人姓名
orderUpload.ApplierMUDID = orderInfo.IsTransfer == 0 ? userInfo.UserId : orderInfo.UserId; //登录人ID
orderUpload.CreateDate = DateTime.Now; //创建日期
orderUpload.ModifyDate = orderUpload.CreateDate; //修改日期
orderUpload.HTCode = htCode; //HT编号
orderUpload.BUHeadName = FileType == 2 ? (uploaderRDDelegate == null ? uploaderRDInfo.Name : uploaderRDDelegate.DelegateUserName) : (uploadInfoDMDelegate == null ? uploadInfo.Name : uploadInfoDMDelegate.DelegateUserName); //审批人姓名
orderUpload.BUHeadMUDID = FileType == 2 ? (uploaderRDDelegate == null ? uploaderRDInfo.UserId : uploaderRDDelegate.DelegateUserMUDID) : (uploadInfoDMDelegate == null ? uploadInfo.UserId : uploadInfoDMDelegate.DelegateUserMUDID); //审批人ID
orderUpload.IsReAssign = false; //是否重新分配
orderUpload.State = "1"; //状态
orderUpload.MMCoEImageOne = MMCoEImageOne; //上传文件1
orderUpload.MMCoEImageTwo = MMCoEImageTwo; //上传文件2
orderUpload.MMCoEImageThree = MMCoEImageThree; //上传文件2
orderUpload.FileType = FileType;
orderUpload.IsAttentSame = IsAttentSame;
orderUpload.AttentSameReason = AttentSameReason;
orderUpload.SpecialReason = SpecialReason;
orderUpload.IsAddFile = IsAddFile;
orderUpload.IsMeetingInfoSame = IsMeetingInfoSame;
orderUpload.MeetingInfoSameReason = MeetingInfoSameReason;
orderUpload.Memo = Memo;
if (orderInfo.IsTransfer == 1)
{
orderUpload.IsTransfer = orderInfo.IsTransfer;
orderUpload.TransferUserName = orderInfo.TransferUserName;
orderUpload.TransferUserMUDID = orderInfo.TransferUserMUDID;
orderUpload.TransferOperatorName = orderInfo.TransferOperatorName;
orderUpload.TransferOperatorMUDID = orderInfo.TransferOperatorMUDID;
orderUpload.TransferOperateDate = orderInfo.TransferOperateDate;
}
var res = uploadChannel.Add(orderUpload);
if (res > 0)
{
P_OrderApproveHistory history = new P_OrderApproveHistory()
{
ID = Guid.NewGuid(),
PID = orderUpload.ID,
UserName = userInfo.Name,
UserId = userInfo.UserId,
ActionType = 1,
ApproveDate = DateTime.Now,
type = 2
};
uploadChannel.AddOrderApproveHistory(history);
WxMessageHandler.GetInstance().SendOrderStateChangeMessageToUser(orderUpload);
return(Json(new { state = 1 }));
}
if (res == 0)
{
return(Json(new { state = 0, txt = "您的文件已经提交过，请勿重复提交。", errCode = 5555 }));
}
else
{
return(Json(new { state = 0 }));
}
}
