/// <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));
}
