会python真的可以为所欲为0(回)
353天前
这里还有人吗1(回)
538天前这里还有人吗0(回)
538天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
763天前到处都是羊，不想上班0(回)
843天前
鸽子
0(回)
847天前 Ext.Ajax.request({ |
waitMsg: '正在查询主表数据...', |
url: '/Import/approval/GetData', |
params: { |
handle: opstatus, |
condition: condition |
}, |
callback: function (options, success, response) { |
if (success) { |
var result = Ext.JSON.decode(response.responseText); |
if (!result.Success) { |
Ext.Msg.show({ |
title: '提示', |
msg: result.Message, |
icon: Ext.MessageBox.ERROR, |
buttons: Ext.Msg.OK |
}); |
return; |
} |
var data = result.data; |
this.formEdit.getForm().reset(); |
// if (data.ex_ == "") { data.OilLrDate = currdate.format('yyyy-MM-dd') }; |
this.formEdit.getForm().setValues(data); |
var sql = 'app_id=' + data.id; |
if (this.opStatus != 'add') { |
this.storeUsing.load({ |
params: { start: 0, limit: 500, sort: '', condition: sql }, |
//params: { condition: sql }, |
waitMsg: "正在查询数据...", |
scope: this |
}); |
} |
} else { |
Ext.MessageBox.alert('请求出现错误,请重试', response.responseText); |
} |
}, |
scope: this |
}); |
=============================================== |
public ContentResult GetData(string handle, string condition) |
{ |
approvalmb head = null; |
if (handle == "edit") |
{ |
var list = approvalDAL.GetDataList(condition); |
if (list.Count > 0) |
head = list[0]; |
} |
if (head == null) |
{ |
head = new approvalmb(); |
} |
var json = JsonConvert.Serialize( |
new { Success = true, Message = "查询成功", data = head }); |
return new ContentResult() { Content = json }; |
} |
public ContentResult GetDataList(int start, int limit, string sort, string condition) |
{ |
var dataList = approvalDAL.GetDataList(condition); |
var list = dataList.Skip(start).Take(limit); |
var json = JsonConvert.Serialize(new { Success = true, Message = "查询成功", totalCount = dataList.Count, data = list.ToList() }); |
return new ContentResult() { Content = json }; |
} |
// |
// GET：/Import/approval/GetData/ |
static public List<approvalmb> GetDataList(string strCondition) |
{ |
var strSql = new StringBuilder(); |
strSql.Append(" SELECT a.*,cp.name companyname, "); |
strSql.Append(" c.country,u.used,u.selected, u.remain,u.canbeused, "); |
strSql.Append(" ci.code,ci.name,ciq.ciqcode,ciq.ciqname, "); |
strSql.Append(" (select EnumValueName from tSysEnumValue "); |
strSql.Append(" where LangId=0 and EnumTypeID=10 and EnumValueID=a.SLJG) as portRef, "); |
strSql.Append(" (select EnumValueName from tSysEnumValue "); |
strSql.Append(" where LangId=0 and EnumTypeID=0 and EnumValueID=a.isdeleted) as isdeletedRef "); |
strSql.Append(" FROM [Import_approval] a "); |
strSql.Append(" left join import_cargoinfo ci on ci.id=a.cargoinfo_id "); |
strSql.Append(" left join code_country c on a.[Countryid]=c.[Countryid] "); |
strSql.Append(" left join vMsAppUsed U on U.[app_id]=a.[id] "); |
strSql.Append(" left join import_cargociq ciq on ciq.id=a.cargociq_id "); |
strSql.Append(" left join company cp on cp.gid=a.company "); |
if (!string.IsNullOrEmpty(strCondition)) |
{ |
strSql.Append(" where " + strCondition); |
} |
return SetData(strSql); |
} |
private static List<approvalmb> SetData(StringBuilder strSql) |
{ |
var headList = new List<approvalmb>(); |
Database db = DatabaseFactory.CreateDatabase(); |
using (IDataReader reader = db.ExecuteReader(CommandType.Text, strSql.ToString())) |
{ |
while (reader.Read()) |
{ |
approvalmb data = new approvalmb(); |
#region Set DB data to Object |
data.id = Convert.ToString(reader["id"]); |
data.gid = Convert.ToString(reader["gid"]); |
data.APPNO = Convert.ToString(reader["APPNO"]); |
data.SQDH = Convert.ToString(reader["SQDH"]); |
data.SLJG = Convert.ToString(reader["SLJG"]); |
data.portRef = Convert.ToString(reader["portRef"]); |
data.Countryid = Convert.ToString(reader["Countryid"]); |
data.Country = Convert.ToString(reader["Country"]); |
data.Weight = Convert.ToString(reader["Weight"]); |
data.used = Convert.ToString(reader["used"]); |
data.selected = Convert.ToString(reader["selected"]); |
data.remain = Convert.ToString(reader["remain"]); |
data.canbeused = Convert.ToString(reader["canbeused"]); |
data.ValidDate = Convert.ToString(reader["ValidDate"]); |
data.cargoinfo_id = Convert.ToString(reader["cargoinfo_id"]); |
data.cargociq_id = Convert.ToString(reader["cargociq_id"]); |
data.AppName = Convert.ToString(reader["AppName"]); |
data.code = Convert.ToString(reader["code"]); |
data.name = Convert.ToString(reader["name"]); |
data.ciqcode = Convert.ToString(reader["ciqcode"]); |
data.ciqname = Convert.ToString(reader["ciqname"]); |
data.isdeletedRef = Convert.ToString(reader["isdeletedRef"]); |
data.isdeleted = Convert.ToString(reader["isdeleted"]); |
data.company = Convert.ToString(reader["company"]); |
data.companyname = Convert.ToString(reader["companyname"]); |
data.depot = Convert.ToString(reader["depot"]); |
data.usedweight = Convert.ToString(reader["usedweight"]); |
data.JustWriteoffs = Convert.ToString(reader["JustWriteoffs"]); |
data.REMARK = Convert.ToString(reader["REMARK"]); |
#endregion |
headList.Add(data); |
} |
reader.Close(); |
} |
return headList; |
} |
