public ConnectWayInfo GetModel(int id, bool fromCache = false)
{
ConnectWayInfo entity = null;
List <ConnectWayInfo> list = GetList(fromCache);
entity = list.Find(c => c.ID == id);
return(entity);
}
public string GetName(int id)
{
ConnectWayInfo entity = GetModel(id, true);
if (entity == null)
{
return(string.Empty);
}
return(entity.Name);
}
public static ConnectWayInfo PopulateConnectWayInfo(IDataReader reader)
{
ConnectWayInfo entity = new ConnectWayInfo()
{
ID = (int)reader["ID"],
Name = reader["Name"] as string,
DataLevel = (int)reader["DataLevel"],
CorporationID = (int)reader["CorporationID"],
Sort = DataConvert.SafeInt(reader["Sort"])
};
return(entity);
}
private void LoadData()
{
int id = GetInt("id");
if (id > 0)
{
CurrentConnectWay = ConnectWays.Instance.GetModel(id);
if (CurrentConnectWay == null)
WriteMessage("/message.aspx", "系统提示", "无效追踪方式！", "", "/index.aspx");
else
{
if (!Admin.Administrator && Admin.CorporationID != CurrentConnectWay.CorporationID)
WriteMessage("/message.aspx", "系统提示", "没有权限！", "", "/index.aspx");
if (!Admin.Administrator && CurrentConnectWay.DataLevel == 0)
WriteMessage("/message.aspx", "系统提示", "没有权限！", "", "/index.aspx");
txtName.Value = CurrentConnectWay.Name;
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
ConnectWayInfo entity = new ConnectWayInfo();
int id = GetInt("id");
if (id > 0)
{
entity = ConnectWays.Instance.GetModel(id, true);
FillData(entity);
ConnectWays.Instance.Update(entity);
}
else
{
FillData(entity);
entity.DataLevel = GetInt("corpid") == 0 ? 0 : 1;
ConnectWays.Instance.Add(entity);
}
ConnectWays.Instance.ReloadConnectWayListCache();
Response.Redirect(string.IsNullOrEmpty(FromUrl) ? "connectwaymg.aspx" : FromUrl);
}
public void Update(ConnectWayInfo entity)
{
CommonDataProvider.Instance().UpdateConnectWay(entity);
}
public abstract void UpdateConnectWay(ConnectWayInfo entity);
public abstract void AddConnectWay(ConnectWayInfo entity);
public override void UpdateConnectWay(ConnectWayInfo entity)
{
string sql = @"
UPDATE ComOpp_ConnectWay set
Name = @Name
WHERE ID=@ID";
SqlParameter[] parameters =
{
new SqlParameter("@ID", entity.ID),
new SqlParameter("@Name", entity.Name)
};
SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, parameters);
}
public override void AddConnectWay(ConnectWayInfo entity)
{
string sql = @"INSERT INTO ComOpp_ConnectWay(
[Name]
,[CorporationID]
,[DataLevel]
,[Sort]
)VALUES(
@Name
,@CorporationID
,@DataLevel
,(SELECT ISNULL(MAX([Sort]),0) + 1 FROM ComOpp_ConnectWay WHERE [CorporationID] = @CorporationID)
)";
SqlParameter[] p =
{
new SqlParameter("@Name",entity.Name),
new SqlParameter("@CorporationID",entity.CorporationID),
new SqlParameter("@DataLevel",entity.DataLevel)
};
SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, p);
}
public abstract void UpdateConnectWay(ConnectWayInfo entity);
public abstract void AddConnectWay(ConnectWayInfo entity);
public static ConnectWayInfo PopulateConnectWayInfo(IDataReader reader)
{
ConnectWayInfo entity = new ConnectWayInfo()
{
ID = (int)reader["ID"],
Name = reader["Name"] as string,
DataLevel = (int)reader["DataLevel"],
CorporationID = (int)reader["CorporationID"],
Sort = DataConvert.SafeInt(reader["Sort"])
};
return entity;
}
public void Add(ConnectWayInfo entity)
{
CommonDataProvider.Instance().AddConnectWay(entity);
}
private void FillData(ConnectWayInfo entity)
{
entity.Name = txtName.Value;
entity.CorporationID = GetInt("corpid");
}
public void Add(ConnectWayInfo entity)
{
CommonDataProvider.Instance().AddConnectWay(entity);
}
public void Update(ConnectWayInfo entity)
{
CommonDataProvider.Instance().UpdateConnectWay(entity);
}
