public void Reload(IDbAccess dbAccess)
{
DataTable dataTable = dbAccess.GetDataTable($"Select * FROM {tableName} WHERE IdCustomer = {IdCustomer}");
if (dataTable.Rows.Count > 1)
{
throw new Exception($"Index {IdCustomer} auf Tabelle {tableName} ist nicht eindeutig");
}
UpdateFromRow(dataTable.Rows[0]);
}
public static BusinessCaseCoachingModel[] Load(IDbAccess dbAccess)
{
DataTable dataTable = dbAccess.GetDataTable($"Select * FROM {tableName}");
List <BusinessCaseCoachingModel> addressModels = new List <BusinessCaseCoachingModel>();
foreach (DataRow dataRow in dataTable.Rows)
{
addressModels.Add(new BusinessCaseCoachingModel(dataRow));
}
return(addressModels.ToArray());
}
public static AddressModel[] Load(IDbAccess dbAccess, int idCustomer)
{
DataTable dataTable = dbAccess.GetDataTable($"Select * FROM {tableName} WHERE fk_IdCustomer = {idCustomer}");
List <AddressModel> addressModels = new List <AddressModel>();
foreach (DataRow dataRow in dataTable.Rows)
{
addressModels.Add(new AddressModel(dataRow));
}
return(addressModels.ToArray());
}
public static CustomerModel[] Load(IDbAccess dbAccess)
{
DataTable dataTable = dbAccess.GetDataTable($"Select * FROM {tableName}");
List <CustomerModel> customerModels = new List <CustomerModel>();
foreach (DataRow dataRow in dataTable.Rows)
{
customerModels.Add(new CustomerModel(dataRow));
}
return(customerModels.ToArray());
}
public void TestMethod1()
{
IDbAccess oracledb = IDbFactory.CreateIDb(connStr1, dbType1);
DataTable dt = oracledb.GetDataTable(@"select BDCQZH, QLXZ, YWH, ZSGBH, SYQX, ZSLX, DBSJ, QLBSM, SIGNVALUE, SBH, SZSJ, QLBM, DJJG, QLR, QLQTZK, BDCDYH, MJ, ZL, ZSBSM, YT, QLLX, XZQBM, ZJH, GYQK, FJ, FWQBM, ZSZT, TNSVALUE, SIGNCERT from bdcqz where rownum<9");
dt.TableName = "bdcqz1";
IDbAccess mysqldb = IDbFactory.CreateIDb(connStr2, dbType2);
bool su = mysqldb.ImportFromDatatable(dt);
if (su)
{
Console.Write("sssssss");
}
}
public void Save(IDbAccess dbAccess, int idCustomer)
{
if (idAddress == 0)
{
string sqlString = $"insert {tableName} (fk_idCustomer, Street, Number, ZipCode, City, PhoneHome, PhoneMobile, PhoneOffice) values({idCustomer}, '{Street}', {SqlHelper.GetSqlString(Number)}, {SqlHelper.GetSqlString(ZipCode)}, '{City}', {SqlHelper.GetSqlString(PhoneHome)}, {SqlHelper.GetSqlString(PhoneMobile)}, {SqlHelper.GetSqlString(PhoneOffice)})";
dbAccess.InsertDb(sqlString);
DataTable dataTable = dbAccess.GetDataTable($"SELECT TOP 1 * FROM {tableName} ORDER BY IdAddress DESC");
this.UpdateFromRow(dataTable.Rows[0]);
}
else
{
string sqlString = $"UPDATE {tableName} SET Street = '{Street}', Number = {SqlHelper.GetSqlString(Number)}, ZipCode = {SqlHelper.GetSqlString(ZipCode)}, City = '{City}', PhoneHome = {SqlHelper.GetSqlString(PhoneHome)}, PhoneMobile = {SqlHelper.GetSqlString(PhoneMobile)}, PhoneOffice = {SqlHelper.GetSqlString(PhoneOffice)} WHERE idAddress = {IdAddress}";
dbAccess.Update(sqlString);
}
}
public int Save(IDbAccess dbAccess)
{
if (IdCustomer == 0)
{
string sqlString = $"insert {tableName} (FirstName, LastName, Since, Birthdate) values('{FirstName}', '{LastName}', GetDate(), {SqlHelper.GetSqlString(Birthdate)})";
dbAccess.InsertDb(sqlString);
DataTable dataTable = dbAccess.GetDataTable($"SELECT TOP 1 * FROM {tableName} ORDER BY IdCustomer DESC");
this.UpdateFromRow(dataTable.Rows[0]);
}
else
{
string sqlString = $"UPDATE {tableName} SET FirstName = {SqlHelper.GetSqlString(FirstName)}, LastName = {SqlHelper.GetSqlString(LastName)}, Birthdate = {SqlHelper.GetSqlString(Birthdate)} WHERE idCustomer = {IdCustomer}";
dbAccess.Update(sqlString);
}
return(0);
}
public static void TestGetDataTable()
{
IDbAccess db = IDbFactory.CreateIDb(connStr, dbType);
DataTable dt = db.GetDataTable("select * from templjqfortest");
}
public string NewSNO(IDbAccess iDb, string tableName, string colName, List <SerialChunk> chunks)
{
ValiAndPreDealPara(tableName, colName, chunks);
string key = GeneSNOKey(tableName, colName, chunks);
object lockobj = GetSNOLock(tableName, colName, chunks);
lock (lockobj)
{
DateTime now = DateTime.Now;
object obj;
bool b = ht_SNO_nos.TryGetValue(key, out obj);
string cycleModel = ""; //序列体循环模式
SerialChunk Serialchunk = null; //序列块
SerialChunk Datechunk = null; //日期循环块
int NoStart = 0; //序列块开始索引
int NoLen = -1; //序列块长度
int SerialTotalLen = 0; //序列体总长度
int DateStart = 0; //日期块开始索引
int DateLen = 0; //日期块长度
int max = -1; //有效的最大序列码
//第一次循环检查
for (int i = 0; i < chunks.Count; i++)
{
var chunk = chunks[i];
if (chunk.Type == "SerialNo")
{
Serialchunk = chunk;
cycleModel = chunk.CycleModel;
for (int ii = 0; ii < chunks.Count; ii++)
{
var chu = chunks[ii];
if (chu.Type != "SerialNo")
{
NoStart += chu.Len;
SerialTotalLen += chu.Len;
}
else
{
if (chu.Varlen)
{
//如果序列块变长的
NoLen = -1;
SerialTotalLen = -1;
}
else
{
//序列块是定长的
NoLen = chu.Len;
SerialTotalLen += chu.Len;
}
}
}
}
else if (chunk.Type == "DateTime" && chunk.Incyle)
{
Datechunk = chunk;
DateLen = chunk.Len;
for (int ii = 0; ii < i; ii++)
{
var chu = chunks[ii];
DateStart += chu.Len;
}
}
}
if (!b)
{
//缓存中没有当前类型的编号
string likeStr = "";//去后台查询已经存在的匹配编号时用
//第二次循环开始生成匹配串
for (int j = 0; j < chunks.Count; j++)
{
var chunk = chunks[j];
if (chunk.Type == "Text")
{
likeStr += chunk.TextVal;
}
else if (chunk.Type == "SerialNo")
{
if (chunk.Varlen)
{
likeStr += "%";
}
else
{
for (int i = 0; i < chunk.Len; i++)
{
likeStr += "_";
}
}
}
else if (chunk.Type == "DateTime")
{
if (cycleModel == "none" || string.IsNullOrWhiteSpace(cycleModel))
{
//序列码不循环
for (int i = 0; i < chunk.Len; i++)
{
likeStr += "_";
}
}
else
{
//序列码循环
if (!chunk.Incyle)
{
//当前日期不在循环中
for (int i = 0; i < chunk.Len; i++)
{
likeStr += "_";
}
}
else
{
//当前日期在循环中
string str = now.ToString(chunk.DateFormate);
if (str.Length != chunk.Len)
{
throw new Exception("格式化当前日期后的长度与制定的日期块所占长度不一致:[" + str + "][" + chunk.Len + "]");
}
likeStr += now.ToString(chunk.DateFormate);
}
}
}
}
//根据生成的序列号匹配串去后台查找相近的编号
string sql = string.Format("select distinct {0} from {1} where {0} like '{2}'", colName, tableName, likeStr);
DataTable dt = iDb.GetDataTable(sql);
max = FindMaxSerialNo(cycleModel, dt, now, Serialchunk, NoStart, NoLen, Datechunk, DateStart, DateLen);
}
else
{
//缓存中有当前类型的编号
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn());
DataRow row = dt.NewRow();
row[0] = obj.ToString();
dt.Rows.Add(row);
max = FindMaxSerialNo(cycleModel, dt, now, Serialchunk, NoStart, NoLen, Datechunk, DateStart, DateLen);
}
//根据已经找到的有效最大序列码进行编号的自动生成
string res = "";
for (int j = 0; j < chunks.Count; j++)
{
var chunk = chunks[j];
if (chunk.Type == "Text")
{
res += chunk.TextVal;
}
else if (chunk.Type == "SerialNo")
{
string no = "";
if (max == -1)
{
no = chunk.Start.ToString();
if (!chunk.Varlen)
{
no = no.PadLeft(chunk.Len, '0');
}
}
else
{
no = (max + chunk.Incr).ToString();
if (!chunk.Varlen)
{
no = no.PadLeft(chunk.Len, '0');
}
}
if (!chunk.Varlen)
{
if (no.Length != chunk.Len)
{
throw new Exception("生成的序列码和指定的序列码的长度不一致[" + no.ToString() + "][" + chunk.Len + "]!");
}
}
res += no;
}
else if (chunk.Type == "DateTime")
{
string dtstr = now.ToString(chunk.DateFormate);
if (dtstr.Length != chunk.Len)
{
throw new Exception("生成的日期块的长度与指定的长度不一致[" + dtstr + "][" + chunk.Len + "]!");
}
res += dtstr;
}
}
if (ht_SNO_nos.TryGetValue(key, out obj))
{
ht_SNO_nos[key] = res;
}
else
{
ht_SNO_nos.TryAdd(key, res);
}
return(res);
}
}
