private void GetEntity(HttpContext context)
{
var manager = new CASE_PRODUCTINFOManager(this.dbProvider, Utils.UserInfo);
string keyId = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("key"));
var entity = manager.GetEntity(keyId);
context.Response.Write(JSONhelper.ToJson(entity));
}
private void GridListJson(HttpContext ctx)
{
var returnJson = "[]";
var manager = new CASE_PRODUCTINFOManager(this.dbHelper, Utils.UserInfo);
var dtTemp = manager.GetDT(20, CASE_PRODUCTINFOTable.FieldMODIFIEDON + " desc");
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
returnJson = JSONhelper.FormatJSONForEasyuiDataGrid(20, dtTemp);
}
ctx.Response.Write(returnJson);
}
private void Delete(HttpContext context)
{
string returnValue = string.Empty;
string msg = RDIFrameworkMessage.MSG3020;
var isSuccess = false;
var vId = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("key"));
if (!string.IsNullOrEmpty(vId))
{
var manager = new CASE_PRODUCTINFOManager(this.dbProvider, Utils.UserInfo);
int returnData = manager.SetDeleted(vId);
if (returnData > 0)
{
msg = RDIFrameworkMessage.MSG0013;
isSuccess = true;
returnValue = returnData.ToString();
}
}
context.Response.Write(new JsonMessage {
Success = isSuccess, Data = returnValue, Message = msg
}.ToString());
}
private void GetPageData(HttpContext context)
{
var pageParam = new PageParam(context);
var manager = new CASE_PRODUCTINFOManager(this.dbProvider);
int recordCount = 0;
string sort = pageParam.SortField;
string order = pageParam.Order;
if (string.IsNullOrEmpty(sort))
{
sort = CASE_PRODUCTINFOTable.FieldCREATEON;
}
if (string.IsNullOrEmpty(order))
{
order = "DESC";
}
string filter = pageParam.Filter;
if (string.IsNullOrEmpty(filter))
{
filter = CASE_PRODUCTINFOTable.FieldDELETEMARK + " = 0 ";
}
UserInfo cUser = Utils.UserInfo;
//string userConstraintExpress = RDIFrameworkService.Instance.TableColumnsService.GetConstraint(cUser, PiUserTable.TableName, cUser.Id, CASE_PRODUCTINFOTable.TableName); //按表约束条件获得数据（按当前用户）。
string userConstraintExpress = RDIFrameworkService.Instance.TableColumnsService.GetUserConstraint(cUser, CASE_PRODUCTINFOTable.TableName); //按表约束条件获得数据(得到用户与角色的约束条件)。
if (!string.IsNullOrEmpty(userConstraintExpress))
{
filter += " AND " + userConstraintExpress;
}
var dtTemp = manager.GetDTByPage(out recordCount, pageParam.PageIndex, pageParam.PageSize, filter, (sort + " " + order));
context.Response.Write(JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dtTemp));
}
private void SubmitForm(HttpContext ctx)
{
try
{
string deleted = PublicMethod.GetString(getObj("deleted"));
string inserted = PublicMethod.GetString(getObj("inserted"));
string updated = PublicMethod.GetString(getObj("updated"));
int returnInsertValue = 0;
int returnUpdateValue = 0;
int returnDeleteValue = 0;
var manager = new CASE_PRODUCTINFOManager(this.dbHelper, Utils.UserInfo);
if (deleted != null)
{
//把json字符串转换成对象
List <CASE_PRODUCTINFOEntity> listDeleted = JsonDeserialize <List <CASE_PRODUCTINFOEntity> >(deleted);
if (listDeleted != null && listDeleted.Count > 0)
{
foreach (CASE_PRODUCTINFOEntity entity in listDeleted)
{
returnDeleteValue += manager.SetDeleted(entity.ID);
}
}
}
if (inserted != null)
{
//把json字符串转换成对象
List <CASE_PRODUCTINFOEntity> listInserted = JsonDeserialize <List <CASE_PRODUCTINFOEntity> >(inserted);
if (listInserted != null && listInserted.Count > 0)
{
foreach (CASE_PRODUCTINFOEntity entity in listInserted)
{
returnInsertValue += string.IsNullOrEmpty(manager.Add(entity)) == true ? 0 : 1;
}
}
}
if (updated != null)
{
//把json字符串转换成对象
List <CASE_PRODUCTINFOEntity> listUpdated = JsonDeserialize <List <CASE_PRODUCTINFOEntity> >(updated);
if (listUpdated != null && listUpdated.Count > 0)
{
foreach (CASE_PRODUCTINFOEntity entity in listUpdated)
{
returnUpdateValue += manager.UpdateEntity(entity);
}
}
}
string message = "操作提示： <br>增加:" + returnInsertValue.ToString() + "条。"
+ " <br>修改:" + returnUpdateValue.ToString() + "条。"
+ " <br>删除:" + returnDeleteValue.ToString() + "条。";
ctx.Response.Write(new JsonMessage {
Success = true, Data = "1", Message = message
}.ToString());
}
catch (Exception ex)
{
ctx.Response.Write(new JsonMessage {
Success = false, Data = "0", Message = "操作失败：" + ex.Message
}.ToString());
}
}
private void SubmitForm(HttpContext context)
{
try
{
string returnValue = string.Empty;
string msg = RDIFrameworkMessage.MSG3020;
var isSuccess = false;
var key = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("key"));
var json = PublicMethod.GetString(WebCommon.StringHelper.GetRequestObject("json"));
UserInfo curUser = Utils.UserInfo;
var entity = JsonHelper.JSONToObject <CASE_PRODUCTINFOEntity>(json);
if (string.IsNullOrEmpty(key)) //增加
{
var manager = new CASE_PRODUCTINFOManager(this.dbProvider, curUser);
returnValue = manager.Add(entity);
if (!string.IsNullOrEmpty(returnValue))
{
msg = RDIFrameworkMessage.MSG0009;
isSuccess = true;
}
context.Response.Write(new JsonMessage {
Success = isSuccess, Data = returnValue, Message = msg
}.ToString());
}
else
{
var manager = new CASE_PRODUCTINFOManager(this.dbProvider, curUser);
var updateEntity = manager.GetEntity(key);
if (updateEntity != null)
{
updateEntity.PRODUCTCODE = entity.PRODUCTCODE;
updateEntity.PRODUCTNAME = entity.PRODUCTNAME;
updateEntity.PRODUCTMODEL = entity.PRODUCTMODEL;
updateEntity.PRODUCTSTANDARD = entity.PRODUCTSTANDARD;
updateEntity.PRODUCTCATEGORY = entity.PRODUCTCATEGORY;
updateEntity.PRODUCTUNIT = entity.PRODUCTUNIT;
updateEntity.MIDDLERATE = entity.MIDDLERATE;
updateEntity.REFERENCECOEFFICIENT = entity.REFERENCECOEFFICIENT;
updateEntity.PRODUCTPRICE = entity.PRODUCTPRICE;
updateEntity.WHOLESALEPRICE = entity.WHOLESALEPRICE;
updateEntity.PROMOTIONPRICE = entity.PROMOTIONPRICE;
updateEntity.INTERNALPRICE = entity.INTERNALPRICE;
updateEntity.SPECIALPRICE = entity.SPECIALPRICE;
updateEntity.ENABLED = entity.ENABLED;
updateEntity.PRODUCTDESCRIPTION = entity.PRODUCTDESCRIPTION;
}
int value = manager.Update(updateEntity);
if (value > 0)
{
msg = RDIFrameworkMessage.MSG0010;
isSuccess = true;
returnValue = value.ToString();
}
context.Response.Write(new JsonMessage {
Success = isSuccess, Data = returnValue, Message = msg
}.ToString());
}
}
catch (Exception ex)
{
context.Response.Write(new JsonMessage {
Success = false, Data = "0", Message = "操作失败：" + ex.Message
}.ToString());
}
}
