public ActionResult Edit(int id)
{
EtermConfig model = logic.GetEtermConfig(id);
SetCmdTypeDate(model);
return(View(model));
}
public bool AddEtermConfig(EtermConfig etermConfig)
{
bool ret = etermConfigDal.AddEtermConfig(etermConfig) > 0;
CacheManager.ClearCache(CacheManager.EtermConfigCacheKey);
return(ret);
}
public bool UpdateEtermConfig(EtermConfig etermConfig)
{
if (!string.IsNullOrEmpty(etermConfig.ConfigType))
{
etermConfig.ConfigType = etermConfig.ConfigType.TrimEnd(',') + ",";
}
bool ret = etermConfigDal.UpdateEtermConfig(etermConfig) > 0;
CacheManager.ClearCache(CacheManager.EtermConfigCacheKey);
return(ret);
}
private void SetCmdTypeDate(EtermConfig etermConfig)
{
var CmdTypeData = EnumHelper.GetItemValueList <CmdType>();
this.ViewBag.CmdTypeData = CmdTypeData;
var ModelState = EnumHelper.GetItemValueList <EntityStatus>();
this.ViewBag.ModelState = new SelectList(ModelState, "Key", "Value", etermConfig == null ? 0 : etermConfig.ConfigState);
var ConfigLevelData = EnumHelper.GetItemValueList <ConfigLevel>();
this.ViewBag.ConfigLevelData = new SelectList(ConfigLevelData, "Key", "Value", etermConfig == null ? 0 : (int)etermConfig.ConfigLevel);
var AirComData = new AirComLogic().GetAirComList();
this.ViewBag.AirComData = AirComData;
}
public int AddEtermConfig(EtermConfig etermConfig)
{
using (var conn = new SqlConnection(ConnectionStr.FxDb))
{
conn.Open();
string sql = " INSERT INTO dbo.EtermConfig (ServerUrl,OfficeNo,ConfigType,ConfigState,OperDate,AllowAirLine,DenyAirLine,ConfigLevel,Remark) VALUES (@ServerUrl,@OfficeNo,@ConfigType,@ConfigState,GETDATE(),@AllowAirLine,@DenyAirLine,@ConfigLevel,@Remark) ";
return(conn.Execute(sql,
new
{
ServerUrl = etermConfig.ServerUrl,
OfficeNo = etermConfig.OfficeNo,
ConfigState = etermConfig.ConfigState,
ConfigType = etermConfig.ConfigType,
AllowAirLine = etermConfig.AllowAirLine == null ? "*" : etermConfig.AllowAirLine,
DenyairLine = etermConfig.DenyAirLine == null ? "" : etermConfig.DenyAirLine,
ConfigLevel = (int)etermConfig.ConfigLevel,
Remark = etermConfig.Remark
}));
}
}
public int UpdateEtermConfig(EtermConfig etermConfig)
{
using (var conn = new SqlConnection(ConnectionStr.FxDb))
{
conn.Open();
string sql = " UPDATE dbo.EtermConfig SET ServerUrl=@ServerUrl,ConfigState=@ConfigState, OfficeNo=@OfficeNo,ConfigType=@ConfigType,AllowAirLine=@AllowAirLine,DenyairLine=@DenyairLine,ConfigLevel=@ConfigLevel,Remark=@Remark,OperDate=GetDate() WHERE ConfigID=@ConfigID ";
return(conn.Execute(sql,
new
{
ServerUrl = etermConfig.ServerUrl,
OfficeNo = etermConfig.OfficeNo,
ConfigState = etermConfig.ConfigState,
ConfigType = etermConfig.ConfigType,
AllowAirLine = etermConfig.AllowAirLine == null ? "*" : etermConfig.AllowAirLine,
DenyairLine = etermConfig.DenyAirLine == null ? "" : etermConfig.DenyAirLine,
ConfigLevel = (int)etermConfig.ConfigLevel,
Remark = etermConfig.Remark,
ConfigID = etermConfig.ConfigID
}));
}
}
public ActionResult Create(EtermConfig etermConfig, FormCollection c)
{
if (ModelState.IsValid)
{
string types = c["chkitem"] == null ? "" : c["chkitem"].ToString();
string AllowAirComs = c["chkAllowAirComItem"] == null ? "" : c["chkAllowAirComItem"].ToString();
string DenyAirComs = c["chkDenyAirComItem"] == null ? "" : c["chkDenyAirComItem"].ToString();
etermConfig.AllowAirLine = AllowAirComs;
etermConfig.DenyAirLine = DenyAirComs;
etermConfig.ConfigType = types;
etermConfig.ConfigLevel = (ConfigLevel)Convert.ToInt32(c["ConfigLevelData"]);
etermConfig.ConfigState = Convert.ToInt32(c["ModelState"]);
etermConfig.ServerUrl = etermConfig.ServerUrl.Trim();
etermConfig.OfficeNo = string.IsNullOrWhiteSpace(etermConfig.OfficeNo) ? "" : etermConfig.OfficeNo.Trim();
logic.AddEtermConfig(etermConfig);
return(this.RefreshParent());
}
else
{
return(View(etermConfig));
}
}
