public override int Save()
{
int Ret = 0;
int paramSize = 6;
EnumProcType procType = EnumProcType.Insert;
ParameterDirection paramDir = ParameterDirection.Output;
AdaptForSave(ref procType, ref paramDir, ref paramSize);
SqlParameter[] procParams = new SqlParameter[paramSize]; int i = 0;
procParams[i] = DataAccess.CreateParameter("@ID", SqlDbType.Int, ID, paramDir);
if (EnumProcType.Insert == procType)
{
procParams[++i] = DataAccess.CreateParameter("@CreateDate", SqlDbType.DateTime, CreateDate, ParameterDirection.Output);
}
procParams[++i] = DataAccess.CreateParameter("@ModifyDate", SqlDbType.DateTime, ModifyDate, ParameterDirection.Output);
procParams[++i] = DataAccess.CreateParameter("@Name", SqlDbType.NVarChar, Name);
procParams[++i] = DataAccess.CreateParameter("@SortIndex", SqlDbType.Int, SortIndex);
procParams[++i] = DataAccess.CreateParameter("@Active", SqlDbType.Int, Active);
Ret = Save(procType, ref procParams);
return(Ret);
}
public override int Save()
{
int Ret = 0;
int paramSize = 13;
EnumProcType procType = EnumProcType.Insert;
ParameterDirection paramDir = ParameterDirection.Output;
AdaptForSave(ref procType, ref paramDir, ref paramSize);
SqlParameter[] procParams = new SqlParameter[paramSize]; int i = 0;
procParams[i] = DataAccess.CreateParameter("@ID", SqlDbType.Int, ID, paramDir);
if (EnumProcType.Insert == procType)
{
procParams[++i] = DataAccess.CreateParameter("@CreateDate", SqlDbType.DateTime, CreateDate, ParameterDirection.Output);
}
procParams[++i] = DataAccess.CreateParameter("@ModifyDate", SqlDbType.DateTime, ModifyDate, ParameterDirection.Output);
procParams[++i] = DataAccess.CreateParameter("@Name", SqlDbType.NVarChar, Name);
procParams[++i] = DataAccess.CreateParameter("@Address", SqlDbType.NVarChar, Address);
procParams[++i] = DataAccess.CreateParameter("@Mobile", SqlDbType.NVarChar, Mobile);
procParams[++i] = DataAccess.CreateParameter("@Phone", SqlDbType.NVarChar, Phone);
procParams[++i] = DataAccess.CreateParameter("@Fax", SqlDbType.NVarChar, Fax);
procParams[++i] = DataAccess.CreateParameter("@Email", SqlDbType.NVarChar, Email);
procParams[++i] = DataAccess.CreateParameter("@Homepage", SqlDbType.NVarChar, Homepage);
procParams[++i] = DataAccess.CreateParameter("@Username", SqlDbType.NVarChar, Username);
procParams[++i] = DataAccess.CreateParameter("@Password", SqlDbType.NVarChar, Password);
procParams[++i] = DataAccess.CreateParameter("@CountryID", SqlDbType.Int, CountryID);
procParams[++i] = DataAccess.CreateParameter("@Active", SqlDbType.Int, Active);
Ret = Save(procType, ref procParams);
return(Ret);
}
public override int Save()
{
int Ret = 0;
int paramSize = 7;
EnumProcType procType = EnumProcType.Insert;
ParameterDirection paramDir = ParameterDirection.Output;
AdaptForSave(ref procType, ref paramDir, ref paramSize);
SqlParameter[] procParams = new SqlParameter[paramSize]; int i = 0;
procParams[i] = DataAccess.CreateParameter("@ID", SqlDbType.Int, ID, paramDir);
if (EnumProcType.Insert == procType)
{
procParams[++i] = DataAccess.CreateParameter("@CreateDate", SqlDbType.DateTime, CreateDate, ParameterDirection.Output);
}
procParams[++i] = DataAccess.CreateParameter("@ModifyDate", SqlDbType.DateTime, ModifyDate, ParameterDirection.Output);
procParams[++i] = DataAccess.CreateParameter("@OrderID", SqlDbType.Int, OrderID);
procParams[++i] = DataAccess.CreateParameter("@ProductID", SqlDbType.Int, ProductID);
procParams[++i] = DataAccess.CreateParameter("@UnitPrice", SqlDbType.Float, UnitPrice);
procParams[++i] = DataAccess.CreateParameter("@Quantity", SqlDbType.Int, Quantity);
Ret = Save(procType, ref procParams);
return(Ret);
}
protected void AdaptForSave(ref EnumProcType procType, ref ParameterDirection paramDir, ref int paramSize)
{
if (0 != ID)
{
procType = EnumProcType.Update;
paramDir = ParameterDirection.Input;
if (!_IsLookup)
{
paramSize -= 1;
}
}
}
protected int Save(EnumProcType procType, ref SqlParameter[] procParams)
{
int Ret = 0;
if (EnumProcType.Update == procType)
{
DataAccess.ExecuteNonQuery(GetProcName(procType), procParams);
}
else
{
SqlCommand procCommand;
DataAccess.ExecuteNonQuery(out procCommand, GetProcName(procType), procParams);
ID = (int)procCommand.Parameters["@ID"].Value;
procCommand.Dispose();
}
Ret = ID;
return(Ret);
}
protected string GetProcName(EnumProcType procType)
{
string Ret = "";
switch (procType)
{
case EnumProcType.Select:
Ret = string.Format("{0}{1}", _Prefix, _Filter_Select); break;
case EnumProcType.Count:
Ret = string.Format("{0}{1}", _Prefix, _Filter_Count); break;
case EnumProcType.Index:
Ret = string.Format("{0}{1}", _Prefix, _Filter_Index); break;
case EnumProcType.Toggle:
Ret = string.Format("{0}{1}", _Prefix, _Object_Toggle); break;
default:
Ret = string.Format("{0}_{1}_{2}", _Prefix, (!_IsLookup) ? _ObjectName : _Object_Lookup, EnumHelper.MapProcName(procType)); break;
}
return(Ret);
}
protected string GetProcName(EnumProcType procType)
{
string Ret = string.Format("{0}_{1}_{2}", _Prefix, (!_IsLookup) ? _ObjectName : _Object_Lookup, EnumHelper.MapProcName(procType));
return(Ret);
}
public static string MapProcName(EnumProcType ProcType)
{
return(Enum2String(_ProcTypes, (int)ProcType, _ProcTypes[0]));
}
