public async Task <Response> RequestAsync(ServiceDataSet serviceDataSet)
{
IResponse response;
Task pendingTask = Task.FromResult <bool>(true);
var previousTask = pendingTask;
response = null;
pendingTask = Task.Run(async() =>
{
try
{
await previousTask;
response = ((IService)this).Request(serviceDataSet);
}
finally
{
}
}
);
await pendingTask;
return((Response)response);
}
internal static async Task <IResponse> SaveAsync(this ICore core, string EMAIL, string ACCESS_NUMBER, string NICKNAME, decimal REFERRAL_USER_ID)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet {
ServiceName = core.GetAttribute("ServiceName")
};
serviceDataSet["JOIN"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["JOIN"].CommandText = core.GetAttribute("ProcedureJoin");
serviceDataSet["JOIN"].AddParameter("@EMAIL", DbType.NVarChar, 100);
serviceDataSet["JOIN"].AddParameter("@ACCESS_NUMBER", DbType.NVarChar, 4000);
serviceDataSet["JOIN"].AddParameter("@NICKNAME", DbType.NVarChar, 50);
serviceDataSet["JOIN"].AddParameter("@REFERRAL_USER_ID", DbType.Decimal, 18);
serviceDataSet["JOIN"].AddParameter("@USER_ID", DbType.Decimal, 18);
serviceDataSet["JOIN"].NewRow();
serviceDataSet["JOIN"].SetValue("@EMAIL", EMAIL.EmptyToDBNullValue());
serviceDataSet["JOIN"].SetValue("@ACCESS_NUMBER", ACCESS_NUMBER.EmptyToDBNullValue());
serviceDataSet["JOIN"].SetValue("@NICKNAME", NICKNAME.EmptyToDBNullValue());
if (REFERRAL_USER_ID <= 0)
{
serviceDataSet["JOIN"].SetValue("@REFERRAL_USER_ID", DBNull.Value);
}
else
{
serviceDataSet["JOIN"].SetValue("@REFERRAL_USER_ID", REFERRAL_USER_ID);
}
return(await core.ServiceRequestAsync(serviceDataSet));
}
internal static async Task <IResponse> SaveAsync(this ICore core, string[] sources, string sourceCultureName)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet {
ServiceName = core.GetAttribute("ServiceName")
};
serviceDataSet["LanguageDictionaryIns"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["LanguageDictionaryIns"].CommandText = core.GetAttribute("ProcedureSave");
serviceDataSet["LanguageDictionaryIns"].AddParameter("@ACTION", DbType.NVarChar, 50);
serviceDataSet["LanguageDictionaryIns"].AddParameter("@LANGUAGE_TEXT", DbType.NVarChar, 4000);
serviceDataSet["LanguageDictionaryIns"].AddParameter("@LANGUAGE_TYPE", DbType.NVarChar, 10);
serviceDataSet["LanguageDictionaryIns"].AddParameter("@USER_ID", DbType.Decimal, 18);
foreach (string str in sources)
{
serviceDataSet["LanguageDictionaryIns"].NewRow();
serviceDataSet["LanguageDictionaryIns"].SetValue("@ACTION", "Save");
serviceDataSet["LanguageDictionaryIns"].SetValue("@LANGUAGE_TEXT", str);
serviceDataSet["LanguageDictionaryIns"].SetValue("@LANGUAGE_TYPE", sourceCultureName);
serviceDataSet["LanguageDictionaryIns"].SetValue("@USER_ID", Config.Client.GetAttribute("Account.USER_ID") == null ? DBNull.Value : Config.Client.GetAttribute("Account.USER_ID"));
}
return(await core.ServiceRequestAsync(serviceDataSet));
}
public static DataTable GetLastPeriodExChangeRate()
{
ServiceDataSet ds = AppConfig.mmForm.GpSvcClient.Execute(@"SELECT xch.*,crncy.Currency FROM [ERP_Basedata].[dbo].[finance_exchangerate] xch
inner join [ERP_Basedata].[Finance].[Currency] crncy on xch.FromCurrencyCode=crncy.CurrencyCode and crncy.Fixed=1
WHERE xch.ToCurrencyCode='RMB' and xch.FiscalPeriod = (Select Max(FiscalPeriod) from [ERP_Basedata].[dbo].[finance_exchangerate] where Catalog=1 and FromCurrencyCode=xch.FromCurrencyCode ) order by xch.FiscalPeriod,xch.FromCurrencyCode desc", CommandType.Text);
return(ds.Data.Tables[0]);
}
internal static IResponse Search(this ICore core, WindowsControlSearchModel search, ICore parentCore)
{
IServiceDataSet serviceDataSet;
IResponse result;
string tmp;
serviceDataSet = new ServiceDataSet
{
ServiceName = core.GetAttribute("ServiceName"),
TransactionScope = false
};
if (parentCore == null)
{
serviceDataSet["Dictionary"].ConnectionName = core.GetAttribute("DatabaseName");
}
else
{
serviceDataSet["Dictionary"].ConnectionName = parentCore.GetAttribute(core.GetAttribute("DictionaryConnectionName"));
serviceDataSet["Dictionary"].ConnectionName = serviceDataSet["Dictionary"].ConnectionName.IsNullOrEmpty() ? core.GetAttribute("DatabaseName") : serviceDataSet["Dictionary"].ConnectionName;
}
serviceDataSet["Dictionary"].CommandText = core.GetAttribute("ProcedureExec");
serviceDataSet["Dictionary"].AddParameter("@CODE", DbType.NVarChar, 50);
serviceDataSet["Dictionary"].AddParameter("@SEARCH_TEXT", DbType.NVarChar, 4000);
serviceDataSet["Dictionary"].AddParameter("@SEARCH_INDEX", DbType.Int, 0);
serviceDataSet["Dictionary"].AddParameter("@COND_ETC", DbType.NVarChar, 4000);
serviceDataSet["Dictionary"].AddParameter("@SEARCH_ALL", DbType.NVarChar, 1);
serviceDataSet["Dictionary"].AddParameter("@STARTS_WITH", DbType.NVarChar, 1);
serviceDataSet["Dictionary"].NewRow();
serviceDataSet["Dictionary"].SetValue("@CODE", search.CODE);
serviceDataSet["Dictionary"].SetValue("@SEARCH_TEXT", search.SEARCH_TEXT);
serviceDataSet["Dictionary"].SetValue("@SEARCH_INDEX", search.SEARCH_INDEX);
serviceDataSet["Dictionary"].SetValue("@COND_ETC", search.COND_ETC);
serviceDataSet["Dictionary"].SetValue("@SEARCH_ALL", search.SEARCH_ALL);
serviceDataSet["Dictionary"].SetValue("@STARTS_WITH", search.STARTS_WITH);
result = core.ServiceRequest(serviceDataSet);
if (result.Status == Status.OK)
{
if (result.DataSet.Tables.Count >= 1)
{
foreach (System.Data.DataColumn _DataColumn in result.DataSet.Tables[0].Columns)
{
if (_DataColumn.ColumnName.Contains('^'))
{
tmp = _DataColumn.ColumnName;
_DataColumn.ColumnName = tmp.Split('^')[0];
_DataColumn.Caption = tmp;
}
}
}
}
return(result);
}
/// <summary>
/// 获取
/// </summary>
/// <param name="fiscalPeriod"></param>
/// <param name="fromCurrencyCode"></param>
/// <returns></returns>
public static DataSet FindToRMB(String TableName)
{
ServiceDataSet ds = AppConfig.mmForm.GpSvcClient.Execute(@"SELECT xch.*,crncy.Currency FROM [ERP_Basedata].[dbo].[finance_exchangerate] xch
inner join [ERP_Basedata].[Finance].[Currency] crncy on xch.FromCurrencyCode=crncy.CurrencyCode and crncy.Fixed=1
WHERE xch.ToCurrencyCode='RMB' and xch.Catalog=1 order by xch.FiscalPeriod,xch.FromCurrencyCode desc", CommandType.Text);
ds.Table.TableName = TableName;
return(ds.Data);
}
public static DataSet GetFixed(String tableName)
{
ServiceDataSet ds = AppConfig.mmForm.GpSvcClient.Execute("SELECT * FROM [ERP_Basedata].[dbo].[vCurrencyControl] where Fixed=1 and Catalog=1", CommandType.Text);
if (!String.IsNullOrEmpty(tableName))
{
ds.Data.Tables[0].TableName = tableName;
}
return(ds.Data);
}
public static DataTable GetPeriodExChangeRate(Int32 FiscalPeriod)
{
List <CmdParameter> gpParameter = new List <CmdParameter>();
gpParameter.Add(new CmdParameter("@FiscalPeriod", FiscalPeriod));
ServiceDataSet ds = AppConfig.mmForm.GpSvcClient.Execute(@"SELECT xch.* ,crncy.Currency FROM [ERP_Basedata].[dbo].[finance_exchangerate] xch
inner join [ERP_Basedata].[Finance].[Currency] crncy on xch.FromCurrencyCode=crncy.CurrencyCode and crncy.Fixed=1
WHERE xch.ToCurrencyCode='RMB' and xch.Catalog=1 and xch.FiscalPeriod=@FiscalPeriod order by xch.FromCurrencyCode desc", CommandType.Text, gpParameter);
return(ds.Data.Tables[0]);
}
private void search()
{
DoWork("数据查询中...", "请稍后", () =>
{
dsGpUser = Erp.GpServiceClient.GpClient.CreateInstance().Execute("SELECT * FROM [ERP_Identity].[Auth].[Gpuser] where LoginName like '%" + teFilterCondition.Text + "%' or UserName like'%" + teFilterCondition.Text + "%' order by id asc", CommandType.Text);
}, (ex) =>
{
if (ex == null)
{
gcGpUser.DataSource = dsGpUser.Data.Tables[0];
}
});
}
public static String FindName(String CurrencyCode)
{
List <CmdParameter> gpParameters = new List <CmdParameter>();
gpParameters.Add(new CmdParameter("@CurrencyCode", CurrencyCode));
ServiceDataSet ds = AppConfig.mmForm.GpSvcClient.Execute("SELECT * FROM [ERP_Basedata].[dbo].[vCurrencyControl] WHERE CurrencyCode=@CurrencyCode and Catalog=1", CommandType.Text, gpParameters);
String Currency = "";
if (ds.Table.Rows.Count > 0)
{
Currency = ds["Currency"].ToString();
}
return(Currency);
}
Response IService.Request(ServiceDataSet serviceDataSet)
{
IResponse response;
ServiceInfo serviceInfo;
serviceInfo = null;
try
{
//_Response = this.Service.Request(_ServiceDataSet);
serviceInfo = this.GetService();
serviceInfo.IsBusy = true;
response = serviceInfo.Service.Request(serviceDataSet);
this.tryConnectCount = 0;//정상적으로 처리가 되면 재시도 횟수 초기화
return((Response)response);
}
catch (CommunicationException _Exception)
{
if (this.tryConnectCount > 3)
{
throw _Exception;
}
this.tryConnectCount += 1;
this.RemoveService(serviceInfo);
return(((IService)this).Request(serviceDataSet));
}
catch (AtomusException _Exception)
{
return((Response)Factory.CreateInstance("Atomus.Service.Response", false, true, _Exception));
}
catch (Exception _Exception)
{
return((Response)Factory.CreateInstance("Atomus.Service.Response", false, true, _Exception));
}
finally
{
serviceInfo?.End();
}
//return (Response)_Response;
}
public static Decimal GetLastPeriodExChangeRate(String fromCurrencyCode)
{
List <CmdParameter> gpParameter = new List <CmdParameter>();
gpParameter.Add(new CmdParameter("@FromCurrencyCode", fromCurrencyCode));
ServiceDataSet ds = AppConfig.mmForm.GpSvcClient.Execute(@"SELECT xch.* ,crncy.Currency FROM [ERP_Basedata].[dbo].[finance_exchangerate] xch
inner join [ERP_Basedata].[Finance].[Currency] crncy on xch.FromCurrencyCode=crncy.CurrencyCode and crncy.Fixed=1
WHERE xch.ToCurrencyCode='RMB' and xch.Catalog=1 and xch.FiscalPeriod = (Select Max(FiscalPeriod) from [ERP_Basedata].[dbo].[finance_exchangerate] where Catalog=1 and FromCurrencyCode=xch.FromCurrencyCode ) and xch.FromCurrencyCode =@FromCurrencyCode order by xch.FiscalPeriod,xch.FromCurrencyCode desc", CommandType.Text, gpParameter);
Decimal exchangeRate = -1;
if (ds.Data.Tables[0].Rows.Count > 0)
{
exchangeRate = Convert.ToDecimal(ds.Data.Tables[0].Rows[0]["ExchangeRate"]);
}
return(exchangeRate);
}
public static Decimal GetPeriodExChangeRateValue(Int32 FiscalPeriod, String formCurrencyCode)
{
List <CmdParameter> gpParameter = new List <CmdParameter>();
gpParameter.Add(new CmdParameter("@FiscalPeriod", FiscalPeriod));
gpParameter.Add(new CmdParameter("@FromCurrencyCode", formCurrencyCode));
ServiceDataSet ds = AppConfig.mmForm.GpSvcClient.Execute(@"SELECT xch.ExchangeRate FROM [ERP_Basedata].[dbo].[finance_exchangerate] xch
inner join [ERP_Basedata].[Finance].[Currency] crncy on xch.FromCurrencyCode=crncy.CurrencyCode and crncy.Fixed=1
WHERE xch.ToCurrencyCode='RMB' and xch.Catalog=1 and xch.FiscalPeriod=@FiscalPeriod and xch.FromCurrencyCode=@FromCurrencyCode", CommandType.Text, gpParameter);
decimal value = -1;
if (ds.Data.Tables[0].Rows.Count > 0)
{
value = Convert.ToDecimal(ds.Data.Tables[0].Rows[0]["ExchangeRate"]);
}
return(value);
}
public static void Delete(Int32 id)
{
List <CmdParameter> gpParameters = new List <CmdParameter>();
gpParameters.Add(new CmdParameter("@Id", id));
gpParameters.Add(new CmdParameter("@Infor", "", ParameterDirection.Output));
gpParameters.Add(new CmdParameter("@Ok", 0, ParameterDirection.Output));
ServiceDataSet ds = AppConfig.mmForm.GpSvcClient.Execute("ERP_Basedata.[Finance].[Currency_Delete]", CommandType.StoredProcedure, gpParameters);
if (!Convert.ToBoolean(ds.GetParameter("@Ok").Value))
{
throw new FaultException <ApplicationServiceError>(new ApplicationServiceError()
{
ErrorMessage = ds.GetParameter("@Infor").Value.ToString()
});
}
}
internal IResponse Save(QueueData queueData)
{
IServiceDataSet serviceDataSet;
if (queueData == null)
{
return(null);
}
serviceDataSet = new ServiceDataSet
{
ServiceName = this.GetAttribute("ServiceName"),
TransactionScope = false,
};
serviceDataSet["Log"].ConnectionName = this.GetAttribute("ConnectionName");
serviceDataSet["Log"].CommandText = this.GetAttribute("ProcedureSave");
serviceDataSet["Log"].AddParameter("@LOG_ID", DbType.Decimal, 18, "Log", "@LOG_ID");
serviceDataSet["Log"].AddParameter("@IP_ADDRESS", DbType.NVarChar, 50);
serviceDataSet["Log"].AddParameter("@USER_ID", DbType.NVarChar, 50);
serviceDataSet["Log"].AddParameter("@REQUESTER", DbType.NVarChar, 50);
serviceDataSet["Log"].AddParameter("@REQUEST_BODY", DbType.NText);
serviceDataSet["Log"].AddParameter("@REQUEST_RESULT", DbType.NText);
serviceDataSet["Log"].AddParameter("@DATETIME", DbType.DateTime);
serviceDataSet["Log"].NewRow();
serviceDataSet["Log"].SetValue("@LOG_ID", DBNull.Value);
serviceDataSet["Log"].SetValue("@IP_ADDRESS", queueData.IP_ADDRESS);
serviceDataSet["Log"].SetValue("@USER_ID", queueData.USER_ID);
serviceDataSet["Log"].SetValue("@REQUESTER", queueData.REQUESTER);
serviceDataSet["Log"].SetValue("@REQUEST_BODY", queueData.REQUEST_BODY);
serviceDataSet["Log"].SetValue("@REQUEST_RESULT", queueData.REQUEST_RESULT);
serviceDataSet["Log"].SetValue("@DATETIME", queueData.START_DATETIME);
serviceDataSet["Log"].NewRow();
serviceDataSet["Log"].SetValue("@LOG_ID", DBNull.Value);
serviceDataSet["Log"].SetValue("@IP_ADDRESS", DBNull.Value);
serviceDataSet["Log"].SetValue("@USER_ID", DBNull.Value);
serviceDataSet["Log"].SetValue("@REQUESTER", DBNull.Value);
serviceDataSet["Log"].SetValue("@REQUEST_BODY", DBNull.Value);
serviceDataSet["Log"].SetValue("@REQUEST_RESULT", queueData.REQUEST_RESULT);
serviceDataSet["Log"].SetValue("@DATETIME", queueData.END_DATETIME);
return((this.CreateInstance("ServiceName") as IService).Request((ServiceDataSet)serviceDataSet));
}
internal static async Task <IResponse> SearchAsync(this ICore core, string EMAIL, string ACCESS_NUMBER)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet {
ServiceName = core.GetAttribute("ServiceName")
};
serviceDataSet["LOGIN"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["LOGIN"].CommandText = core.GetAttribute("ProcedureLogin");
serviceDataSet["LOGIN"].AddParameter("@EMAIL", DbType.NVarChar, 100);
serviceDataSet["LOGIN"].AddParameter("@ACCESS_NUMBER", DbType.NVarChar, 4000);
serviceDataSet["LOGIN"].NewRow();
serviceDataSet["LOGIN"].SetValue("@EMAIL", EMAIL);
serviceDataSet["LOGIN"].SetValue("@ACCESS_NUMBER", ACCESS_NUMBER);
return(await core.ServiceRequestAsync(serviceDataSet));
}
internal static IResponse Login(this ICore core, string DatabaseName, string ProcedureID, string EMAIL, string ACCESS_NUMBER)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet {
ServiceName = core.GetAttribute("ServiceName")
};
serviceDataSet["LOGIN"].ConnectionName = DatabaseName;
serviceDataSet["LOGIN"].CommandText = ProcedureID;
serviceDataSet["LOGIN"].AddParameter("@EMAIL", DbType.NVarChar, 100);
serviceDataSet["LOGIN"].AddParameter("@ACCESS_NUMBER", DbType.NVarChar, 4000);
serviceDataSet["LOGIN"].NewRow();
serviceDataSet["LOGIN"].SetValue("@EMAIL", EMAIL);
serviceDataSet["LOGIN"].SetValue("@ACCESS_NUMBER", ACCESS_NUMBER);
return(core.ServiceRequest(serviceDataSet));
}
internal static async Task <IResponse> SearchInfoAsync(this ICore core)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet
{
ServiceName = core.GetAttribute("ServiceName"),
TransactionScope = false
};
serviceDataSet["LoadMenu"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["LoadMenu"].CommandText = core.GetAttribute("ProcedureInfo");
serviceDataSet["LoadMenu"].AddParameter("@USER_ID", DbType.Decimal, 18);
serviceDataSet["LoadMenu"].NewRow();
serviceDataSet["LoadMenu"].SetValue("@USER_ID", Config.Client.GetAttribute("Account.USER_ID"));
return(await core.ServiceRequestAsync(serviceDataSet));
}
internal static IResponse Search(this ICore core)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet
{
ServiceName = core.GetAttribute("ServiceName"),
TransactionScope = false
};
serviceDataSet["Message"].ConnectionName = core.GetAttribute("ConnectionName");
serviceDataSet["Message"].CommandText = core.GetAttribute("Procedure");
serviceDataSet["Message"].AddParameter("@USER_ID", DbType.Decimal, 18);
serviceDataSet["Message"].NewRow();
serviceDataSet["Message"].SetValue("@USER_ID", Config.Client.GetAttribute("Account.USER_ID") ?? DBNull.Value);
return(core.ServiceRequest(serviceDataSet));
}
private DataTable searchOrgMember(string sLoginName)
{
DataTable dtOrgMember = null;
dsOrgMember = Erp.GpServiceClient.GpClient.CreateInstance().Execute("SELECT * FROM [ERP_Identity].[Org].[VOrgGpuser] where LoginName ='" + sLoginName + "'", CommandType.Text);
dtOrgMember = dsOrgMember.Data.Tables[0];
//DoWork("数据查询中...", "请稍后", () =>
//{
//}, (ex) =>
//{
// if (ex == null)
// {
// dtOrgMember = dsOrgMember.Data.Tables[0];
// }
//});
return(dtOrgMember);
}
internal static async Task <IResponse> SaveAsync(this ICore core, decimal EXCHANGE_ID)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet {
ServiceName = core.GetAttribute("ServiceName")
};
serviceDataSet["LoadMenu"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["LoadMenu"].CommandText = core.GetAttribute("ProcedureSave");
serviceDataSet["LoadMenu"].AddParameter("@EXCHANGE_ID", DbType.Decimal, 18);
serviceDataSet["LoadMenu"].AddParameter("@USER_ID", DbType.Decimal, 18);
serviceDataSet["LoadMenu"].NewRow();
serviceDataSet["LoadMenu"].SetValue("@EXCHANGE_ID", EXCHANGE_ID);
serviceDataSet["LoadMenu"].SetValue("@USER_ID", Config.Client.GetAttribute("Account.USER_ID"));
return(await core.ServiceRequestAsync(serviceDataSet));
}
internal static IResponse Search(this ICore core, DefaultTranslatorSearchModel search)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet
{
ServiceName = core.GetAttribute("ServiceName"),
TransactionScope = false
};
serviceDataSet["Translator"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["Translator"].CommandText = core.GetAttribute("ProcedureID");
serviceDataSet["Translator"].AddParameter("@SOURCE_LANGUAGE_TYPE", DbType.NVarChar, 10);
serviceDataSet["Translator"].AddParameter("@TARGET_LANGUAGE_TYPE", DbType.NVarChar, 10);
serviceDataSet["Translator"].NewRow();
serviceDataSet["Translator"].SetValue("@SOURCE_LANGUAGE_TYPE", search.SOURCE_LANGUAGE_TYPE);
serviceDataSet["Translator"].SetValue("@TARGET_LANGUAGE_TYPE", search.TARGET_LANGUAGE_TYPE);
return(core.ServiceRequest(serviceDataSet));
}
public static void Delete(Int32 FiscalPeriod, String FromCurrencyCode, String ToCurrencyCode)
{
List <CmdParameter> gpParameter = new List <CmdParameter>();
gpParameter.Add(new CmdParameter("@FiscalPeriod", FiscalPeriod));
gpParameter.Add(new CmdParameter("@Catalog", 1));
gpParameter.Add(new CmdParameter("@FromCurrencyCode", FromCurrencyCode));
gpParameter.Add(new CmdParameter("@ToCurrencyCode", ToCurrencyCode));
gpParameter.Add(new CmdParameter("@Infor", "", ParameterDirection.Output));
gpParameter.Add(new CmdParameter("@Ok", 0, ParameterDirection.Output));
ServiceDataSet ds = AppConfig.mmForm.GpSvcClient.Execute(@"[ERP_Basedata].[dbo].[FinanceExchangeRate_Delete]", CommandType.StoredProcedure, gpParameter);
if (!Convert.ToBoolean(ds.GetParameter("@Ok").Value))
{
throw new FaultException <ApplicationServiceError>(new ApplicationServiceError()
{
ErrorMessage = ds.GetParameter("@Infor").Value.ToString()
});
}
}
internal static IResponse Search(this ICore core, DefaultLoginSearchModel search)
{
IServiceDataSet serviceDataSet;
//serviceDataSet = new ServiceDataSet { ServiceName = core.GetAttribute("ServiceName"), TransactionScope = false };
serviceDataSet = new ServiceDataSet {
ServiceName = core.GetAttribute("ServiceName")
};
serviceDataSet["LOGIN"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["LOGIN"].CommandText = core.GetAttribute("ProcedureLogin");
//serviceDataSet["LOGIN"].SetAttribute("DatabaseName", core.GetAttribute("DatabaseName"));
//serviceDataSet["LOGIN"].SetAttribute("ProcedureID", core.GetAttribute("ProcedureLogin"));
serviceDataSet["LOGIN"].AddParameter("@EMAIL", DbType.NVarChar, 100);
serviceDataSet["LOGIN"].AddParameter("@ACCESS_NUMBER", DbType.NVarChar, 4000);
serviceDataSet["LOGIN"].NewRow();
serviceDataSet["LOGIN"].SetValue("@EMAIL", search.EMAIL);
serviceDataSet["LOGIN"].SetValue("@ACCESS_NUMBER", search.ACCESS_NUMBER);
return(core.ServiceRequest(serviceDataSet));
}
internal static async Task <IResponse> SaveAsync(this ICore core, DefaultJoinSaveModel save)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet {
ServiceName = core.GetAttribute("ServiceName")
};
serviceDataSet["JOIN"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["JOIN"].CommandText = core.GetAttribute("ProcedureJoin");
serviceDataSet["JOIN"].AddParameter("@EMAIL", DbType.NVarChar, 100);
serviceDataSet["JOIN"].AddParameter("@ACCESS_NUMBER", DbType.NVarChar, 4000);
serviceDataSet["JOIN"].AddParameter("@NICKNAME", DbType.NVarChar, 50);
serviceDataSet["JOIN"].AddParameter("@USER_ID", DbType.Decimal, 18);
serviceDataSet["JOIN"].NewRow();
serviceDataSet["JOIN"].SetValue("@EMAIL", save.EMAIL);
serviceDataSet["JOIN"].SetValue("@ACCESS_NUMBER", save.ACCESS_NUMBER);
serviceDataSet["JOIN"].SetValue("@NICKNAME", save.NICKNAME);
return(await core.ServiceRequestAsync(serviceDataSet));
}
internal static async Task <IResponse> SavePasswordChangeAsync(this ICore core, string EMAIL, string ACCESS_NUMBER, string NEW_ACCESS_NUMBER)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet {
ServiceName = core.GetAttribute("ServiceName")
};
serviceDataSet["JOIN"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["JOIN"].CommandText = core.GetAttribute("ProcedurePasswordChange");
serviceDataSet["JOIN"].AddParameter("@EMAIL", DbType.NVarChar, 100);
serviceDataSet["JOIN"].AddParameter("@ACCESS_NUMBER", DbType.NVarChar, 4000);
serviceDataSet["JOIN"].AddParameter("@NEW_ACCESS_NUMBER", DbType.NVarChar, 4000);
serviceDataSet["JOIN"].AddParameter("@USER_ID", DbType.Decimal, 18);
serviceDataSet["JOIN"].NewRow();
serviceDataSet["JOIN"].SetValue("@EMAIL", EMAIL.EmptyToDBNullValue());
serviceDataSet["JOIN"].SetValue("@ACCESS_NUMBER", ACCESS_NUMBER.EmptyToDBNullValue());
serviceDataSet["JOIN"].SetValue("@NEW_ACCESS_NUMBER", NEW_ACCESS_NUMBER.EmptyToDBNullValue());
return(await core.ServiceRequestAsync(serviceDataSet));
}
internal static IResponse SearchOpenControl(this ICore core, DefaultBrowserSearchModel search)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet
{
ServiceName = core.GetAttribute("ServiceName"),
TransactionScope = false
};
serviceDataSet["OpenControl"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["OpenControl"].CommandText = core.GetAttribute("ProcedureMenuSelect");
serviceDataSet["OpenControl"].AddParameter("@MENU_ID", DbType.Decimal, 18);
serviceDataSet["OpenControl"].AddParameter("@ASSEMBLY_ID", DbType.Decimal, 18);
serviceDataSet["OpenControl"].AddParameter("@USER_ID", DbType.Decimal, 18);
serviceDataSet["OpenControl"].NewRow();
serviceDataSet["OpenControl"].SetValue("@MENU_ID", search.MENU_ID);
serviceDataSet["OpenControl"].SetValue("@ASSEMBLY_ID", search.ASSEMBLY_ID);
serviceDataSet["OpenControl"].SetValue("@USER_ID", Config.Client.GetAttribute("Account.USER_ID"));
return(core.ServiceRequest(serviceDataSet));
}
internal static async Task <IResponse> SearchParentMenuAsync(this ICore core, ModernBrowserSearchParentMenuModel search)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet
{
ServiceName = core.GetAttribute("ServiceName"),
TransactionScope = false
};
serviceDataSet["LoadMenu"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["LoadMenu"].CommandText = search.Procedure;
serviceDataSet["LoadMenu"].AddParameter("@START_MENU_ID", DbType.Decimal, 18);
serviceDataSet["LoadMenu"].AddParameter("@ONLY_PARENT_MENU_ID", DbType.Decimal, 18);
serviceDataSet["LoadMenu"].AddParameter("@USER_ID", DbType.Decimal, 18);
serviceDataSet["LoadMenu"].NewRow();
serviceDataSet["LoadMenu"].SetValue("@START_MENU_ID", search.START_MENU_ID.MinusToDBNullValue());
serviceDataSet["LoadMenu"].SetValue("@ONLY_PARENT_MENU_ID", search.ONLY_PARENT_MENU_ID.MinusToDBNullValue());
serviceDataSet["LoadMenu"].SetValue("@USER_ID", Config.Client.GetAttribute("Account.USER_ID"));
return(await core.ServiceRequestAsync(serviceDataSet));
}
internal static IResponse SearchOpenControl(this ICore core, string DatabaseName, string ProcedureID, decimal MENU_ID, decimal ASSEMBLY_ID)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet
{
ServiceName = core.GetAttribute("ServiceName"),
TransactionScope = false
};
serviceDataSet["OpenControl"].ConnectionName = DatabaseName;
serviceDataSet["OpenControl"].CommandText = ProcedureID;
serviceDataSet["OpenControl"].AddParameter("@MENU_ID", DbType.Decimal, 18);
serviceDataSet["OpenControl"].AddParameter("@ASSEMBLY_ID", DbType.Decimal, 18);
serviceDataSet["OpenControl"].AddParameter("@USER_ID", DbType.Decimal, 18);
serviceDataSet["OpenControl"].NewRow();
serviceDataSet["OpenControl"].SetValue("@MENU_ID", MENU_ID);
serviceDataSet["OpenControl"].SetValue("@ASSEMBLY_ID", ASSEMBLY_ID);
serviceDataSet["OpenControl"].SetValue("@USER_ID", Config.Client.GetAttribute("Account.USER_ID"));
return(core.ServiceRequest(serviceDataSet));
}
internal static IResponse Search(this ICore core, DefaultMenuSearchModel search)
{
IServiceDataSet serviceDataSet;
serviceDataSet = new ServiceDataSet
{
ServiceName = core.GetAttribute("ServiceName"),
TransactionScope = false
};
serviceDataSet["LoadMenu"].ConnectionName = core.GetAttribute("DatabaseName");
serviceDataSet["LoadMenu"].CommandText = core.GetAttribute("ProcedureMenu");
serviceDataSet["LoadMenu"].AddParameter("@START_MENU_ID", DbType.Decimal, 18);
serviceDataSet["LoadMenu"].AddParameter("@ONLY_PARENT_MENU_ID", DbType.Decimal, 18);
serviceDataSet["LoadMenu"].AddParameter("@USER_ID", DbType.Decimal, 18);
serviceDataSet["LoadMenu"].NewRow();
serviceDataSet["LoadMenu"].SetValue("@START_MENU_ID", search.START_MENU_ID.MinusToDBNullValue());
serviceDataSet["LoadMenu"].SetValue("@ONLY_PARENT_MENU_ID", search.ONLY_PARENT_MENU_ID.MinusToDBNullValue());
serviceDataSet["LoadMenu"].SetValue("@USER_ID", Config.Client.GetAttribute("Account.USER_ID"));
return(core.ServiceRequest(serviceDataSet));
}
