/// <summary>
/// 初始化函数
/// </summary>
public power_dict()
{
LIC.Add(new IoRyCol
{
ioryName = "power_dict_str",
ioryType = "string",
IsIdentity = false,
IsKey = true,
IsNull = false,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "power_display_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "order_int",
ioryType = "int?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
}
private void pageHeader_Format(object sender, EventArgs e)
{
lblWarehouse.Text = Warehouse.ToString();
lblShed.Text = Shed.ToString();
lblLIC.Text = LIC.ToString();
lblFromDate.Text = DateFrom.ToString();
lblToDate.Text = DateTo.ToString();
}
private void button1_Click(object sender, System.EventArgs e)
{
if (textBox2.Text == LIC.EncryptWithKey(textBox1.Text))
{
LIC.AddLic(textBox2.Text);
this.DialogResult = DialogResult.OK;
}
else
{
this.DialogResult = DialogResult.Cancel;
}
}
private void InitialiseErpConnectLicense()
{
try
{
Log.Information("Initialising and Checking License for ERPConnect");
LIC.SetLic(sapConfig.ErpConnectLicense);
}
catch (Exception exception)
{
Log.Error(exception, $"Could not register ERPConnect License Code: {sapConfig.ErpConnectLicense}");
}
}
/// <summary>
/// 初始化函数
/// </summary>
public Log_H222()
{
LIC.Add(new IoRyCol
{
ioryName = "int_index",
ioryType = "int?",
IsIdentity = true,
IsKey = true,
IsNull = false,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "ceshi",
ioryType = "decimal?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "cc",
ioryType = "double?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "sda",
ioryType = "byte[]",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "qq",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
}
public BusinessSAP()
{
string User = ConfigurationManager.AppSettings["User"].ToString();
string AppServerHost = ConfigurationManager.AppSettings["AppServerHost"].ToString();
int SystemNumber = Convert.ToInt32(ConfigurationManager.AppSettings["SystemNumber"].ToString());
string Password = Encriptador.Desencriptar(ConfigurationManager.AppSettings["Password"].ToString(), true);
string Client = ConfigurationManager.AppSettings["Client"].ToString();
string Language = ConfigurationManager.AppSettings["Language"].ToString();
string Licencia = ConfigurationManager.AppSettings["Licencia"].ToString();
LIC.SetLic(Licencia);
ConectorSAP = new R3Connection(AppServerHost, SystemNumber, User, Password, Language, Client);
}
/// <summary>
/// 初始化函数
/// </summary>
public __EFMigrationsHistory()
{
LIC.Add(new IoRyCol
{
ioryName = "MigrationId",
ioryType = "string",
IsIdentity = false,
IsKey = true,
IsNull = false,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "ProductVersion",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = false,
ioryValueNull = true,
ioryValueChange = false
});
}
/// <summary>
/// 初始化函数
/// </summary>
public PC_config()
{
LIC.Add(new IoRyCol
{
ioryName = "PC_config_GUID",
ioryType = "Guid?",
IsIdentity = false,
IsKey = true,
IsNull = false,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "UUID_GUID",
ioryType = "Guid?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "IP_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "key_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "value_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "createtime_dt",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "changetime_dt",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
}
/// <summary>
/// 初始化函数
/// </summary>
public Log_H()
{
LIC.Add(new IoRyCol
{
ioryName = "int_index",
ioryType = "int?",
IsIdentity = true,
IsKey = true,
IsNull = false,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_opreater",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_Type",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_tablename",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_Sql",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_Old",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "dat_time",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
}
/// <summary>
/// 初始化函数
/// </summary>
public log_data()
{
LIC.Add(new IoRyCol
{
ioryName = "log_data_GUID",
ioryType = "Guid?",
IsIdentity = false,
IsKey = true,
IsNull = false,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "sopreater_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "UUID_GUID_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "IP_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "type_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "tablename_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "SQL_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "olddata_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "createtime_dt",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
}
/// <summary>
/// 初始化函数
/// </summary>
public Table_main()
{
LIC.Add(new IoRyCol
{
ioryName = "int_index",
ioryType = "int?",
IsIdentity = true,
IsKey = true,
IsNull = false,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "int_ID",
ioryType = "long?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_jidongchesuoyouren",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_shenfenzhengmingcheng",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_shenfenzhengID",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_dengjijiguan",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "dat_dengjiriqi",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_jidongchedengjibianhao",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_Iszhuanyi",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_zhuanyiID",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "dat_createtime",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "dat_changetime",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
}
/// <summary>
/// 初始化函数
/// </summary>
public Users()
{
LIC.Add(new IoRyCol
{
ioryName = "Users_GUID",
ioryType = "int?",
IsIdentity = true,
IsKey = true,
IsNull = false,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "loginname_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "pwd_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "pwd_encrypt_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "name_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "type_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "power_str",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "createtime_dt",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "changetime_dt",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
}
/// <summary>
/// 初始化函数
/// </summary>
public Users()
{
LIC.Add(new IoRyCol
{
ioryName = "int_index",
ioryType = "int?",
IsIdentity = true,
IsKey = true,
IsNull = false,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_loginname",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_pwd",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_name",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_type",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "str_power",
ioryType = "string",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "dat_createtime",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
LIC.Add(new IoRyCol
{
ioryName = "dat_changetime",
ioryType = "DateTime?",
IsIdentity = false,
IsKey = false,
IsNull = true,
ioryValueNull = true,
ioryValueChange = false
});
}
public SapService(string sapConnectionString, string license)
{
_sapConnectionString = !string.IsNullOrWhiteSpace(sapConnectionString) ? sapConnectionString : throw new ArgumentException(nameof(sapConnectionString));
_license = !string.IsNullOrWhiteSpace(license) ? license : throw new ArgumentException(nameof(license));
LIC.SetLic(_license);
}
