protected override System.Data.Common.DbParameter[] InitParameters(GetDbParameter get)
{
Input(get, System.Data.DbType.String, "@userId", UserId, 16);
Input(get, System.Data.DbType.String, "@password", Password, 32);
Input(get, System.Data.DbType.String, "@ip", Ip, 15);
return(base.InitParameters(get));
}
protected override System.Data.Common.DbParameter[] InitParameters(GetDbParameter get)
{
foreach (string key in inputParams.Keys)
{
Input(get, "@" + key, inputParams[key]);
}
return(base.InitParameters(get));
}
protected void Output(GetDbParameter get, DbType type, string name)
{
DbParameter p = get();
p.Direction = ParameterDirection.Output;
p.DbType = type;
p.ParameterName = name;
param.Add(name, p);
}
internal protected virtual DbParameter[] InitParameters(GetDbParameter get)
{
DbParameter p = get();
p.Direction = ParameterDirection.ReturnValue;
p.DbType = DbType.Int32;
p.ParameterName = "@Return";
param.Add("@Return", p);
return(GetParam());
}
protected void InputOutput(GetDbParameter get, DbType type, string name, object value, int size)
{
DbParameter p = get();
p.Direction = ParameterDirection.InputOutput;
p.DbType = type;
p.ParameterName = name;
p.Value = value;
p.Size = size;
param.Add(name, p);
}
protected void Input(GetDbParameter get, string name, object value)
{
if (value != null)
{
DbParameter p = get();
p.Direction = ParameterDirection.Input;
p.ParameterName = name;
p.Value = value;
param.Add(name, p);
}
}
protected override System.Data.Common.DbParameter[] InitParameters(GetDbParameter get)
{
Input(get, System.Data.DbType.Int32, "@begin", Begin, 4);
Input(get, System.Data.DbType.Int32, "@end", End, 4);
Input(get, System.Data.DbType.String, "@userId", UserId, 16);
Input(get, System.Data.DbType.String, "@userName", UserName, 20);
Input(get, System.Data.DbType.String, "@agentId", AgentId, 10);
Input(get, System.Data.DbType.Int32, "@permId", PermId, 4);
Input(get, System.Data.DbType.Boolean, "@isDelete", IsDelete, 1);
return(base.InitParameters(get));
}
protected override System.Data.Common.DbParameter[] InitParameters(GetDbParameter get)
{
Esunnet.Model.Table.User u = new Table.User();
Input(get, System.Data.DbType.Int32, "@id", Id, 4);
Input(get, System.Data.DbType.String, "@userId", UserId, 16);
Input(get, System.Data.DbType.String, "@password", Passowrd, 32);
Input(get, System.Data.DbType.String, "@userName", UserName, 20);
Input(get, System.Data.DbType.String, "@agentId", AgentId, 10);
Input(get, System.Data.DbType.Int32, "@permId", PermId, 4);
Input(get, System.Data.DbType.String, "@permission", Permission, 2000);
return(base.InitParameters(get));
}
protected override System.Data.Common.DbParameter[] InitParameters(GetDbParameter get)
{
/*
* @ext varchar(10),
* @userIp varchar(15)=null,
* @ip varchar(15)=null,
* @mac char(17)=null,
* @userName varchar(20)
*/
Input(get, System.Data.DbType.String, "@ext", Ext, 10);
Input(get, System.Data.DbType.String, "@userIp", UserIp, 15);
Input(get, System.Data.DbType.String, "@ip", Ip, 15);
Input(get, System.Data.DbType.String, "@mac", Mac, 17);
Input(get, System.Data.DbType.String, "@userName", UserName, 20);
return(base.InitParameters(get));
}
protected override System.Data.Common.DbParameter[] InitParameters(GetDbParameter get)
{
Input(get, System.Data.DbType.Int32, "@id", Id, 4);
Input(get, System.Data.DbType.String, "@permission", Permission, 2000);
return base.InitParameters(get);
}
