public List<ps_gt> GetGtList(string xlcode) {
List<ps_gt> list = new List<ps_gt>();
IList<PS_gt> list2 = Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>("where LineCode='" + xlcode + "'");
foreach (PS_gt gt in list2) {
ps_gt psgt = new ps_gt() {
LineCode = gt.LineCode,
gtCode = gt.gtCode, gtElev = gt.gtElev.ToString(), gtHeight = gt.gtHeight.ToString(),
gth = gt.gth, gtID = gt.gtID, gtLat = gt.gtLat.ToString(), gtLon = gt.gtLon.ToString(), gtSpan = gt.gtJg,
gtModle = gt.gtModle, gtType = gt.gtType.ToString()
};
list.Add(psgt);
psgt.jsonData = getjsonData(gt.gtID);
}
return list;
}
public string UpdateGtOne(ps_gt data) {
PS_gt gt = Ebada.Client.ClientHelper.PlatformSqlMap.GetOneByKey<PS_gt>(data.gtID);
if (gt != null) {
//foreach(FieldInfo fi in data.GetType().GetFields()){
// try {
// gt.GetType().GetProperty(fi.Name).SetValue(gt, fi.GetValue(data), null);
// } catch { }
//}
gt.gtType = data.gtType;
gt.gtModle = data.gtModle;
gt.gtElev = (int)decimal.Parse(data.gtElev);
gt.gtLat = decimal.Parse(data.gtLat);
gt.gtLon = decimal.Parse(data.gtLon);
gt.gtHeight = decimal.Parse(data.gtHeight);
gt.gtJg = data.gtSpan == "是" ? "是" : "否";//借杆
if ((gt.gtLat + gt.gtLon) > 0) {
int n = Ebada.Client.ClientHelper.PlatformSqlMap.Update<PS_gt>(gt);
ncount += n;
}
if (data.jsonData != null) {
Console.WriteLine(data.jsonData);
List<ps_gtsb> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ps_gtsb>>(data.jsonData);
if (list != null) {
List<SqlQueryObject> sqllist = new List<SqlQueryObject>();
SqlQueryObject sqo = new SqlQueryObject(SqlQueryType.Delete, "Delete", "delete from ps_gtsb where gtid='" + gt.gtID + "'");
sqllist.Add(sqo);
int num = 0;
foreach (ps_gtsb sb in list) {
num++;
PS_gtsb gtsb = new PS_gtsb() { gtID = gt.gtID, sbModle = sb.xh, sbType = sb.zldm, sbNumber = short.Parse(sb.sl), sbName = sb.zl, sbCode = num.ToString("000") };
gtsb.sbID = gt.gtID + num.ToString("000");
sqo = new SqlQueryObject(SqlQueryType.Insert, gtsb);
sqllist.Add(sqo);
}
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(sqllist);
}
//Console.WriteLine(list != null ? list.Count : 0);
}
//Console.WriteLine("update {0} count {1}", gt.gtCode, n);
}
return "";
}
