public MyResponseBase Execute()
{
//SoftProjectAreaEntity LoginInfo = HttpContext.Current.Session["LoginInfo"] as SoftProjectAreaEntity;
#region 设置创建人、创建时间、更新人、更新时间
if (LoginInfo != null)
{
Item.CreateUserID = LoginInfo.Sys_LoginInfoID;
Item.CreateUserName = LoginInfo.UserName;
Item.UpdateUserID = LoginInfo.Sys_LoginInfoID;
Item.UpdateUserName = LoginInfo.UserName;
}
#endregion
Item.CreateDate = DateTime.Now;
Item.UpdateDate = DateTime.Now;
MyResponseBase response = new MyResponseBase();
if (!RAInfo.bError)
{
//数据库存操作
MyADORepository dal = new MyADORepository(this);
dal.Execute(response);
}
return(response);
}
/// <summary>
/// 参数由配置文件完成
/// </summary>
/// <returns></returns>
public MyResponseBase AddSave()
{
var resp = new MyResponseBase();
SoftProjectAreaEntityDomain_Domain();
#region (2)添加
using (var scope = new TransactionScope())
{
try
{
var DBFieldVals = Design_ModularOrFun.TSql;
resp = AddSave(DBFieldVals);
//if (Item.NextVisitDate != null)
//{
// var sql = string.Format("Update Pre_User SET NextVisitDate='{0}' WHERE Pre_UserID={1}", Item.NextVisitDate.Format_yyyy_MM_dd(), Item.Pre_UserID);
// Query16(sql, 1);
//}
scope.Complete();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
scope.Dispose();
}
}
#endregion
return(resp);
}
/// <summary>
/// 添加保存
/// </summary>
/// <returns></returns>
public MyResponseBase Fra_Activity_Add()
{
var resp = new MyResponseBase();
var sbsql = new StringBuilder();
sbsql.AppendLine("SELECT TOP 1 *");
sbsql.AppendLine("FROM [dbo].[Act_ActivityFlow]");
sbsql.AppendLine("WHERE ActivityFlowStatuID=1");
sbsql.AppendLine("ORDER BY ActivityFlowSort DESC");
resp = Query16(sbsql.ToString(), 4);
resp.Item.ActivityFlowContext = resp.Item.ActivityFlowContext;
sbsql = new StringBuilder();
sbsql.AppendLine("SELECT TOP 1 *");
sbsql.AppendLine("FROM Act_SurveyTemplate");
sbsql.AppendLine("WHERE SurveyTemplateStatuID=1");
sbsql.AppendLine("ORDER BY SurveyTemplateSort DESC");
var resp1 = Query16(sbsql.ToString(), 4);
resp.Item.Act_SurveyTemplateID = resp1.Item.Act_SurveyTemplateID;
resp.Item.ActivitySelfAtudyTable = resp1.Item.SurveyTemplateTitleContext;
resp.Item.ApplyDate = DateTime.Now;
resp.Item.ApplyPersonID = LoginInfo.Sys_LoginInfoID;
resp.Item.ApplyPerson = LoginInfo.UserName;
resp.Item.Pre_CompanyID = LoginInfo.CompanyID;
return(resp);
}
public ActionResult AuthorizationPanel()
{
MenuCode = "AuthorizationPanel";
var resp = new MyResponseBase();
return(View("SubPanel", resp));
}
public ActionResult Login(SoftProjectAreaEntityDomain domain)
{
//LoginInfo ss = new SoftProject.CellModel.SoftProjectAreaEntity();
var resp = new MyResponseBase();
resp.Item = domain.Item;
if (domain.Item.MobilePhone != null)
{
try
{
resp = domain.Login();
Session["LoginInfo"] = resp.Item;
if (resp.Item.LoginCategoryID == 1)
{
SoftProjectAreaEntityDomain.Sys_OperLogDetail_AddSave(1, 1, "登录", resp.Item.CompanyID, resp.Item.Sys_LoginInfoID, resp.Item.UserName, resp.Item.Sys_LoginInfoID, "登录");
}
else
{
SoftProjectAreaEntityDomain.Sys_OperLogDetail_AddSave(2, 1, "登录", resp.Item.CompanyID, resp.Item.Sys_LoginInfoID, resp.Item.UserName, resp.Item.Sys_LoginInfoID, "登录");
}
return(RedirectToAction("Index", "Home"));
}
catch (Exception e)
{
resp.Item.ErrorMessage = e.Message;
return(View(resp));
}
}
return(View(resp));
}
/// <summary>
/// 添加保存
/// </summary>
/// <returns></returns>
public MyResponseBase Pre_User_AddCompCPSave()
{
var resp = new MyResponseBase();
var bAddProduct = true;//是否添加加盟商零售价格商品
//(1)查询Sql语句
var sqlBC_PartnerProductPriceAddProduct = ProjectCache.Sys_HOperControls.Where(p => p.OperCode == "BC_Partner.BC_PartnerProductPriceAddProductPrice").FirstOrDefault().DBTSql;
var sql = string.Format("SELECT * FROM Pre_Company WHERE Pre_CompanyID={0}", LoginInfo.CompanyID);
var OperatingItemIDs = Query16(sql, 4).Item.OperatingItemIDs;
if (string.IsNullOrEmpty(OperatingItemIDs))
{
bAddProduct = false;
}
#region 添加加盟商
ValidateMobilePhoneAdd();
ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p =>
{
resp = AddSaveNotTran();
if (bAddProduct)
{
sqlBC_PartnerProductPriceAddProduct = string.Format(sqlBC_PartnerProductPriceAddProduct, Item.Pre_CompanyID, resp.Item.Pre_UserID, OperatingItemIDs);
Query16(sqlBC_PartnerProductPriceAddProduct, 1);
}
}));
#endregion
return(resp);
}
/// <summary>
/// 编辑保存
/// </summary>
/// <returns></returns>
public MyResponseBase C_Order_EditSave()
{
if (Item.C_OrderID == null)
{
throw new Exception("顾客订单ID：不能为空");
}
#region 查询原订单金额
var sql = string.Format("SELECT * FROM C_Order WHERE C_OrderID={0}", Item.C_OrderID);
var respOld = Query16(sql, 4);
#endregion
//编辑保存
var resp = new MyResponseBase();
Item.OrderAmount = Item.Items.Sum(p => p.CustomerSpecificationsPrice * p.Number);
var OderAmountNew = Item.OrderAmount;
ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p =>
{
resp = EditSaveNotTran();
C_OrderDetail_AddEditDelete();
//更新数据库：用户帐户余额
sql = string.Format("UPDATE Pre_User SET FundBalance=ISNULL(FundBalance,0)-{0}+{1} WHERE Pre_UserID={2}", OderAmountNew, respOld.Item.OrderAmount, respOld.Item.Pre_UserID);
Query16(sql, 1);
//更新缓存：用户账户余额
var userItem = SoftProjectAreaEntityDomain.Pre_UserRoleAll.Where(o => o.Pre_UserID == respOld.Item.Pre_UserID).FirstOrDefault();
var OrderAmount = (userItem.FundBalance != null ? userItem.FundBalance : 0) - OderAmountNew + respOld.Item.OrderAmount;
userItem.FundBalance = OrderAmount;
}));
return(resp);
}
/// <summary>
/// 添加管理员
/// </summary>
/// <returns></returns>
public MyResponseBase Pre_User_AddAdminSave()
{
var resp = new MyResponseBase();
//查询企业类型为2的管理员角色
var Pre_RoleID = SoftProjectAreaEntityDomain.Pre_Roles.Where(p => p.LoginCategoryID == 2 && p.BAdmin == 1).FirstOrDefault().Pre_RoleID;
if (Pre_RoleID == null)
{
throw new Exception("企业管理员角色还不有添加");
}
//(1)验证
ValidateMobilePhoneAdd();
ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p =>
{
Pre_User_Domain();
Sys_HOperControl = null;
Item.Pre_RoleID = Pre_RoleID;
Item.UserCategoryID = 1;
Item.UserStatuID = 1;
Item.LoginCategoryID = 2;
OperCode = "Pre_User.AddAdminSave";
Item.UserName = Item.PreCompanyName2;
resp = Execute();
}));
//(3)添加到缓存
Item.Pre_UserID = resp.Item.Pre_UserID;
Pre_User_AddCache();
return(resp);
}
public ActionResult IndexEdit(SoftProjectAreaEntityDomain domain)
{
//domain.Querys.Add(new Query { QuryType = 0, FieldName = "P_ProductID___equal", Value = domain.Item.P_ProductID.ToString() });
//ModularOrFunCode = "ProductAreas.P_ProductAttachment.IndexEdit";
//domain.Design_ModularOrFun = Design_ModularOrFun;
//var resp = domain.QueryIndex();
//if (Request.IsAjaxRequest())
// return View(Design_ModularOrFun.PartialView, resp);
//resp.ViewContextName = Design_ModularOrFun.PartialView;
//return View(Design_ModularOrFun.MainView, resp);
//////////////////////////////////////////////////
var resp = new MyResponseBase();
ModularOrFunCode = "ProductAreas.P_ProductAttachment.IndexEdit";
domain.Design_ModularOrFun = Design_ModularOrFun;
if (!string.IsNullOrEmpty(domain.Item.ImageFileNameGuid))
{
domain.Querys.Add(new Query {
QuryType = 0, FieldName = "RefPKTableGuid___equal", Value = domain.Item.ImageFileNameGuid
});
resp = domain.QueryIndex();
}
if (Request.IsAjaxRequest())
{
return(View(Design_ModularOrFun.PartialView, resp));
}
resp.ViewContextName = Design_ModularOrFun.PartialView;
return(View(Design_ModularOrFun.MainView, resp));
}
/// <summary>
/// 编辑保存
/// </summary>
/// <returns></returns>
public MyResponseBase O_OrderDetail_EditSave()
{
//编辑保存
var resp = new MyResponseBase();
O_OrderDetail_PKCheck();
#region (2)编辑
using (var scope = new TransactionScope())
{
try
{
O_OrderDetail_Domain();
//string DBFieldVals = "编辑的字段";
//resp = EditSave(DBFieldVals);
OperCode = "O_OrderDetail.EditSave";
resp = Execute();
scope.Complete();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
scope.Dispose();
}
}
#endregion
return(resp);
}
/// <summary>
/// 编辑保存,包含更新企业管理员信息
/// </summary>
/// <returns></returns>
public MyResponseBase MG_MemberGrade_AddSave()
{
var resp = new MyResponseBase();
var bAddProduct = true;//是否添加加盟商零售价格商品
//添加加盟商零售价格表的商品并设置有效值
//(1)查询Sql语句
var sqlFra_ProductPriceAddProduct = ProjectCache.Sys_HOperControls.Where(p => p.OperCode == "MG_MemberGrade.Fra_ProductPriceAddProduct").FirstOrDefault().DBTSql;
//(2)查找加盟商授权的商品类别
var sql = string.Format("SELECT * FROM Pre_Company WHERE Pre_CompanyID={0}", Item.Pre_CompanyID);
var OperatingItemIDs = Query16(sql, 4).Item.OperatingItemIDs;
if (string.IsNullOrEmpty(OperatingItemIDs))
{
bAddProduct = false;
}
ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p =>
{
resp = AddSaveNotTran();
if (bAddProduct)
{
sqlFra_ProductPriceAddProduct = string.Format(sqlFra_ProductPriceAddProduct, Item.Pre_CompanyID, resp.Item.MG_MemberGradeID, OperatingItemIDs);
Query16(sqlFra_ProductPriceAddProduct, 1);
}
}));
return(resp);
}
/// <summary>
/// 添加保存
/// </summary>
/// <returns></returns>
public MyResponseBase O_OrderDetail_AddSave()
{
//添加保存
var resp = new MyResponseBase();
#region (2)添加
using (var scope = new TransactionScope())
{
try
{
O_OrderDetail_Domain();
//string DBFieldVals = "添加的字段";
//resp = AddSave(DBFieldVals);
OperCode = "O_OrderDetail.AddSave";
Sys_HOperControl = null;
resp = Execute();
scope.Complete();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
scope.Dispose();
}
}
#endregion
return(resp);
}
/// <summary>
/// 根据页面ID查询页面字段
/// </summary>
/// <returns></returns>
public MyResponseBase BC_OrderDetail_Rows()
{
//Item.Fra_ProductPriceIDs
MyResponseBase resp = new MyResponseBase();
if (Item.BC_PartnerProductPriceID == null)
{
throw new Exception("合作商商品价格ID主键不能为空！");
}
string sql = string.Format("SELECT * FROM V_BC_PartnerProductPrice WHERE BC_PartnerProductPriceID={0} ", Item.BC_PartnerProductPriceID);
resp = Query16(sql, 2);
//清空价格
// 订单明细ID(tddata)、商品ID(tddata)、数量(text)、单价(只读)、规格价格(隐藏)、总价(标签：后台计算)、
resp.Items.ForEach(p =>
{
p.Number = 1;
//p.CustomerProductPrice = p.CustomerProductPrice;
//p.CustomerSpecificationsPrice = p.CustomerSpecificationsPrice;
//p.BCProductPrice = p.BCProductPrice;
//p.BCSpecificationsPrice=BCSpecificationsPrice;
p.PriceTotal = p.Number * p.BCSpecificationsPrice;
});
return(resp);
}
/// <summary>
/// 最后1个订单
/// </summary>
/// <returns></returns>
public MyResponseBase C_Recharge_EditSave()
{
if (Item.C_RechargeID == null)
{
throw new Exception("充值记录ID不能为空");
}
#region 查询原记录
var sql = string.Format("SELECT * FROM C_Recharge WHERE C_RechargeID={0}", Item.C_RechargeID);
var respOld = Query16(sql, 4);
#endregion
var resp = new MyResponseBase();
ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p =>
{
resp = EditSaveNotTran();
//更新数据库：用户帐户余额
sql = string.Format("UPDATE Pre_User SET FundBalance=ISNULL(FundBalance,0)+{0}-{1} WHERE Pre_UserID={2}", Item.Amount, respOld.Item.Amount, respOld.Item.Pre_UserID);
Query16(sql, 1);
//更新缓存：用户账户余额
var userItem = SoftProjectAreaEntityDomain.Pre_UserRoleAll.Where(o => o.Pre_UserID == respOld.Item.Pre_UserID).FirstOrDefault();
userItem.FundBalance = (userItem.FundBalance != null? userItem.FundBalance:0) + Item.Amount - respOld.Item.Amount;
}));
return(resp);
}
public ActionResult FraMagerIndex()
{
MyResponseBase resp = new MyResponseBase();
var domain = new SoftProjectAreaEntityDomain();
resp = domain.Doc_Docment_Home();
return(View(resp));
}
/// <summary>
/// 操作日志--根据类别主键查询
/// </summary>
/// <returns></returns>
public MyResponseBase Sys_OperLogDetail_Index()
{
OperCode = "Sys_OperLogDetail.Index";
resp = Execute();
//resp.Item = new Sys_OperLogView(this.Item);
return(resp);
}
/// <summary>
/// 默认Model对象
/// </summary>
public MyResponseBase Default()
{
var resp = new MyResponseBase {
Item = new SoftProjectAreaEntity()
};
return(resp);
}
/// <summary>
/// 操作日志--根据类别主键查询
/// </summary>
/// <returns></returns>
public MyResponseBase Sys_OperLogDetail_ByOperLogIdent()
{
OperCode = "Sys_OperLogDetail.ByOperLogIdent";
resp = Execute();
//resp.Item = new Sys_OperLogView(this.Item);
return(resp);
}
/// <summary>
/// 查询：根据ID查询
/// </summary>
/// <returns></returns>
public MyResponseBase Sys_OperLogDetail_GetByID()
{
if (Sys_OperLogDetail_PKCheck())
{
this.OperCode = "Sys_OperLogDetail.ByID";
resp = Execute();
}
return(resp);
}
/// <summary>
/// 用户管理--显示修改修改密码页面
/// </summary>
/// <param name="domain"></param>
/// <returns></returns>
public ActionResult ChangePass(SoftProjectAreaEntityDomain domain)
{
var resp = new MyResponseBase();
resp.FunNameEn = "Edit";
ModularOrFunCode = "AuthorizationAreas.Pre_User.ChangePass";
resp.ViewContextName = Design_ModularOrFun.PartialView;
return(View(Design_ModularOrFun.MainView, resp));
}
/// <summary>
/// 编辑保存
/// </summary>
/// <returns></returns>
public MyResponseBase Pre_User_EditByMySave()
{
var resp = new MyResponseBase();
ValidateMobilePhoneUpdate();
resp = EditSave();
Pre_User_UpdateCacheByMy();
return(resp);
}
/// <summary>
/// 添加保存
/// </summary>
/// <returns></returns>
public MyResponseBase Pre_User_AddSave()
{
var resp = new MyResponseBase();
ValidateMobilePhoneAdd();
resp = AddSave();
Item.Pre_UserID = resp.Item.Pre_UserID;
Pre_User_AddCache();
return(resp);
}
/// <summary>
/// 为缓存
/// </summary>
/// <returns></returns>
public List <SoftProjectAreaEntity> Ba_Area_GetAll()
{
var resp = new MyResponseBase();
StringBuilder sbSql = new StringBuilder();
string sql = "SELECT * FROM Ba_Area Order By AreaCode";
resp = Query16(sql, 2);
return(resp.Items);
}
/// <summary>
/// 编辑保存
/// </summary>
/// <returns></returns>
public MyResponseBase Pre_Role_EditSave()
{
var resp = new MyResponseBase();
resp = ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p =>
{
resp = EditSaveNotTran();
Pre_RolePremSet_AddUpdateDeleteSaves();
}));
Pre_Role_UpdateCache();//更新缓存
return(resp);
}
/// <summary>
/// 编辑单个对象，参数由配置文件完成
/// </summary>
/// <param name="DBFieldVals"></param>
/// <returns></returns>
public MyResponseBase EditSave()
{
MyResponseBase resp = new MyResponseBase();
SoftProjectAreaEntityDomain_Domain();
#region 主键检查
//var PKFieldValue = 0;
if (string.IsNullOrEmpty(PKField))
{
throw new Exception(ModularName + "主键字段名：不能为空！");
}
var type = Item.GetType(); //获取类型
PropertyInfo propertyInfo = type.GetProperty(PKField);
var PrimaryKeyItem = propertyInfo.GetValue(Item, null);
if (PrimaryKeyItem == null || PrimaryKeyItem == DBNull.Value)
{
throw new Exception(ModularName + "主键值：不能为空！");
}
#endregion
#region (2)编辑
using (var scope = new TransactionScope())
{
try
{
//Comp_Company_Domain();
var DBFieldVals = Design_ModularOrFun.TSql;
var hOperControl = new SoftProjectAreaEntity
{
DBOperType = 2,
DBSelectResultType = 1,
DBSqlParam = DBFieldVals
};
Sys_HOperControl = hOperControl;
resp = Execute();
scope.Complete();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
scope.Dispose();
}
}
#endregion
return(resp);
}
/// <summary>
/// 根据页面ID查询页面字段
/// </summary>
/// <returns></returns>
public MyResponseBase Design_ModularPageField_Rows()
{
MyResponseBase resp = new MyResponseBase();
//string sql = "SELECT * FROM V_Design_ModularPageField Order By TableInfoSort";
string sql = string.Format("SELECT * FROM Design_ModularField WHERE Design_ModularFieldID IN({0}) ", Item.Design_ModularFieldIDs);
resp = Query16(sql, 2);
////(2)查询模块编码字段
//var ModularFields = Design_ModularField_GetModularPageOrQueryField(Item.Design_ModularOrFunID);
//resp.Item.Design_ModularFields = ModularFields;
return(resp);
}
public MyResponseBase Design_ModularOrFunBtnControll_Rows()
{
MyResponseBase resp = new MyResponseBase();
string sql = string.Format("SELECT * FROM Design_ModularOrFunControll WHERE Design_ModularOrFunControllID IN({0}) ", Item.Design_ModularOrFunControllIDs);
resp = Query16(sql, 2);
////(2)查询模块编码字段
//var ModularFields = Design_ModularField_GetModularPageOrQueryField(Item.Design_ModularOrFunID);
//resp.Item.Design_ModularFields = ModularFields;
return(resp);
}
/// <summary>
/// sql语句由数据库年提供
/// </summary>
/// <returns></returns>
public MyResponseBase EditSaves()
{
MyResponseBase resp = new MyResponseBase();
Sys_HOperControl = null;
foreach (var item in Items)
{
Item = item;
resp = Execute();
}
return(resp);
}
/// <summary>
/// 编辑保存,包含更新企业管理员信息
/// </summary>
/// <returns></returns>
public MyResponseBase Pre_Company_EditSave()
{
var resp = new MyResponseBase();
#region 数据处理
if (Item.Ba_AreaID1 != null)
{
Item.AreaName1 = SoftProjectAreaEntityDomain.Ba_Area_GetByAreaID(Item.Ba_AreaID1).AreaName;
Item.AreaName = Item.AreaName1;
}
if (Item.Ba_AreaID2 != null)
{
Item.AreaName2 = SoftProjectAreaEntityDomain.Ba_Area_GetByAreaID(Item.Ba_AreaID2).AreaName;
Item.AreaName += Item.AreaName2;
}
if (Item.Ba_AreaID3 != null)
{
Item.AreaName3 = SoftProjectAreaEntityDomain.Ba_Area_GetByAreaID(Item.Ba_AreaID3).AreaName;
Item.AreaName += Item.AreaName3;
}
//经营项目：字符串
if (!string.IsNullOrEmpty(Item.OperatingItemIDs))// != null && Item.OperatingItemIDs.Count > 0)
{
Item.OperatingItemIDs = Item.OperatingItemIDs.Substring(0, Item.OperatingItemIDs.Length - 1);
var arrs = Item.OperatingItemIDs.Split(',');
var OperatingItemNames = "";
foreach (var s in arrs)
{
OperatingItemNames += SoftProjectAreaEntityDomain.P_Categorys.Where(p => p.P_CategoryID.ToString() == s).FirstOrDefault().PCategoryName + ",";
}
Item.OperatingItemName = OperatingItemNames.Substring(0, OperatingItemNames.Length - 1);
}
#endregion
//更新加盟商零售价格表的商品为有效值
var sqlProductPrice = ProjectCache.Sys_HOperControls.Where(p => p.OperCode == "Pre_Company.Fra_ProductPriceByUpdateBValidate").FirstOrDefault().DBTSql;
sqlProductPrice = string.Format(sqlProductPrice, Item.Pre_CompanyID, Item.OperatingItemIDs);
//更新加盟商的合作商价格表的商品为有效值
var sqlPartnerProductPrice = ProjectCache.Sys_HOperControls.Where(p => p.OperCode == "Pre_Company.BC_PartnerProductPriceByUpdateBValidate").FirstOrDefault().DBTSql;
sqlPartnerProductPrice = string.Format(sqlPartnerProductPrice, Item.Pre_CompanyID, Item.OperatingItemIDs);
resp = ExecuteDelegate(new Action <SoftProjectAreaEntityDomain>(p =>
{
resp = EditSaveNotTran();
Pre_User_EditAdminSave();
Query16(sqlProductPrice, 1); //更新加盟商零售价格表中，商品有效性。
Query16(sqlPartnerProductPrice, 1); //更新加盟商的合作商价格表中，商品有效性。
}));
return(resp);
}
public ActionResult Dashboard(SoftProjectAreaEntityDomain domain)
{
if (domain.Item.Pre_CompanyID == null)
{
throw new Exception("加盟商ID不能为空");
}
var resp = new MyResponseBase {
Item = domain.Item
};
ModularOrFunCode = "AuthorizationAreas.Pre_Company.Dashboard";
domain.Design_ModularOrFun = Design_ModularOrFun;
return(View("Dashboard", resp));
}
