public static void SetItem(IntraIPlimitModel item)
{
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
SQLData.TableObject tableObj = db.GetTableObject("IntraIPlimit");
tableObj.GetDataFromObject(item);
string sql = "Select 1 From IntraIPlimit Where ID = " + item.ID;
bool isNew = db.GetFirstValue(sql) == null;
if (isNew)
{
tableObj["OpenStatus"] = item.OpenStatus == OpenStatus.Open ? 1 : 0;
tableObj["Creator"] = MemberDAO.SysCurrent.Id;
tableObj["CreateTime"] = DateTime.Now;
tableObj.Insert();
}
else
{
tableObj.Remove("ID");
tableObj.Remove("Creator");
tableObj.Remove("CreateTime");
tableObj["Modifier"] = MemberDAO.SysCurrent.Id;
tableObj["ModifyTime"] = DateTime.Now;
tableObj.Update(item.ID);
}
}
public ActionResult Edit(long?id)
{
IntraIPlimitModel item = new IntraIPlimitModel();
item.IsSystemSet = false;
if (id != null)
{
item = WorkV3.Areas.Backend.Models.DataAccess.IntraIPlimitDAO.GetItem((long)id);
}
return(View(item));
}
public static IEnumerable <IntraIPlimitModel> GetItems(bool IsAddInit = true)
{
List <IntraIPlimitModel> items = new List <IntraIPlimitModel>();
string sql = "Select * From [IntraIPlimit] Order By IsSystemSet DESC, IP_Begin Asc";
List <string> where = new List <string>();
SQLData.Database db = new SQLData.Database(WebInfo.Conn);
DataTable datas = db.GetDataTable(sql);
if (IsAddInit)
{
if (datas.Rows.Count <= 0) // 若都是空的, 自動加入全域的一筆, 本筆不可刪除
{
IntraIPlimitModel initModel = new IntraIPlimitModel();
initModel.OpenStatus = OpenStatus.Open;
initModel.IP_Begin = "*";
initModel.IP_End = "*";
initModel.IP_BeginNum = 0;
initModel.IP_EndNum = 0;
initModel.CreateTime = DateTime.Now;
initModel.Creator = MemberDAO.SysCurrent.Id;
initModel.IsSystemSet = true;
SetItem(initModel);
datas = db.GetDataTable(sql);
}
}
foreach (DataRow dr in datas.Rows)
{
IntraIPlimitModel item = new IntraIPlimitModel();
item.ID = int.Parse(dr["ID"].ToString());
item.OpenStatus = (OpenStatus)(int.Parse(dr["OpenStatus"].ToString()));
item.IP_Begin = dr["IP_Begin"].ToString().Trim();
item.IP_End = dr["IP_End"].ToString().Trim();
item.IP_BeginNum = long.Parse(dr["IP_BeginNum"].ToString());
item.IP_EndNum = long.Parse(dr["IP_EndNum"].ToString());
item.Creator = long.Parse(dr["Creator"].ToString());
item.CreateTime = DateTime.Parse(dr["CreateTime"].ToString());
item.Modifier = string.IsNullOrEmpty(dr["Modifier"].ToString()) ? (long?)null : long.Parse(dr["Modifier"].ToString());
item.ModifyTime = string.IsNullOrEmpty(dr["ModifyTime"].ToString()) ? (DateTime?)null : DateTime.Parse(dr["ModifyTime"].ToString());
item.IsSystemSet = bool.Parse(dr["IsSystemSet"].ToString());
items.Add(item);
}
return(items);
}
public ActionResult Edit(IntraIPlimitModel item)
{
if (!Utility.CheckIsLogin())
{
Response.Redirect(Url.Action("Login", "Home"));
}
if (item.ID == 0)
{
WorkV3.Areas.Backend.Models.DataAccess.IntraIPlimitDAO.InsertData(item.OpenStatus, item.IP_Begin, item.IP_End, false);
}
else
{
WorkV3.Areas.Backend.Models.DataAccess.IntraIPlimitDAO.SetItem(item);
}
ViewBag.Exit = true;
return(View(item));
}
/// <summary>
/// 檢查資料
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static List <string> CheckInsertData(IntraIPlimitModel model)
{
model.IP_Begin = model.IP_Begin ?? string.Empty;
model.IP_End = model.IP_End ?? string.Empty;
Regex rgx = new Regex(@"^(25[0-5]|2[0-4][0-9]|1?[0-9]{1,2})(.(25[0-5]|2[0-4][0-9]|1?[0-9]{1,2})){3}$");
List <string> msg = new List <string>();
if (!rgx.IsMatch(model.IP_Begin))
{
msg.Add("起始IP錯誤");
}
if (!rgx.IsMatch(model.IP_End))
{
msg.Add("結束IP錯誤");
}
return(msg);
}
