private void ItemInfoDialog_Load(object sender, EventArgs e)
{
uploadSetting = UploadHelperClient.GetGGCDocUploadSettingByModuleID(moduleID);
if (uploadSetting != null && uploadSetting.Items != null)
{
UploadSettingItem usiF_VENDER = uploadSetting.Items.Find(delegate(UploadSettingItem usi) { return(usi.Name == "F_VENDER"); });
if (usiF_VENDER == null)
{
usiF_VENDER = new UploadSettingItem();
usiF_VENDER.Name = "F_VENDER";
usiF_VENDER.SheetID = Guid.Empty;
usiF_VENDER.CellName = "北京金舟神创科技发展有限公司(未保存)";
usiF_VENDER.Description = "软件厂家名称";
usiF_VENDER.NeedSetting = false;
uploadSetting.Items.Add(usiF_VENDER);
}
SheetView2.Rows.Count = uploadSetting.Items.Count;
tb_rootName.Text = uploadSetting.Name;
for (int i = 0; i < uploadSetting.Items.Count; i++)
{
SheetView2.Rows[i].Tag = uploadSetting.Items[i].NeedSetting;
SheetView2.Cells[i, 0].Value = uploadSetting.Items[i].Description;
SheetView2.Cells[i, 0].Tag = uploadSetting.Items[i].Name;
SheetView2.Cells[i, 1].Value = uploadSetting.Items[i].CellName;
SheetView2.Cells[i, 1].Tag = uploadSetting.Items[i].SheetID;
}
}
}
private void ButtonOk_Click(object sender, EventArgs e)
{
if (uploadSetting != null)
{
for (int i = 0; i < SheetView2.Rows.Count; i++)
{
Cell cell = SheetView2.Cells[i, 0];
Cell cell2 = SheetView2.Cells[i, 1];
if (cell != null && cell2 != null)
{
UploadSettingItem item = GetSettingItem(cell.Tag.ToString());
if (item != null)
{
item.CellName = cell2.Value.ToString();
item.SheetID = new Guid(cell2.Tag.ToString());
}
}
}
}
String json = Newtonsoft.Json.JsonConvert.SerializeObject(uploadSetting);
if (UploadHelperClient.UpdateGGCDocUploadSetting(moduleID, json))
{
MessageBox.Show("保存成功");
}
else
{
MessageBox.Show("保存失败");
}
}
public String GetDefaultUploadSetting(String moduleID)
{
String result = "";
UploadSetting us = new UploadSetting();
us.Items = new List <UploadSettingItem>();
if (moduleID.ToUpper() == "E77624E9-5654-4185-9A29-8229AAFDD68B")
{
//testroom
us.Name = "TestInfo";
UploadSettingItem item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "TestRoomCode",
Description = "试验室编号",
Name = "F_TRCODE",
NeedSetting = false
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "检测区段",
Name = "F_JCQD",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "通讯地址",
Name = "F_ADDRESS",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "邮编",
Name = "F_POSTCODE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "传真",
Name = "F_FAX",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "联系电话",
Name = "F_TEL",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "母体试验室名称",
Name = "F_MOTHROOM",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "母体试验室认证编号",
Name = "F_MOTHAUTH",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "母体试验室认证有效期’yyyy-mm-dd’",
Name = "F_MOTHVALIDDATE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "本试验室检测项目",
Name = "F_TESTRANGE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "委外机构名称",
Name = "F_WWORG",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "委外机构地址",
Name = "F_WWADDRESS",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "委外资质认证编号",
Name = "F_WWAUTH",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "委外机构认证有效期",
Name = "F_VALIDDATE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "委外机构检测项目",
Name = "F_WWRANGE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "描述信息",
Name = "F_DESC",
NeedSetting = true
};
us.Items.Add(item);
result = Newtonsoft.Json.JsonConvert.SerializeObject(us);
}
else if (moduleID.ToUpper() == "08899BA2-CC88-403E-9182-3EF73F5FB0CE")
{
//person
us.Name = "PERSON";
UploadSettingItem item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "人员姓名",
Name = "F_TRPNAME",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "人员年龄",
Name = "F_TRPAGE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "性别“1”男，“0”女",
Name = "F_TRPSEX",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "专业",
Name = "F_TRPSPECIAL",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "毕业学校",
Name = "F_TRPSCOOL",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "学历",
Name = "F_TRPXL",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "联系电话",
Name = "F_TRPTEL",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "工作时间",
Name = "F_WORKDATE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "技术职称“0”助理工程师，“1”工程师，“2”高级工程师，“3”教授级高工，“4”其它",
Name = "F_JSZC",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "岗位/职务“0”试验室主任，“1”技术负责人，“2”试验员，“3”其它",
Name = "F_ZW",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "从事本工种年限",
Name = "F_POSTIME",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "教育经历",
Name = "F_JYJL",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "工作经历",
Name = "F_GZJL",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "试验室编码",
Name = "F_TRCODE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "身份证号",
Name = "F_IDENTITYCODE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "照片的文件名，没有为空",
Name = "F_PHOTO",
NeedSetting = true
};
us.Items.Add(item);
result = Newtonsoft.Json.JsonConvert.SerializeObject(us);
}
else
{
//test document
us.Name = "REP";
UploadSettingItem item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "试验室编码[按照统一编码]",
Name = "F_TRCODE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "报告类型[按照统一编码]",
Name = "F_RTCODE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "委托编号",
Name = "F_WTBH",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "试验报告编号",
Name = "F_BGBH",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "试验报告名称",
Name = "F_BGMC",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "表号",
Name = "F_BH",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "批准文号",
Name = "F_PZWH",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "报告日期[格式为yyyy-mm-dd]",
Name = "F_BGRQ",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "样品编号",
Name = "F_YPBH",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "记录编号",
Name = "F_JLBH",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "生产批号[如果报告表头无此项为空]",
Name = "F_SCPH",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "委托单位",
Name = "F_WTDW",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "工程名称",
Name = "F_GCMC",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "施工部位",
Name = "F_SGBW",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "试验对象等级[用于区分试验对象的等级和规格品类。例如：混凝土：强度等级；金属材料：规格型号；砂石：规格种类]",
Name = "F_DXDJ",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "代表数量",
Name = "F_DBSL",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "代表数量对应的计量单位",
Name = "F_DW",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "样品产地[没有的为空]",
Name = "F_YPCD",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "是否合格[1合格，0不合格]",
Name = "F_SFHG",
NeedSetting = false
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "报告类型[0自检，1见证，2监理平检，3其它]",
Name = "F_BGZT",
NeedSetting = false
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "试验结论",
Name = "F_SYJL",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "不合格项目[“名称_标准规定值_项目实测值^名称_标准规定值_项目实测值”， 名称、标准规定值和项目实测值间以英文”_”分隔多项不合格，信息以“^”分隔，无不合格信息的此项为空]",
Name = "F_BHGX",
NeedSetting = false
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "涉及的试验仪器 ‘0’默认：不涉及,’1’：涉及压力机‘2’：涉及万能机",
Name = "F_DEVTYPE",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "厂商名称",
Name = "F_SOFTCOM",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "试验人",
Name = "F_SYR",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "复核人",
Name = "F_FHR",
NeedSetting = true
};
us.Items.Add(item);
item = new UploadSettingItem()
{
SheetID = Guid.Empty,
CellName = "",
Description = "数字版本号，新上传默认版本号为1，再次上传版本号为上版本号+1，版本号由上传端控制，接收端不做合理性判断",
Name = "F_NEWVERSION",
NeedSetting = false
};
us.Items.Add(item);
result = Newtonsoft.Json.JsonConvert.SerializeObject(us);
}
result = result.Replace("'", "''");
return(result);
}
