/// <summary> /// 保存公司设置信息 /// </summary> /// <param name="form">公司设置对象</param> /// <returns></returns> public bool UpdSetting(T_CompanySetting form) { DBHelper dh = new DBHelper(); dh.BeginTran(); dh.strCmd = "SP_UpdCompanySetting"; dh.AddPare("@R_GUID", SqlDbType.NVarChar, 50, form.R_GUID); dh.AddPare("@C_GUID", SqlDbType.NVarChar, 50, form.C_GUID); dh.AddPare("@StandardCoin", SqlDbType.NVarChar, 50, form.StandardCoin); dh.AddPare("@ReportStartDate", SqlDbType.DateTime, 0, form.ReportStartDate); dh.AddPare("@AuditDate", SqlDbType.DateTime, 0, form.AuditDate); try { dh.NonQuery(); } catch (Exception ex) { dh.RollBackTran(); return(false); } dh.strCmd = "SP_DelCompanyCy"; dh.CleanPara(); dh.AddPare("@C_GUID", SqlDbType.NVarChar, 50, form.C_GUID); try { dh.NonQuery(); } catch (Exception ex) { dh.RollBackTran(); return(false); } dh.strCmd = "SP_UpdCompanyCy"; foreach (string item in form.CompanyCy) { dh.CleanPara(); string R_GUID = Guid.NewGuid().ToString(); dh.AddPare("@R_GUID", SqlDbType.NVarChar, 50, R_GUID); dh.AddPare("@C_GUID", SqlDbType.NVarChar, 50, form.C_GUID); dh.AddPare("@Code", SqlDbType.NVarChar, 50, item); try { dh.NonQuery(); } catch (Exception ex) { dh.RollBackTran(); return(false); } } dh.CommitTran(); return(true); }
///<summary> ///保存公司设置信息 ///<summary> ///<param name="form">公司设置对象</param> public string UpdSetting(T_CompanySetting form) { bool result = false; form.R_GUID = Guid.NewGuid().ToString(); form.ReportStartDate = new DateTime(form.Year, form.Month, 1); form.AuditDate = GetNowDate(); result = new CompanySvc().UpdSetting(form); string msg = string.Empty; if (result) { msg = General.Resource.Common.Success; } else { msg = General.Resource.Common.Failed; } return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" , result.ToString().ToLower(), msg)); }
/// <summary> /// 获取公司设置信息 /// </summary> /// <param name="id">公司标识</param> public ActionResult CompanySetting(string id) { ViewData["C_GUID"] = id; T_CompanySetting Setting = new T_CompanySetting(); Setting = new CompanySvc().GetCompanySetting(id); if (string.IsNullOrEmpty(Setting.R_GUID) == true) { Setting.Month = 1; } else { Setting.Month = Setting.GetReportStartDateMonth(); } Setting.Year = Setting.GetReportStartDateYear(); List <R_CompanyCurrceny> Currceny = new List <R_CompanyCurrceny>(); Currceny = new CompanySvc().GetCompanyCurrceny(id); Setting.CompanyCy = Currceny.Select(i => i.Code).ToArray(); return(View("CompanySetting", Setting)); }