public static string GetSeriesNo(string Name)
{
string Rv = "";
DataTable Dt;
string TableName;
string FieldName;
string Prefix;
Int32 Digits;
Dt = new ClsBase().pDa.GetQuery("System_DocumentSeries", "", "ModuleName = '" + Name + "'");
if (Dt.Rows.Count > 0)
{
TableName = (string)Layer01_Methods.IsNull(Dt.Rows[0]["TableName"], "");
FieldName = (string)Layer01_Methods.IsNull(Dt.Rows[0]["FieldName"], "");
Prefix = (string)Layer01_Methods.IsNull(Dt.Rows[0]["Prefix"], "");
Digits = (Int32)Layer01_Methods.IsNull(Dt.Rows[0]["Digits"], "");
}
else
{ return Rv; }
List<Layer01_Common.Common.Layer01_Constants.Str_Parameters> Sp = new List<Layer01_Common.Common.Layer01_Constants.Str_Parameters>();
Sp.Add(new Layer01_Common.Common.Layer01_Constants.Str_Parameters("@TableName", TableName));
Sp.Add(new Layer01_Common.Common.Layer01_Constants.Str_Parameters("@FieldName", FieldName));
Sp.Add(new Layer01_Common.Common.Layer01_Constants.Str_Parameters("@Prefix", Prefix));
Sp.Add(new Layer01_Common.Common.Layer01_Constants.Str_Parameters("@Digits", Digits));
Dt = new ClsConnection_SqlServer().ExecuteQuery("usp_GetSeriesNo", Sp).Tables[0];
if (Dt.Rows.Count > 0)
{ Rv = (string)Dt.Rows[0][0]; }
return Rv;
}
/// <summary>
/// Constructor for this class
/// </summary>
/// <param name="Obj_Base">
/// Parent Object Base
/// </param>
/// <param name="HeaderName">
/// Parent Table Name, (apparently not used at all)
/// </param>
/// <param name="TableName">
/// Detail Table Name
/// </param>
/// <param name="ViewName">
/// Detail View Name
/// </param>
/// <param name="OtherLoadCondition">
/// Additional conditions for fetching
/// </param>
public ClsBaseTableDetail(
ClsBase Obj_Base
, string HeaderName
, string TableName
, string ViewName = ""
, string OtherLoadCondition = "")
{
if (ViewName == "") ViewName = TableName;
this.mHeaderName = HeaderName;
this.mTableName = TableName;
this.mViewName = ViewName;
this.mOtherLoadCondition = OtherLoadCondition;
this.mObj_Base = Obj_Base;
this.mDa = Obj_Base.pDa;
DataTable Dt_Def = this.mDa.GetTableDef(this.mTableName);
DataRow[] ArrDr = Dt_Def.Select("IsPk = 1");
foreach (DataRow Dr in ArrDr)
{ this.mList_Key.Add((string)Dr["ColumnName"]); }
}
public static bool CheckSeriesDuplicate(
string TableName
, string SeriesField
, ClsKeys Keys
, string SeriesNo)
{
bool Rv = false;
DataTable Dt;
System.Text.StringBuilder Sb_Query_Key = new StringBuilder();
string Query_Key = "";
string Query_And = "";
foreach (string Inner_Key in Keys.pName)
{
Sb_Query_Key.Append(Query_And + " " + Inner_Key + " = " + Keys[Inner_Key]);
Query_And = " And ";
}
Query_Key = " 1 = 1 ";
if (Sb_Query_Key.ToString() != "")
{ Query_Key = "(Not (" + Sb_Query_Key.ToString() + "))"; }
Dt = new ClsBase().pDa.GetQuery(
"[" + TableName + "]"
, "Count(1) As [Ct]"
, Query_Key + " And " + SeriesField + " = '" + SeriesNo + "'");
if (Dt.Rows.Count > 0)
{
if ((Int32)Dt.Rows[0][0] > 0)
{ Rv = true; }
}
//True means duplicates have been found
return Rv;
}
public Str_Obj(string pName, ClsBase pObj)
{
this.Name = pName;
this.Obj = pObj;
}
public void Add(string Name, ClsBase Obj)
{
this.mList_Obj.Add(new Str_Obj(Name, Obj));
}
