void btn_Save_Click(object sender, EventArgs e)
{
try
{
SFTable main = new SFTable();
main.No = this.RefNo;
main.RetrieveFromDBSources();
main = (SFTable)this.Ucsys1.Copy(main);
if (this.RefNo == null)
{
if (main.IsExits == true)
{
throw new Exception("编号[" + main.No + "]已经存在");
}
}
//设置它的数据源类型.
main.SrcType = SrcType.SQL;
#region 检查必填项.
if (main.No.Length == 0)
{
throw new Exception("编号不能为空");
}
if (main.Name.Length == 0)
{
throw new Exception("名称不能为空");
}
if (main.SelectStatement == "")
{
throw new Exception("查询的数据源不能为空.");
}
if (main.CashMinute <= 0)
{
main.CashMinute = 0;
}
#endregion 检查必填项.
if (this.RefNo == null)
{
main.FK_Val = main.No;
}
main.Save();
//重新生成
this.Response.Redirect("SFSQL.aspx?RefNo=" + main.No + "&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "&FromApp=" + this.FromApp, true);
}
catch (Exception ex)
{
this.Alert(ex.Message);
}
}
void btn_Click(object sender, EventArgs e)
{
string no = this.UCSys1.GetTextBoxByID("TB_No").Text;
string name = this.UCSys1.GetTextBoxByID("TB_Name").Text;
SFTable m = new SFTable();
m.No = no;
m.RetrieveFromDBSources();
m.Name = name;
if (string.IsNullOrEmpty(name))
{
this.Alert("编码表名称不能为空");
return;
}
// m.HisSFTableType = SFTableType.SFTable;
m.Save();
this.Response.Redirect("SFTableList.aspx?RefNo=" + m.No, true);
}
/// <summary>
/// 检查enittyNoName类型的实体
/// </summary>
public void CheckEnityTypeAttrsFor_EntityNoName()
{
//取出来全部的属性.
MapAttrs attrs = new MapAttrs(this.No);
#region 补充上流程字段到 NDxxxRpt.
if (attrs.Contains(this.No + "_" + GERptAttr.OID) == false)
{
/* WorkID */
MapAttr attr = new BP.Sys.MapAttr();
attr.FK_MapData = this.No;
attr.KeyOfEn = "OID";
attr.Name = "主键ID";
attr.MyDataType = BP.DA.DataType.AppInt;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = false;
attr.UIIsEnable = false;
attr.DefVal = "0";
attr.HisEditType = BP.En.EditType.Readonly;
attr.Insert();
}
if (attrs.Contains(this.No + "_" + GERptAttr.BillNo) == false)
{
/* 单据编号 */
MapAttr attr = new BP.Sys.MapAttr();
attr.FK_MapData = this.No;
attr.HisEditType = EditType.UnDel;
attr.KeyOfEn = GERptAttr.BillNo;
attr.Name = "编号"; // 单据编号
attr.MyDataType = DataType.AppString;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = true;
attr.UIIsEnable = false;
attr.UIIsLine = false;
attr.MinLen = 0;
attr.MaxLen = 100;
attr.Idx = -100;
attr.Insert();
}
if (attrs.Contains(this.No + "_" + GERptAttr.Title) == false)
{
/* 名称 */
MapAttr attr = new BP.Sys.MapAttr();
attr.FK_MapData = this.No;
attr.HisEditType = EditType.UnDel;
attr.KeyOfEn = GERptAttr.Title; // "FlowEmps";
attr.Name = "名称"; // 单据模式， ccform的模式.
attr.MyDataType = DataType.AppString;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = true;
attr.UIIsEnable = true;
attr.UIIsLine = true;
attr.MinLen = 0;
attr.MaxLen = 400;
attr.Idx = -90;
attr.Insert();
}
if (attrs.Contains(this.No + "_BillState") == false)
{
/* 单据状态 */
MapAttr attr = new BP.Sys.MapAttr();
attr.FK_MapData = this.No;
attr.HisEditType = EditType.UnDel;
attr.KeyOfEn = "BillState"; // "FlowEmps";
attr.Name = "单据状态"; //
attr.MyDataType = DataType.AppInt;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = false;
attr.UIIsEnable = false;
attr.UIIsLine = true;
attr.MinLen = 0;
attr.MaxLen = 10;
attr.Idx = -98;
attr.Insert();
}
if (attrs.Contains(this.No + "_Starter") == false)
{
/* 发起人 */
MapAttr attr = new BP.Sys.MapAttr();
attr.FK_MapData = this.No;
attr.HisEditType = EditType.UnDel;
attr.KeyOfEn = "Starter";
attr.Name = "创建人"; //
attr.MyDataType = DataType.AppString;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = false;
attr.UIIsEnable = false;
attr.MinLen = 0;
attr.MaxLen = 32;
attr.Idx = -1;
attr.Insert();
}
if (attrs.Contains(this.No + "_StarterName") == false)
{
/* 创建人名称 */
MapAttr attr = new BP.Sys.MapAttr();
attr.FK_MapData = this.No;
attr.HisEditType = EditType.UnDel;
attr.KeyOfEn = "StarterName";
attr.Name = "创建人名称"; //
attr.MyDataType = DataType.AppString;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = false;
attr.UIIsEnable = false;
attr.MinLen = 0;
attr.MaxLen = 32;
attr.Idx = -1;
attr.Insert();
}
if (attrs.Contains(this.No + "_" + GERptAttr.AtPara) == false)
{
/* 参数 */
MapAttr attr = new BP.Sys.MapAttr();
attr.FK_MapData = this.No;
attr.HisEditType = EditType.UnDel;
attr.KeyOfEn = GERptAttr.AtPara;
attr.Name = "参数"; // 单据编号
attr.MyDataType = DataType.AppString;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = false;
attr.UIIsEnable = false;
attr.UIIsLine = false;
attr.MinLen = 0;
attr.MaxLen = 4000;
attr.Idx = -99;
attr.Insert();
}
if (attrs.Contains(this.No + "_RDT") == false)
{
/* MyNum */
MapAttr attr = new BP.Sys.MapAttr();
attr.FK_MapData = this.No;
attr.HisEditType = EditType.UnDel;
attr.KeyOfEn = "RDT"; // "FlowStartRDT";
attr.Name = "创建时间";
attr.MyDataType = DataType.AppDateTime;
attr.UIContralType = UIContralType.TB;
attr.LGType = FieldTypeS.Normal;
attr.UIVisible = false;
attr.UIIsEnable = false;
attr.UIIsLine = false;
attr.Idx = -97;
attr.Insert();
}
#endregion 补充上流程字段。
#region 注册到外键表.
SFTable sf = new SFTable();
sf.No = this.No;
if (sf.RetrieveFromDBSources() == 0)
{
sf.Name = this.Name;
sf.SrcType = SrcType.SQL;
sf.SrcTable = this.PTable;
sf.ColumnValue = "BillNo";
sf.ColumnText = "Title";
sf.SelectStatement = "SELECT BillNo AS No, Title as Name FROM " + this.PTable;
sf.Insert();
}
#endregion 注册到外键表
}
void btn_Save_Click(object sender, EventArgs e)
{
try
{
SFTable main = new SFTable();
main.No = this.RefNo;
if (this.RefNo != null)
{
main.RetrieveFromDBSources();
}
main = (SFTable)this.Ucsys1.Copy(main);
if (main.No.Length == 0 || main.Name.Length == 0)
{
throw new Exception("编号与名称不能为空");
}
if (this.RefNo == null)
{
main.No = this.Ucsys1.GetTBByID("TB_No").Text;
if (main.IsExits)
{
string sql = "select No,Name FROM " + main.No + " WHERE 1=2";
try
{
BP.DA.DBAccess.RunSQLReturnTable(sql);
}
catch
{
this.Alert("错误:表或视图不存在No,Name列不符合约定规则 Key=" + main.No);
return;
}
}
}
else
{
main.No = this.RefNo;
main.RetrieveFromDBSources();
main = (SFTable)this.Ucsys1.Copy(main);
if (main.No.Length == 0 || main.Name.Length == 0)
{
throw new Exception("编号与名称不能为空");
}
}
if (main.Name.Length == 0)
{
throw new Exception("编号与名称不能为空");
}
if (main.No.Length == 0)
{
throw new Exception("编号与名称不能为空");
}
if (this.RefNo == null)
{
main.FK_Val = main.No;
}
main.Save();
//重新生成
this.Response.Redirect("SFTable.aspx?RefNo=" + main.No + "&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "&FromApp=" + this.FromApp, true);
}
catch (Exception ex)
{
this.Alert(ex.Message);
}
}
void btn_Save_Click(object sender, EventArgs e)
{
try
{
SFTable main = new SFTable();
main.No = this.RefNo;
main.RetrieveFromDBSources();
main = (SFTable)this.Ucsys1.Copy(main);
#region 检查必填项.
if (main.FK_SFDBSrc.Length == 0)
{
throw new Exception("必须选择数据源");
}
if (main.TableDesc.Length == 0)
{
throw new Exception("必须选择接口");
}
if (main.No.Length == 0)
{
throw new Exception("接口英文名称不能为空");
}
if (main.Name.Length == 0)
{
throw new Exception("接口中文名称不能为空");
}
var restype = this.Ucsys1.GetDDLByID("DDL_ResultType").SelectedItemStringVal;
if (restype.Length == 0)
{
throw new Exception("选择接口返回值类型");
}
#endregion 检查必填项.
if (this.RefNo == null)
{
if (main.IsExits == true)
{
throw new Exception("编号[" + main.No + "]已经存在");
}
}
//设置它的数据源类型.
main.SrcType = SrcType.WebServices;
main.TableDesc += "," + restype;
if (this.RefNo == null)
{
main.FK_Val = main.No;
}
main.Save();
//重新生成
this.Response.Redirect("SFWS.aspx?RefNo=" + main.No + "&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "&FromApp=" + this.FromApp + "&t=" + DateTime.Now.ToString("yyyyMMddHHmmssffffff"), true);
}
catch (Exception ex)
{
this.Alert(ex.Message);
}
}