public String ajax_MasterUpdata(m_Users md)
{
ReturnAjaxInfo rAjaxResult = new ReturnAjaxInfo();
ac = new a_Users()
{
Connection = getSQLConnection()
};
if (md.EditType == EditModeType.Insert)
{ //新增
RunInsertEnd HResult = ac.InsertMaster(md, LoginUserId);
rAjaxResult = HandleResultAjaxFiles(HResult, Resources.Res.Data_Insert_Success);
rAjaxResult.id = HResult.InsertId;
}
else
{
//修改
RunEnd HResult = ac.UpdateMaster(md, LoginUserId);
rAjaxResult = HandleResultAjaxFiles(HResult, Resources.Res.Data_Update_Success);
rAjaxResult.id = md.id;
}
return(JsonConvert.SerializeObject(rAjaxResult, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore
}));
}
public String GetFilesList(String master_value)
{
Dictionary <String, String> dic = new Dictionary <String, String>();
//String BasePath = Request.PhysicalApplicationPath;
String BasePath = Server.MapPath("~/");
ReturnAjaxInfo rAjaxResult = new ReturnAjaxInfo();
try
{
String[] Files = Directory.GetFiles(BasePath + master_value);
foreach (String S in Files)
{
FileInfo Fi = new FileInfo(S);
dic.Add(Fi.Name, Fi.FullName.Replace(BasePath, ""));
}
rAjaxResult.result = true;
//rAjaxResult.data = dic;
}
catch (Exception ex)
{
rAjaxResult.result = false;
rAjaxResult.message = ex.Message;
}
JavaScriptSerializer js = new JavaScriptSerializer()
{
MaxJsonLength = 65536
}; //64K
return(js.Serialize(rAjaxResult));
}
public String ajax_UpdateUnitData(m_PowerUnit md)
{
ReturnAjaxInfo rAjaxResult = new ReturnAjaxInfo();
a_PowerUnit ac = new a_PowerUnit() { Connection = getSQLConnection(), logPlamInfo = plamInfo };
RunUpdateEnd r = ac.UpdateMaster(md, LoginUserId.ToString());
if (!r.Result)
rAjaxResult.message = r.Message;
return JsonConvert.SerializeObject(rAjaxResult, new JsonSerializerSettings() { NullValueHandling = NullValueHandling.Ignore });
}
public override String ajax_MasterDeleteData(String id)
{
String[] deleteID = id.Split(',');
ReturnAjaxInfo rAjaxResult = new ReturnAjaxInfo();
ac = new a_Unit();
ac.Connection = getSQLConnection();
RunDeleteEnd HResult = ac.DeleteMaster(deleteID, LoginUserId);
rAjaxResult = HandleResultAjaxFiles(HResult, Resources.Res.Data_Delete_Success);
return(JsonConvert.SerializeObject(rAjaxResult, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore
}));
}
public String ajax_UpdateUnitData(m_PowerUnit md)
{
ReturnAjaxInfo rAjaxResult = new ReturnAjaxInfo();
a_PowerUnit ac = new a_PowerUnit()
{
Connection = getSQLConnection(), logPlamInfo = plamInfo
};
RunUpdateEnd r = ac.UpdateMaster(md, LoginUserId.ToString());
if (!r.Result)
{
rAjaxResult.message = r.Message;
}
return(JsonConvert.SerializeObject(rAjaxResult, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore
}));
}
public String ajax_MasterDeleteData()
{
String[] deleteID = Request.Form["id"].Split(',');
ReturnAjaxInfo rAjaxResult = new ReturnAjaxInfo();
ac = new a_Users()
{
Connection = getSQLConnection()
};
RunDeleteEnd HResult = ac.DeleteMaster(deleteID, 0);
rAjaxResult = HandleResultAjaxFiles(HResult, Resources.Res.Data_Delete_Success);
return(JsonConvert.SerializeObject(rAjaxResult, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore
}));
}
public String ajax_MasterUpdataPassword(Password md)
{
ReturnAjaxInfo rAjaxResult = new ReturnAjaxInfo();
ac = new a_Users()
{
Connection = getSQLConnection()
};
//修改
md.id = LoginUserId;
RunEnd HResult = ac.UpdateMasterPassword(md, LoginUserId.ToString());
rAjaxResult = HandleResultAjaxFiles(HResult, Resources.Res.Data_Update_Success);
rAjaxResult.id = md.id;
return(JsonConvert.SerializeObject(rAjaxResult, new JsonSerializerSettings()
{
NullValueHandling = NullValueHandling.Ignore
}));
}
public String ajax_SQLExecute(String SQL)
{
ReturnAjaxInfo rAjaxResult = new ReturnAjaxInfo();
JavaScriptSerializer js = new JavaScriptSerializer()
{
MaxJsonLength = 65536
}; //64K
String r = String.Empty;
try
{
DataTable dt = getSQLConnection().ExecuteData(SQL);
List <String> ColumnName = new List <String>();
foreach (DataColumn dc in dt.Columns)
{
ColumnName.Add(dc.ColumnName);
}
List <String[]> Rows = new List <String[]>();
foreach (DataRow dr in dt.Rows)
{
List <String> Cells = new List <String>();
for (int i = 0; i < dt.Columns.Count; i++)
{
Cells.Add(dr[i].ToString());
}
Rows.Add(Cells.ToArray());
}
r = js.Serialize(new { Columns = ColumnName.ToArray(), DataItems = Rows.ToArray(), result = true, message = "" });
}
catch (Exception ex)
{
r = js.Serialize(new { result = false, message = ex.Message });
}
return(r);
}
public String GetFilesList(String master_value)
{
Dictionary<String, String> dic = new Dictionary<String, String>();
//String BasePath = Request.PhysicalApplicationPath;
String BasePath = Server.MapPath("~/");
ReturnAjaxInfo rAjaxResult = new ReturnAjaxInfo();
try
{
String[] Files = Directory.GetFiles(BasePath + master_value);
foreach (String S in Files)
{
FileInfo Fi = new FileInfo(S);
dic.Add(Fi.Name, Fi.FullName.Replace(BasePath, ""));
}
rAjaxResult.result = true;
//rAjaxResult.data = dic;
}
catch (Exception ex)
{
rAjaxResult.result = false;
rAjaxResult.message = ex.Message;
}
JavaScriptSerializer js = new JavaScriptSerializer() { MaxJsonLength = 65536 }; //64K
return js.Serialize(rAjaxResult);
}
public String ajax_SQLExecute(String SQL)
{
ReturnAjaxInfo rAjaxResult = new ReturnAjaxInfo();
JavaScriptSerializer js = new JavaScriptSerializer() { MaxJsonLength = 65536 }; //64K
String r = String.Empty;
try
{
DataTable dt = getSQLConnection().ExecuteData(SQL);
List<String> ColumnName = new List<String>();
foreach (DataColumn dc in dt.Columns)
{
ColumnName.Add(dc.ColumnName);
}
List<String[]> Rows = new List<String[]>();
foreach (DataRow dr in dt.Rows)
{
List<String> Cells = new List<String>();
for (int i = 0; i < dt.Columns.Count; i++)
{
Cells.Add(dr[i].ToString());
}
Rows.Add(Cells.ToArray());
}
r = js.Serialize(new { Columns = ColumnName.ToArray(), DataItems = Rows.ToArray(), result = true, message = "" });
}
catch (Exception ex)
{
r = js.Serialize(new { result = false, message = ex.Message });
}
return r;
}
