public static string GetAutoDataKey(string tblName, string prefix, int maxLen, bool usePending)
{
common.myAutoKeyInfo keyInfo = GetAutoKey(tblName, usePending);
if (keyInfo == null)
{
return(null);
}
return(prefix + keyInfo.value.PadLeft(maxLen - prefix.Length, '0'));
}
public void UpdatePortfolio(ref data.baseDS.portfolioDataTable tbl)
{
for (int idx = 0; idx < tbl.Count; idx++)
{
if (tbl[idx].code.Trim() == Consts.constNotMarkerNEW)
{
common.myAutoKeyInfo info = application.SysLibs.GetAutoKey(tbl.TableName, false);
tbl[idx].code = info.value.ToString().PadLeft(tbl.codeColumn.MaxLength, '0');
}
}
DbAccess.UpdateData(tbl);
}
public override void AddNew(string code)
{
this.AddNewRow();
data.baseDS.portfolioRow row = (data.baseDS.portfolioRow)((DataRowView)myMasterSource.Current).Row;
if (row == null)
{
return;
}
application.dataLibs.InitData(row);
common.myAutoKeyInfo info = application.sysLibs.GetAutoKey(myDataSet.portfolio.TableName, false);
row.code = info.value.ToString().PadLeft(myDataSet.portfolio.codeColumn.MaxLength, '0');
row.investorCode = this.investorCode;
codeEd.Text = row.code;
interestedStrategy.Clear();
}
protected override void UpdateData(DataRow row)
{
if (row == null)
{
application.dataLibs.UpdateData(myDataSet.portfolio);
return;
}
data.baseDS.portfolioRow portfolioRow = (data.baseDS.portfolioRow)row;
if (portfolioRow.code.Trim() == "")
{
common.myAutoKeyInfo info = application.sysLibs.GetAutoKey(myDataSet.portfolio.TableName, false);
portfolioRow.code = info.value.ToString().PadLeft(myDataSet.portfolio.codeColumn.MaxLength, '0');
}
application.dataLibs.UpdateData(portfolioRow);
interestedStrategy.SaveData();
}
protected override void CloseAutoEditKey(common.myAutoKeyInfo autoKeyInfo)
{
DataAccess.Libs.DeleteKeyPending(autoKeyInfo);
}
public static void DeleteKeyPending(common.myAutoKeyInfo autoKeyInfo)
{
//Remove the used key in pending list
DbAccess.DeleteAutoKeyPending(autoKeyInfo.key, autoKeyInfo.value);
}