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])); }