//取出GridView数据源中的绑定对象集合
private ETLSapTableResultCollection getDataByGridView(GridView grid, int sortNo)
{
ETLSapTableResultCollection result = new ETLSapTableResultCollection();
for (int i = 0; i < grid.Rows.Count; i++)
{
ETLSapTableResult item = new ETLSapTableResult();
item.EntityName = grid.ToolTip;
item.IsEnable = ((CheckBox)grid.Rows[i].FindControl("cb_IsEnable")).Checked;
item.IsPrimaryKey = ((CheckBox)grid.Rows[i].FindControl("cb_IsPrimaryKey")).Checked;
item.FieldName = ((Label)grid.Rows[i].FindControl("lbl_FieldName")).Text;
item.FieldDesc = ((Label)grid.Rows[i].FindControl("lbl_FieldDesc")).Text;
FieldTypeEnum fieldType;
FieldTypeEnum.TryParse(((Label)grid.Rows[i].FindControl("lbl_FieldType")).Text, out fieldType);
item.FieldType = fieldType;
item.FieldLength = Convert.ToInt32(((Label)grid.Rows[i].FindControl("lbl_FieldLength")).Text);
item.IsIndex = ((CheckBox)grid.Rows[i].FindControl("cb_IsIndex")).Checked;
if (checkIsCommon.Checked)
{
item.IsKey = ((CheckBox)grid.Rows[i].FindControl("cb_IsKey")).Checked;
item.IsValue = ((CheckBox)grid.Rows[i].FindControl("cb_IsValue")).Checked;
}
item.RefTableName = ((HBDropDownList)grid.Rows[i].FindControl("ddl_RefTableName")).SelectedIndex == 0 ? string.Empty : ((HBDropDownList)grid.Rows[i].FindControl("ddl_RefTableName")).SelectedValue;
item.RefFieldName = ((HBDropDownList)grid.Rows[i].FindControl("ddl_RefFieldName")).SelectedValue.Trim() == "" ? string.Empty : ((HBDropDownList)grid.Rows[i].FindControl("ddl_RefFieldName")).SelectedValue;
item.SortNo = sortNo;
result.Add(item);
}
return(result);
}
//保存实体及映射
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
var dataSource = collectReapterData();
ETLSapTableResultCollection result = new ETLSapTableResultCollection();
foreach (var sapFieldDataItem in dataSource)
{
List <ETLSapTableResult> resultCollection = sapFieldDataItem.Collection.Where(p => p.IsEnable).ToList();
foreach (ETLSapTableResult etlSapTableResult in resultCollection)
{
result.Add(etlSapTableResult);
}
}
result.IsCommon = checkIsCommon.Checked;
result.UepUsers = this.hidd_Users.Value;
result.SAPInstanceId = this.hidSAPInstanceId.Value;
result.SAPInstanceId.CheckStringIsNullOrEmpty("sapInstanceId");
ETLDEObjectOperations.Instance.AddETLEntityBySapTable(Request.QueryString["categoryid"], result);
// HttpContext.Current.Response.Write("<script>alert('添加成功');window.returnValue=true;window.close();</script>");
//return;
//Response.End();
//scriptStr = "<script>alert('添加成功');window.returnValue=true;window.close();</script>";
WebUtility.ResponseShowClientMessageScriptBlock("添加成功!", "", "添加成功");
WebUtility.RegisterOnLoadScriptBlock(this, "window.returnValue=true;window.close();");
}
catch (Exception ex)
{
WebUtility.ResponseShowClientMessageScriptBlock("操作失败!", ex.Message, "操作失败");
}
}
public ETLSapTableResultCollection GetDatas(DataTable table)
{
ETLSapTableResultCollection resultList = new ETLSapTableResultCollection();
var parentRows = table.Select();
int sortNumber = 0;
foreach (var item in parentRows)
{
sortNumber++;
ETLSapTableResult result = new ETLSapTableResult();
result.SortNo = sortNumber;
result.EntityName = Convert.ToString(item["实体名"]);
result.EntityDesc = Convert.ToString(item["实体描述"]);
result.DefaultValue = Convert.ToString(item["默认值"]);
result.IsMasterTable = Convert.ToString(item["主子标识"]) == "主" ? true : false;
result.FieldName = Convert.ToString(item["字段名"]);
result.IsPrimaryKey = bool.Parse(Convert.ToString(item["主键"]));
if (result.IsPrimaryKey)
{
result.IsEnable = true;
}
int fileLenth = Convert.ToInt32(item["字段长度"]);
result.FieldType = SAPFileMapping.SAPFiledTypeToUEPFiledType(Convert.ToString(item["字段类型"]), ref fileLenth);;
item["字段长度"] = fileLenth;
result.FieldDesc = Convert.ToString(item["字段描述"]);
result.FieldLength = int.Parse(Convert.ToString(item["字段长度"]));
resultList.Add(result);
}
return(resultList);
}