protected void btnSubmit_Click(object sender, EventArgs e)
{
if (ddlCategory.SelectedValue != "0")
{
SystemConfigInfo info = new SystemConfigInfo();
info.sc_Class = ddlCategory.SelectedValue;
info.sc_Name = txtName.Text;
info.sc_Value = rbShow.SelectedValue;
info.sc_Desc = txtdetail.Text;
if (SystemConfigBLL.getDataByClassWithName(info.sc_Class, info.sc_Name) == string.Empty)
{
if (scBLL.Insert(info) > 0)
{
ShowMessage("新增功能控制項:" + txtName.Text + " 成功");
}
}
else
{
ShowMessage("資料表中已有此類別與功能紀錄");
}
}
else
{
ShowMessage("請選擇主項目");
}
}
public async Task <IHttpActionResult> Put(SystemConfigInfo info)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
info.UpdateTime = DateTime.Now;
GlobalApplicationObject.Current.ApplicationContext.ConfigManager.SaveConfig <SystemConfigInfo>(info);
return(Ok(info));
}
public async Task <IHttpActionResult> Post(SystemConfigInfo info)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
info.UpdateTime = DateTime.Now;
ApplicationContext.ConfigManager.SaveConfig <SystemConfigInfo>(info);
return(Created <SystemConfigInfo>("api/config/SystemConfigInfo", info));
}
public SystemConfigInfo getAll(int id)
{
SystemConfigInfo info = new SystemConfigInfo();
IDataReader reader = db.GetDataById(id).CreateDataReader();
while (reader.Read())
{
info = SystemConfigInfo.Populate(reader);
}
return(info);
}
public List <SystemConfigInfo> GetDataSelectDistinctOrderClass()
{
List <SystemConfigInfo> infos = new List <SystemConfigInfo>();
IDataReader reader = db.GetDataSelectDistinctOrderClass().CreateDataReader();
while (reader.Read())
{
infos.Add(SystemConfigInfo.Populate(reader));
}
return(infos);
}
public List <SystemConfigInfo> getAll()
{
List <SystemConfigInfo> infos = new List <SystemConfigInfo>();
IDataReader reader = db.GetData().CreateDataReader();
while (reader.Read())
{
infos.Add(SystemConfigInfo.Populate(reader));
}
return(infos);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SystemConfigInfo DataRowToModel(DataRow row)
{
var model = new SystemConfigInfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["sysCode"] != null)
{
model.sysCode = row["sysCode"].ToString();
}
if (row["sysName"] != null)
{
model.sysName = row["sysName"].ToString();
}
if (row["sysValue"] != null)
{
model.sysValue = row["sysValue"].ToString();
}
if (row["sysTypeId"] != null && row["sysTypeId"].ToString() != "")
{
model.sysTypeId = int.Parse(row["sysTypeId"].ToString());
}
if (row["sysTypeName"] != null)
{
model.sysTypeName = row["sysTypeName"].ToString();
}
if (row["createDate"] != null && row["createDate"].ToString() != "")
{
model.createDate = DateTime.Parse(row["createDate"].ToString());
}
if (row["parentId"] != null && row["parentId"].ToString() != "")
{
model.parentId = int.Parse(row["parentId"].ToString());
}
if (row["remark"] != null)
{
model.remark = row["remark"].ToString();
}
if (row["sort_id"] != null && row["sort_id"].ToString() != "")
{
model.sort_id = int.Parse(row["sort_id"].ToString());
}
}
return(model);
}
public static string getDataByClassWithName(string className, string name)
{
SystemConfigTableAdapter db = new SystemConfigTableAdapter();
string result = "";
IDataReader reader = db.GetDataByClassWithName(className, name).CreateDataReader();
SystemConfigInfo info = new SystemConfigInfo();
while (reader.Read())
{
info = SystemConfigInfo.Populate(reader);
}
if (info.sc_Id != 0)
{
result = info.sc_Value;
}
return(result);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <SystemConfigInfo> DataTableToList(DataTable dt)
{
var modelList = new List <SystemConfigInfo>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
SystemConfigInfo model = null;
for (int n = 0; n < rowsCount; n++)
{
model = this._repository.DataRowToModel(dt.Rows[n]);
if (model != null)
{
modelList.Add(model);
}
}
}
return(modelList);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
bool isEdit = false;
foreach (RepeaterItem item in RepeaterSysConfig.Items)
{
CheckBox ckSelect = (CheckBox)item.FindControl("ckSelect");
if (ckSelect.Checked)
{
Literal lId = (Literal)item.FindControl("lId");
int id = int.Parse(lId.Text);
SystemConfigInfo info = sysConfigBLL.getAll(id);
TextBox txtClass = (TextBox)item.FindControl("txtCalss");
TextBox txtName = (TextBox)item.FindControl("txtName");
TextBox txtValue = (TextBox)item.FindControl("txtValue");
TextBox txtDesc = (TextBox)item.FindControl("txtDesc");
info.sc_Class = txtClass.Text;
info.sc_Name = txtName.Text;
info.sc_Value = txtValue.Text;
info.sc_Desc = txtDesc.Text;
if (sysConfigBLL.Update(info) > 0)
{
isEdit = true;
}
}
}
if (isEdit)
{
Tools.Show(this.Page, "修改完成!");
}
else
{
Tools.Show(this.Page, "修改失敗");
}
Bind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
int checkcount = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
HiddenField hi_Id = (HiddenField)GridView1.Rows[i].FindControl("HiddenField_Id");
CheckBox chkvalue = (CheckBox)GridView1.Rows[i].FindControl("chk_value");
TextBox TextBox_Desc = (TextBox)GridView1.Rows[i].FindControl("TextBox_Desc");
SystemConfigInfo info = scBLL.getAll(int.Parse(hi_Id.Value));
if (info.sc_Id != 0)
{
info.sc_Admin = uid;
info.sc_Desc = TextBox_Desc.Text;
info.sc_Value = chkvalue.Checked.ToString().ToLower();
if (scBLL.Update(info) > 0)
{
checkcount++;
}
}
}
ShowMessage("資料 " + checkcount + " 筆: 修改成功");
}
static void CreateTestData_SystemConfig()
{
StreamReader fileStream = new StreamReader(@"D:\TempCode\Console\ConsoleAppSqlite\ConsoleAppSqlite\file\福利待遇.txt", Encoding.Default);
var data = fileStream.ReadToEnd();
var repo = new Repository <SystemConfigInfo>();
var info = new SystemConfigInfo()
{
Code = SystemKey.WelfareKey,
Name = "福利待遇",
Value = data
};
repo.Insert(info);
fileStream.Close();
info = new SystemConfigInfo()
{
Code = SystemKey.Logo,
Name = "logo",
Value = "/images/logo.png"
};
repo.Insert(info);
List <string> qr = new List <string>();
qr.Add("/images/QRCode/QRCode-筑加网.jpg");
qr.Add("/images/QRCode/QRCode-筑加网.jpg");
var value = Newtonsoft.Json.JsonConvert.SerializeObject(qr);
info = new SystemConfigInfo()
{
Code = SystemKey.QRCode,
Name = "QRCode",
Value = value
};
repo.Insert(info);
}
public int Update(SystemConfigInfo info)
{
return(db.Update(info.sc_Class, info.sc_Name, info.sc_Value, info.sc_DefaultValue, info.sc_Desc, info.sc_Admin, info.sc_enable, info.sc_adminenable, info.sc_ts, info.sc_Id));
}
public int Insert(SystemConfigInfo info)
{
return(db.Insert(info.sc_Class, info.sc_Name, info.sc_Value, info.sc_DefaultValue, info.sc_Desc, info.sc_Admin, info.sc_enable, info.sc_adminenable, info.sc_ts));
}
