public static List <EnumInfoModel> GetEnumInfo(Action <CommandFilter> match)
{
var command = _dbBaseProvider.CreateCommandStruct("EnumInfo", CommandMode.Inquiry);
command.Columns = "Id,SlnID,enumName,enumDescription,enumValueInfo";
command.OrderBy = "enumName ASC,Id ASC";
command.Filter = _dbBaseProvider.CreateCommandFilter();
if (match != null)
{
match(command.Filter);
}
command.Parser();
var list = new List <EnumInfoModel>();
using (var reader = _dbBaseProvider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters))
{
while (reader.Read())
{
EnumInfoModel model = new EnumInfoModel();
model.ID = reader["ID"].ToInt();
model.SlnID = reader["SlnID"].ToInt();
model.enumName = reader["enumName"].ToNotNullString();
model.enumDescription = reader["enumDescription"].ToNotNullString();
model.enumValueInfo = reader["enumValueInfo"].ToNotNullString();
list.Add(model);
}
}
return(list);
}
private static EnumInfoModel GetInfo(Enum @enum, string langue, string directory)
{
EnumInfoModel m = null;
if (string.IsNullOrEmpty(langue))
{
langue = System.Globalization.CultureInfo.CurrentCulture.Name;
}
if (string.IsNullOrEmpty(directory))
{
directory = Directory.GetCurrentDirectory();
}
var dic = GetLangueDic(langue);
if (dic != null)
{
var type = @enum.GetType();
var name = @enum.GetName();
List <EnumInfoModel> list = null;
if (!dic.TryGetValue(type, out list))
{
dic[type] = list = GetTypeInfo(type, langue, directory);
}
m = list.Find(q => string.Equals(q.Name, name, StringComparison.OrdinalIgnoreCase));
}
return(m);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
if (!string.IsNullOrEmpty(Request["enum"]))
{
string enumName = Request["enum"].Trim(new char[] { '【', '】' });
txtName.Text = enumName;
EnumInfoModel info = DbDataLoader.GetEnumInfo(SlnID, enumName).FirstOrDefault();
if (info != null)
{
txtDescription.Text = info.enumDescription;
txtValueInfo.Text = info.enumValueInfo;
AddorEditMode(true);
EditKey.Text = info.ID.ToString();
}
else
{
txtName.Text = enumName;
AddorEditMode(false);
}
}
}
}
protected void GridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id = int.Parse(e.CommandArgument.ToString());
switch (e.CommandName)
{
case "sel":
{
EnuminfoBLL con = new EnuminfoBLL();
EnumInfoModel info = con.GetModel(id);
txtName.Text = info.enumName;
txtDescription.Text = info.enumDescription;
txtValueInfo.Text = info.enumValueInfo;
AddorEditMode(true);
EditKey.Text = e.CommandArgument.ToString();
}
break;
case "del":
{
EnuminfoBLL con = new EnuminfoBLL();
con.Delete(id);
Bind();
}
break;
}
}
protected void GridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id = int.Parse(e.CommandArgument.ToString());
switch (e.CommandName)
{
case "sel":
{
EnumInfoModel info = DbDataLoader.GetEnumInfo(f =>
{
f.Condition = f.FormatExpression("ID");
f.AddParam("ID", id);
}).FirstOrDefault();
txtName.Text = info.enumName;
txtDescription.Text = info.enumDescription;
txtValueInfo.Text = info.enumValueInfo;
AddorEditMode(true);
EditKey.Text = e.CommandArgument.ToString();
}
break;
case "del":
{
DbDataLoader.Delete(new EnumInfoModel()
{
ID = id
});
Bind();
}
break;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EnumInfoModel GetModel(string enumName, string slnid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id, slnid, enumName,enumDescription,enumValueInfo from enuminfo");
strSql.Append(" where enumName=@enumName and slnid=@slnid");
SqlParameter[] parameters =
{
new SqlParameter("@enumName", SqlDbType.VarChar, 500),
new SqlParameter("@slnid", SqlDbType.Int, 4)
};
parameters[0].Value = enumName;
parameters[1].Value = slnid;
SqlDataReader dr = SqlHelper.ExecuteReader(connectionString, CommandType.Text, strSql.ToString(), parameters);
if (dr.Read())
{
EnumInfoModel model = new EnumInfoModel();
model.enumDescription = dr["enumDescription"].ToString();
model.enumName = enumName;
model.enumValueInfo = dr["enumValueInfo"].ToString();
model.ID = int.Parse(dr["id"].ToString());
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EnumInfoModel GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 enumName,enumDescription,enumValueInfo from enuminfo");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
};
parameters[0].Value = ID;
SqlDataReader dr = SqlHelper.ExecuteReader(connectionString, CommandType.Text, strSql.ToString(), parameters);
if (dr.Read())
{
EnumInfoModel model = new EnumInfoModel();
model.enumDescription = dr["enumDescription"].ToString();
model.enumName = dr["enumName"].ToString();
model.enumValueInfo = dr["enumValueInfo"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EnumInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into enuminfo(");
strSql.Append("SlnID,enumName,enumDescription,enumValueInfo)");
strSql.Append(" values (");
strSql.Append("@SlnID,@enumName,@enumDescription,@enumValueInfo)");
SqlParameter[] parameters =
{
new SqlParameter("@SlnID", SqlDbType.Int, 4),
new SqlParameter("@enumName", SqlDbType.VarChar, 50),
new SqlParameter("@enumDescription", SqlDbType.VarChar, 200),
new SqlParameter("@enumValueInfo", SqlDbType.VarChar, 2000)
};
parameters[0].Value = model.SlnID;
parameters[1].Value = model.enumName;
parameters[2].Value = model.enumDescription;
parameters[3].Value = model.enumValueInfo;
int rows = SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>enumName,enumDescription,enumValueInfo
public bool Update(EnumInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update enuminfo set ");
strSql.Append("enumName=@enumName,");
strSql.Append("enumDescription=@enumDescription,");
strSql.Append("enumValueInfo=@enumValueInfo");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@enumName", SqlDbType.VarChar, 50),
new SqlParameter("@enumDescription", SqlDbType.VarChar, 500),
new SqlParameter("@enumValueInfo", SqlDbType.VarChar, 2000),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.enumName;
parameters[1].Value = model.enumDescription;
parameters[2].Value = model.enumValueInfo;
parameters[3].Value = model.ID;
int rows = SqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool Delete(EnumInfoModel model)
{
var command = _dbBaseProvider.CreateCommandStruct("EnumInfo", CommandMode.Delete);
command.Filter = _dbBaseProvider.CreateCommandFilter();
command.Filter.Condition = _dbBaseProvider.FormatFilterParam("ID");
command.Filter.AddParam("ID", model.ID);
command.Parser();
return(_dbBaseProvider.ExecuteQuery(CommandType.Text, command.Sql, command.Parameters) > 0);
}
public static int Add(EnumInfoModel model)
{
var command = _dbBaseProvider.CreateCommandStruct("EnumInfo", CommandMode.Insert);
command.AddParameter("SlnID", model.SlnID);
command.AddParameter("enumName", model.enumName);
command.AddParameter("enumDescription", model.enumDescription);
command.AddParameter("enumValueInfo", model.enumValueInfo);
command.Parser();
return(_dbBaseProvider.ExecuteQuery(CommandType.Text, command.Sql, command.Parameters));
}
public static bool Update(EnumInfoModel model)
{
var command = _dbBaseProvider.CreateCommandStruct("EnumInfo", CommandMode.Modify);
command.AddParameter("enumName", model.enumName);
command.AddParameter("enumDescription", model.enumDescription);
command.AddParameter("enumValueInfo", model.enumValueInfo);
command.Filter = _dbBaseProvider.CreateCommandFilter();
command.Filter.Condition = _dbBaseProvider.FormatFilterParam("ID");
command.Filter.AddParam("ID", model.ID);
command.Parser();
return(_dbBaseProvider.ExecuteQuery(CommandType.Text, command.Sql, command.Parameters) > 0);
}
protected void butSubmit_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(EditKey.Text))
{
try
{
EnuminfoBLL con = new EnuminfoBLL();
EnumInfoModel model = new EnumInfoModel();
model.enumName = txtName.Text;
model.enumDescription = txtDescription.Text;
model.enumValueInfo = txtValueInfo.Text;
model.SlnID = SlnID;
if (con.Add(model))
{
Bind();
btCancelButton_Click(null, null);
return;
}
}
catch (Exception ex)
{
Page.RegisterStartupScript("", "<script language=javascript>alert('添加失败！')</script>");
}
}
else
{
try
{
EnuminfoBLL con = new EnuminfoBLL();
EnumInfoModel model = new EnumInfoModel();
model.enumName = txtName.Text;
model.enumDescription = txtDescription.Text;
model.enumValueInfo = txtValueInfo.Text;
model.SlnID = SlnID;
model.ID = int.Parse(EditKey.Text);
if (con.Update(model))
{
Bind();
btCancelButton_Click(null, null);
return;
}
}
catch (Exception ex)
{
Page.RegisterStartupScript("", "<script language=javascript>alert('编辑失败！')</script>");
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EnumInfoModel model)
{
return(dal.Update(model));
}
