public JZDocument GetDefaultDocument(Guid moduleID)
{
String sql = @"SELECT a.ID,b.SheetID,c.SheetData,c.Name FROM dbo.sys_module a
JOIN dbo.sys_module_sheet b ON a.ID = b.ModuleID
JOIN dbo.sys_sheet c ON b.SheetID = c.ID where a.ID='" + moduleID + "' order by b.SortIndex";
JZDocument doc = new JZDocument();
try
{
DataTable dt = GetDataTable(sql);
if (dt != null && dt.Rows.Count > 0)
{
doc.ID = Guid.Empty;
foreach (DataRow row in dt.Rows)
{
JZSheet sheet = new JZSheet();
sheet.ID = new Guid(row["SheetID"].ToString());
sheet.Name = row["Name"].ToString();
sheet.Cells = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZCell> >(row["SheetData"].ToString());
doc.Sheets.Add(sheet);
}
}
}
catch (Exception e)
{
logger.Error(e.Message);
}
return(doc);
}
public object GetCellValue(JZSheet sheet, string name)
{
if (string.IsNullOrEmpty(name) || sheet == null)
{
return(null);
}
foreach (var cell in sheet.Cells)
{
if (cell.Name.ToLower() == name.ToLower())
{
return(cell.Value);
}
}
return(null);
}
public void NewRegisterion(DataRow row, JZSheet sheet, List <ModuleSetting> setting, string[] maps)
{
var offset = Offset;
var cells = GroupCells(sheet.Cells);
foreach (string key in cells.Keys)
{
if (Convert.ToInt32(key) < Offset)
{
continue;
}
var datas = Template;
var id = Guid.NewGuid();
var values = ConvertRow(row);
var counter = 0;
foreach (var c in cells[key])
{
for (var i = 0; i < maps.Length; i += 2)
{
if (c.Name[0].ToString().ToLower() == maps[i].ToLower())
{
var value = c.Value;
var newc = maps[i + 1];
var location = "{#" + newc + "}";
if (value == null)
{
datas = datas.Replace(location, "");
}
else
{
datas = datas.Replace(location, Convert.ToString(value));
var set = setting.Find(m => m.CellName.ToLower() == newc);
if (set != null)
{
values[set.DocColumn] = value;
}
counter++;
}
}
}
}
if (counter > 0)
{
datas = datas.Replace("{#id}", id.ToString());
//datas = datas.Replace("{#line}", Line.LineName);
values["Data"] = datas;
values["ID"] = id;
values["ModuleID"] = DeviceRegistrationID;
values["SegmentCode"] = Convert.ToString(values["TestRoomCode"]).Substring(0, 8);
values["CompanyCode"] = Convert.ToString(values["TestRoomCode"]).Substring(0, 12);
Openup.Insert("sys_document", values);
offset++;
}
}
}
