public ActionResult Edit(Tb_Gys model)
{
var oldParam = new Hashtable();
BaseResult br = new BaseResult();
Hashtable param = base.GetParameters();
Hashtable param_model = null;
ParamVessel pv = new ParamVessel();
pv.Add("mc", string.Empty, HandleType.ReturnMsg);
pv.Add("bm", string.Empty, HandleType.DefaultValue);
pv.Add("flag_state", string.Empty, HandleType.ReturnMsg);
pv.Add("id", string.Empty, HandleType.ReturnMsg);
try
{
param_model = param.Trim(pv);
oldParam = (Hashtable)param_model.Clone();
model.id_masteruser = id_user_master;
model.id_edit = id_user;
br = BusinessFactory.Tb_Gys.Update(model);
}
catch (Exception ex)
{
br.Message.Add(ex.Message);
}
WriteDBLog("供应商-编辑", oldParam, br);
return(JsonString(br, 1));
}
/// <summary>
/// 获取查询条件参数（采购商/客户角色）
/// </summary>
/// <param name="param"></param>
/// <param name="flag">0 获取分页总条数的参数 1获取分页数据源参数</param>
/// <returns></returns>
private Hashtable Get_cgsPageParam(Hashtable param, int flag)
{
//当选择供应商过滤时
if (param.ContainsKey("id_gys") && long.Parse(param["id_gys"].ToString()) != 0)
{
BaseResult br = new BaseResult();
param.Add("id", param["id_gys"]);
//根据供应商ID获取供应商对象
br = BusinessFactory.Supplier.Get(param);
if (br.Data == null)
{
br.Success = false;
br.Message.Add(string.Format("不存在该供应商或供应商资料有误，请检查后重试！"));
return(null);
}
Tb_Gys gys = (Tb_Gys)br.Data;
if (flag == 1)
{
param.Add("id_userAndMaster", "");
}
param.Add("id_user_master", (long)gys.id_user_master);
param.Remove("id_gys");
param.Remove("id");
}
if (flag == 0)
{
param.Add("fatherId", 0);
param.Add("id_user", GetLoginInfo <long>("id_user"));
}
param.Add("isKeFu", 1);
return(param);
}
///// <summary>
///// 添加关注
///// cxb
///// 2015-4-13
///// </summary>
///// <param name="entity"></param>
///// <returns></returns>
//public override BaseResult Add(dynamic entity)
//{
// BaseResult br = new BaseResult();
// Tb_Gys_Cgs gyscgs = (Tb_Gys_Cgs)entity;
// DAL.Add(gyscgs);
// br.Success = true;
// br.Message.Add(String.Format("取消关注[{1}]。信息：供应商流水号:{0}, 供应商名称:{1}", gyscgs.id_gys, gyscgs.alias_gys));
// return br;
//}
/// <summary>
/// 取消关注
/// lxt
/// 2015-02-28
/// </summary>
public override BaseResult Delete(Hashtable param)
{
BaseResult br = new BaseResult();
long id = TypeConvert.ToInt64(param["id"], 0);
long id_user_master_cgs = TypeConvert.ToInt64(param["id_user_master_cgs"], 0);
long id_user = TypeConvert.ToInt64(param["id_user"], 0);
string flag_from = TypeConvert.ToString(param["flag_from"], "pc");
param.Clear();
param.Add("id", id);
Tb_Gys gys = DAL.GetItem <Tb_Gys>(gysType, param);
if (gys == null)
{
br.Success = false;
br.Message.Add("取消关注失败，该供应商不存在或资料已缺失！");
br.Level = ErrorLevel.Warning;
return(br);
}
param.Clear();
param.Add("id_user_master_gys", gys.id_user_master);
param.Add("id_user_master_cgs", id_user_master_cgs);
Tb_Gys_Cgs gysCgs = DAL.GetItem <Tb_Gys_Cgs>(typeof(Tb_Gys_Cgs), param);
if (gysCgs == null)
{
br.Success = true;
return(br);
}
param.Clear();
param.Add("id_user_master_gys", gys.id_user_master);
param.Add("id_user_master_cgs", id_user_master_cgs);
param.Add("new_flag_stop", YesNoFlag.Yes);
DAL.UpdatePart(typeof(Tb_Gys_Cgs), param);
param.Clear();
param.Add("id_gys", gysCgs.id_gys);
param.Add("id_cgs", gysCgs.id_cgs);
//成功后删除申请记录
DAL.Delete(typeof(Tb_Gys_Cgs_Check), param);
//记录供采关系日志
var Loggcgx = new Tb_Gys_Cgs_Log();
Loggcgx.id_cgs = gysCgs.id_gys.Value;
Loggcgx.id_gys = gysCgs.id_cgs.Value;
Loggcgx.id_user = id_user;
Loggcgx.flag_state = Gys_Cgs_Status.CallBack;
Loggcgx.flag_form = flag_from;
Loggcgx.contents = string.Format("[{0}]撤销对[{1}]的关注.", gysCgs.mc_cgs, gysCgs.mc_gys);
DAL.Add(Loggcgx);
br.Success = true;
br.Message.Add(string.Format("[{0}]撤销对[{1}]的关注.", gysCgs.mc_cgs, gysCgs.mc_gys));
return(br);
}
public ActionResult Add(Tb_Gys model)
{
#region 获取参数
var oldParam = new Hashtable();
Hashtable param = base.GetParameters();
param.Add("id_masteruser", id_user_master);
Hashtable param_model = null;
BaseResult br = new BaseResult();
Tb_Gys model_gys = new Tb_Gys();
#endregion
#region 执行操作
try
{
ParamVessel pv = new ParamVessel();
pv.Add("mc", string.Empty, HandleType.ReturnMsg);
pv.Add("bm", string.Empty, HandleType.DefaultValue);
pv.Add("flag_state", string.Empty, HandleType.ReturnMsg);
pv.Add("id_masteruser", string.Empty, HandleType.ReturnMsg);
param_model = param.Trim(pv);
oldParam = (Hashtable)param_model.Clone();
if (TryUpdateModel(model_gys))
{
model_gys.mc = param_model["mc"].ToString();
model_gys.bm = param_model["bm"].ToString();
model_gys.flag_state = byte.Parse(param_model["flag_state"].ToString());
model_gys.id_masteruser = id_user_master;
model.id_create = id_user;
br = BusinessFactory.Tb_Gys.Add(model_gys);
}
else
{
br.Message.Add("参数有误!");
}
}
catch (Exception ex)
{
br.Message.Add(ex.Message);
}
#endregion
WriteDBLog("供应商-新增", oldParam, br);
return(JsonString(br, 1));
}
private bool CheckParam(BaseResult result, Tb_Gys dwModel, string addOrUpdate = "")
{
result = result ?? new BaseResult();
if (dwModel == null)
{
result.Success = false;
result.Message.Add("参数有误!");
return(false);
}
if (string.IsNullOrEmpty(dwModel.id_masteruser))
{
result.Success = false;
result.Message.Add("请登录!");
return(false);
}
//if (string.IsNullOrEmpty(dwModel.bm))
//{
// result.Success = false;
// result.Message.Add("请输入编码!");
// return false;
//}
Hashtable ht = new Hashtable();
ht.Add("id_masteruser", dwModel.id_masteruser);
ht.Add("dw", dwModel.bm);
ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete);
if (addOrUpdate == "update")
{
if (string.IsNullOrEmpty(dwModel.id))
{
result.Success = false;
result.Message.Add("参数有误!");
return(false);
}
}
if (DAL.GetCount(typeof(Tb_Gys), ht) > 0)
{
result.Success = false;
result.Message.Add("输入单位已存在!");
return(false);
}
return(true);
}
public ActionResult Supplier(string obj)
{
BaseResult br = new BaseResult();
Hashtable param = JSON.Deserialize <Hashtable>(obj);
try
{
//根据供应商获取反馈信息
if (param.ContainsKey("id_gys") && int.Parse(param["id_gys"].ToString()) != 0)
{
param.Add("id", param["id_gys"]);
param.Remove("id_gys");
br = BusinessFactory.Supplier.Get(param);
if (br.Data == null)
{
br.Success = false;
br.Message.Add(string.Format("不存在该供应商或供应商资料有误，请检查后重试！"));
return(null);
}
Tb_Gys gys = (Tb_Gys)br.Data;
param.Add("id_user_master", (long)gys.id_user_master);
param.Remove("id");
}
ParamVessel p = new ParamVessel();
p.Add("pageIndex", (long)1, HandleType.DefaultValue);
p.Add("id_user_master", string.Empty, HandleType.Remove);
p.Add("flag_state", string.Empty, HandleType.Remove);
param = param.Trim(p);
param.Add("isKeFu", 1);//过滤客服数据
param.Add("fatherId", 0);
param.Add("id_user", GetLoginInfo <long>("id_user"));
}
catch (CySoftException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(Json(GetPageData(param)));
}
public override BaseResult Add(dynamic entity)
{
#region 验证参数
BaseResult result = new BaseResult()
{
Success = true
};
Tb_Gys gysModel = entity as Tb_Gys;
if (gysModel == null)
{
result.Success = false;
result.Message.Add("参数有误!");
return(result);
}
if (string.IsNullOrEmpty(gysModel.mc))
{
result.Success = false;
result.Message.Add("名称不允许为空!");
return(result);
}
//if (string.IsNullOrEmpty(gysModel.bm))
//{
// result.Success = false;
// result.Message.Add("编码不允许为空!");
// return result;
//}
#endregion
#region 验证是否重复
Hashtable ht = new Hashtable();
ht.Add("id_masteruser", gysModel.id_masteruser);
ht.Add("mc", gysModel.mc);
ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete);
if (DAL.GetCount(typeof(Tb_Gys), ht) > 0)
{
result.Success = false;
result.Message.Add("输入名称已存在!");
return(result);
}
//ht.Clear();
//ht.Add("id_masteruser", gysModel.id_masteruser);
//ht.Add("bm", gysModel.bm);
//ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete);
//if (DAL.GetCount(typeof(Tb_Gys), ht) > 0)
//{
// result.Success = false;
// result.Message.Add("输入编码已存在!");
// return result;
//}
#endregion
#region 执行操作
try
{
gysModel.id = Guid.NewGuid().ToString();
gysModel.flag_delete = (int)Enums.FlagDelete.NoDelete;
gysModel.rq_create = DateTime.Now;
gysModel.zjm = CySoft.Frame.Utility.MnemonicCode.chinesecap(gysModel.mc);
DAL.Add(gysModel);
}
catch (Exception ex)
{
result.Success = false;
result.Message.Add("新增操作异常!");
}
#endregion
return(result);
}
public override BaseResult Init(Hashtable param)
{
#region 获取数据
BaseResult br = new BaseResult();
Hashtable ht = new Hashtable();
string FilePath = param["filePath"].ToString();
string id_masteruser = param["id_masteruser"].ToString();
string id_user = param["id_user"].ToString();
string id_shop = param["id_shop"].ToString();
List <Tb_Gys_Import> list = (List <Tb_Gys_Import>)param["list"];
List <Tb_Gys_Import> successList = new List <Tb_Gys_Import>();
List <Tb_Gys_Import> failList = new List <Tb_Gys_Import>();
List <Tb_Gys> addGYSList = new List <Tb_Gys>();
List <Tb_Gysfl> addGYSFLList = new List <Tb_Gysfl>();
#endregion
#region 获取供应商分类List
ht.Clear();
ht.Add("id_masteruser", param["id_masteruser"].ToString());
ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete);
var gysflList = DAL.QueryList <Tb_Gysfl>(typeof(Tb_Gysfl), ht);
#endregion
#region 获取所有供应商
ht.Clear();
ht.Add("id_masteruser", param["id_masteruser"].ToString());
ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete);
var allGysList = DAL.QueryList <Tb_Gys_User_QueryModel>(typeof(Tb_Gys), ht);
#endregion
#region 数据处理
foreach (var item in list)
{
br = this.CheckImportInfo(item);
if (!br.Success)
{
item.bz_sys = br.Message.Count > 0 ? br.Message[0].ToString() : "数据不符合要求";
failList.Add(item);
}
else
{
#region 验证数据
if (list.Where(d => d.mc == item.mc).Count() >= 2)
{
item.bz_sys = String.Format("导入数据 名称:{0}重复!", item.mc);
failList.Add(item);
continue;
}
//if (list.Where(d => d.bm == item.bm).Count() >= 2)
//{
// item.bz_sys = String.Format("导入数据 编码:{0}重复!", item.bm);
// failList.Add(item);
// continue;
//}
if (allGysList.Where(d => d.mc == item.mc).Count() > 0)
{
item.bz_sys = String.Format("导入数据 名称:{0} 已被占用!", item.mc);
failList.Add(item);
continue;
}
//if (allGysList.Where(d => d.bm == item.bm).Count() > 0)
//{
// item.bz_sys = String.Format("导入数据 编码:{0} 已被占用!", item.bm);
// failList.Add(item);
// continue;
//}
#endregion
#region 供应商分类 如果不存在 则添加一条
string idgysfl = Guid.NewGuid().ToString();
if (!string.IsNullOrEmpty(item.id_gysfl) && gysflList != null && gysflList.Where(d => d.mc == item.id_gysfl && d.flag_delete == 0).Count() > 0)
{
idgysfl = gysflList.Where(d => d.mc == item.id_gysfl && d.flag_delete == 0).FirstOrDefault().id;
}
else
{
Tb_Gysfl gysflModel = new Tb_Gysfl()
{
id_masteruser = id_masteruser,
id = idgysfl,
bm = DateTime.Now.ToString("yyyyMMddHHmmss"),
mc = item.id_gysfl,
path = "0/" + idgysfl,
id_farther = "0",
id_create = id_user,
rq_create = DateTime.Now,
id_edit = id_user,
rq_edit = DateTime.Now,
flag_delete = 0,
sort_id = 0
};
gysflList.Add(gysflModel);
addGYSFLList.Add(gysflModel);
}
#endregion
#region 供应商model
Tb_Gys model = new Tb_Gys()
{
id = GetGuid,
id_masteruser = id_masteruser,
bm = item.bm,
mc = item.mc,
id_gysfl = idgysfl,
companytel = item.companytel,
zjm = CySoft.Utility.PinYin.GetChineseSpell(item.mc),
tel = item.tel,
lxr = item.lxr,
email = item.email,
zipcode = item.zipcode,
address = item.address,
flag_state = byte.Parse(item.flag_state),
bz = item.bz,
id_create = id_user,
rq_create = DateTime.Now,
id_edit = id_user,
rq_edit = DateTime.Now,
flag_delete = 0
};
addGYSList.Add(model);
#endregion
successList.Add(item);
}
}
#endregion
#region 保存供应商相关信息
DAL.AddRange(addGYSList);
DAL.AddRange(addGYSFLList);
#endregion
br.Message.Add(String.Format("导入供应商成功!"));
br.Success = true;
br.Data = new Tb_Gys_Import_All()
{
SuccessList = successList, FailList = failList
};
return(br);
}
public override BaseResult Update(dynamic entity)
{
#region 验证参数
BaseResult result = new BaseResult()
{
Success = true
};
Tb_Gys gysModel = entity as Tb_Gys;
if (gysModel == null || string.IsNullOrEmpty(gysModel.id))
{
result.Success = false;
result.Message.Add("参数有误!");
return(result);
}
if (string.IsNullOrEmpty(gysModel.mc))
{
result.Success = false;
result.Message.Add("名称不允许为空!");
return(result);
}
//if (string.IsNullOrEmpty(gysModel.bm))
//{
// result.Success = false;
// result.Message.Add("编码不允许为空!");
// return result;
//}
#endregion
#region 验证是否重复
Hashtable ht = new Hashtable();
ht.Add("id_masteruser", gysModel.id_masteruser);
ht.Add("mc", gysModel.mc);
ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete);
ht.Add("not_id", gysModel.id);
if (DAL.GetCount(typeof(Tb_Gys), ht) > 0)
{
result.Success = false;
result.Message.Add("输入名称已存在!");
return(result);
}
//ht.Clear();
//ht.Add("id_masteruser", gysModel.id_masteruser);
//ht.Add("bm", gysModel.bm);
//ht.Add("flag_delete", (int)Enums.FlagDelete.NoDelete);
//ht.Add("not_id", gysModel.id);
//if (DAL.GetCount(typeof(Tb_Gys), ht) > 0)
//{
// result.Success = false;
// result.Message.Add("输入编码已存在!");
// return result;
//}
#endregion
#region 更新操作
ht.Clear();
ht.Add("id", gysModel.id);
ht.Add("id_masteruser", gysModel.id_masteruser);
ht.Add("new_bm", gysModel.bm);
ht.Add("new_mc", gysModel.mc);
ht.Add("new_lxr", gysModel.lxr);
ht.Add("new_flag_state", gysModel.flag_state);
ht.Add("new_tel", gysModel.tel);
ht.Add("new_companytel", gysModel.companytel);
ht.Add("new_email", gysModel.email);
ht.Add("new_zipcode", gysModel.zipcode);
ht.Add("new_address", gysModel.address);
ht.Add("new_bz", gysModel.bz);
ht.Add("new_rq_edit", DateTime.Now);
ht.Add("new_id_edit", gysModel.id_edit);
ht.Add("new_id_gysfl", gysModel.id_gysfl);
try
{
DAL.UpdatePart(typeof(Tb_Gys), ht);
}
catch (Exception ex)
{
result.Success = false;
result.Message.Add("更新操作异常!");
}
#endregion
return(result);
}
public ActionResult AddToSupplier(string obj)
{
BaseResult br = new BaseResult();
Hashtable param = JSON.Deserialize <Hashtable>(obj);
Faq model = new Faq();
if (String.IsNullOrEmpty(param["contents"].ToString()))
{
br.Message.Add(string.Format("反馈内容不允许为空！"));
br.Success = false;
return(Json(br));
}
else if (param["contents"].ToString().Length > 2000)
{
br.Success = false;
br.Message.Add(string.Format("提交内容请限定在2000个字内！"));
return(Json(br));
}
model.contents = param["contents"].ToString();
param.Remove("contents");
bool b = false;
long fatherId = 0;
long id_gys = 0;
//判断是否为继续反馈
if (param.ContainsKey("contain"))
{
ParamVessel p = new ParamVessel();
b = true;
fatherId = long.Parse(param["fatherId"].ToString());
p.Add("fatherId", 0, HandleType.ReturnMsg);
p.Add("id_user_master", 0, HandleType.ReturnMsg);
param = param.Trim(p);
model.fatherId = fatherId;
model.id_user_master = long.Parse(param["id_user_master"].ToString());
param.Remove("contain");
}
else
{
id_gys = long.Parse(param["id"].ToString());
//根据供应商ID获取供应商对象
br = BusinessFactory.Supplier.Get(param);
if (br.Data == null)
{
br.Success = false;
br.Message.Add(string.Format("不存在该供应商或供应商资料有误，请检查后重试！"));
return(Json(br));
}
Tb_Gys gys = (Tb_Gys)br.Data;
model.flag_state = 0;
model.fatherId = 0;
model.id_user_master = gys.id_user_master;
param.Remove("id");
}
try
{
model.id = BusinessFactory.Utilety.GetNextKey(typeof(Faq));
model.id_user = GetLoginInfo <long>("id_user");
model.id_user_receive = 0;
model.flag_delete = 0; // 0 未删除
model.flag_from = "android";
br = BusinessFactory.Faq.Add(model);
//当继续提交反馈成功后修改主问题Id状态为0
if (!br.Success)
{
return(Json(br));
}
if (br.Success && b)
{
br = UpdateFaqState(fatherId, 0);
}
return(Json(br));
}
catch (CySoftException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
