public static void SubmitApprove(ApproveDetail[] approveData)
{
var dataApprove = new ApproveDetail();
var dsApprove = new DataSet();
var row = (from t in approveData select t).FirstOrDefault();
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_approve_edit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(row.id);
cmd.Parameters.Add("@approve_id1", SqlDbType.Int).Value = Convert.ToInt32(row.approve_id1);
cmd.Parameters.Add("@approve_id2", SqlDbType.Int).Value = Convert.ToInt32(row.approve_id2);
cmd.Parameters.Add("@approve_id3", SqlDbType.Int).Value = Convert.ToInt32(row.approve_id3);
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static ApproveDetail EditApprove(string id)
{
var dataApprove = new ApproveDetail();
var dsApprove = new DataSet();
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@id", SqlDbType.Int)
{
Value = Convert.ToInt32(id)
}
};
conn.Open();
dsApprove = SqlHelper.ExecuteDataset(conn, "sp_approve_list", arrParm.ToArray());
conn.Close();
}
if (dsApprove.Tables.Count > 0)
{
var row = dsApprove.Tables[0].Rows[0];
dataApprove.id = Convert.IsDBNull(row["id"]) ? 0 : Convert.ToInt32(row["id"]);
dataApprove.name_app1 = Convert.IsDBNull(row["name_app1"]) ? null : Convert.ToString(row["name_app1"]);
dataApprove.name_app2 = Convert.IsDBNull(row["name_app2"]) ? null : Convert.ToString(row["name_app2"]);
dataApprove.name_app3 = Convert.IsDBNull(row["name_app3"]) ? null : Convert.ToString(row["name_app3"]);
dataApprove.approve_id1 = Convert.IsDBNull(row["id_app1"]) ? null : Convert.ToString(row["id_app1"]);
dataApprove.approve_id2 = Convert.IsDBNull(row["id_app2"]) ? null : Convert.ToString(row["id_app2"]);
dataApprove.approve_id3 = Convert.IsDBNull(row["id_app3"]) ? null : Convert.ToString(row["id_app3"]);
}
}
catch (Exception ex)
{
throw ex;
}
return(dataApprove);
}
public JsonResult OrderConfirm(int id, bool isOK, string msg)
{
if (LUser != null)
{
var info = Order.TryFind(id);
if (info != null)
{
if (isOK)
{
decimal fee = 0;
var feeRate = MC.Models.FeeRate.FindFirst();
if (feeRate != null)
{
fee = info.ProMoney * feeRate.Rate - feeRate.Other;
}
info.State = "结佣中";
info.StateID = 2;
info.StateInfo = "管理员已经审核完成，等待结佣{0}元".FormatWith(fee.ToMoney(2));
info.UpdateAndFlush();
var feeInfo = new Fee();
feeInfo.ID = GuidHelper.GuidNew();
feeInfo.OrderID = info.ID;
feeInfo.Money = fee;
feeInfo.IsPay = false;
feeInfo.PayeeID = info.CrUserID;
feeInfo.CrUserID = LUser.UserId.ToGuid();
feeInfo.CrUser = LUser.UserName;
feeInfo.CrTime = DateTime.Now;
feeInfo.CreateAndFlush();
}
else
{
info.State = "被驳回";
info.StateInfo = msg;
info.StateID = 5;
info.UpdateAndFlush();
}
var approve = new ApproveDetail()
{
ApproveMsg = msg,
Approver = LUser.UserName,
ApproveTime = DateTime.Now,
ApproveType = (int)ApproveType.ORDER,
BusinessIntID = id,
IsOK = isOK
};
approve.CreateAndFlush();
var temp = new 审核结果通知()
{
first = new TemplateDataItem("您收到一条审核消息"),
keyword1 = new TemplateDataItem(DateTime.Now.ToString("yyyy-MM-dd HH:mm")),
keyword2 = new TemplateDataItem(isOK ? "推荐通过审核，等待结佣" : "推荐未通过审核"),
keyword3 = new TemplateDataItem(info.OrderNo),
remark = new TemplateDataItem("请登录系统查询详细信息")
};
var user = Models.User.TryFind(info.CrUserID);
if (user != null)
{
CommFunction.SendWxTemplateMsg(temp, MessageType.审核结果通知, user.OpenID);
}
}
return(Json(JsonReturn.OK(), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(JsonReturn.Error("登录超时"), JsonRequestBehavior.AllowGet));
}
}
