public async Task <IHttpActionResult> PostWeb_TrzIKalaExf(string ace, string sal, string group, TrzIExfObject TrzIExfObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "23", 9, 0);
if (con == "ok")
{
string modeCode = UnitPublic.SpiltCodeCama(TrzIExfObject.ModeCode);
string kGruCode = UnitPublic.SpiltCodeCama(TrzIExfObject.KGruCode);
string thvlCode = UnitPublic.SpiltCodeCama(TrzIExfObject.ThvlCode);
string tGruCode = UnitPublic.SpiltCodeCama(TrzIExfObject.TGruCode);
string oprCode = UnitPublic.SpiltCodeCama(TrzIExfObject.OprCode);
string mkzCode = UnitPublic.SpiltCodeCama(TrzIExfObject.MkzCode);
string invCode = UnitPublic.SpiltCodeCama(TrzIExfObject.InvCode);
string statusCode = UnitPublic.SpiltCodeCama(TrzIExfObject.StatusCode);
string sql = string.Format(CultureInfo.InvariantCulture,
@"select top (10000) * FROM dbo.Web_TrzIKalaExf('{0}', '{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}') AS TrzIExf where 1 = 1 ",
TrzIExfObject.azTarikh,
TrzIExfObject.taTarikh,
modeCode,
kGruCode,
thvlCode,
tGruCode,
mkzCode,
oprCode,
invCode,
statusCode,
dataAccount[2]
);
sql += UnitPublic.SpiltCodeAnd("KalaCode", TrzIExfObject.KalaCode);
sql += " order by KalaCode,KalaFileNo,KalaState,KalaExf1,KalaExf2,KalaExf3,KalaExf4,KalaExf5,KalaExf6,KalaExf7,KalaExf8,KalaExf9,KalaExf10,KalaExf11,KalaExf12,KalaExf13,KalaExf14,KalaExf15,InvCode,Tag ";
var listTrzIExf = UnitDatabase.db.Database.SqlQuery <Web_TrzIKalaExf>(sql);
return(Ok(listTrzIExf));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_TrzIKalaExf(string userName, string password, string ace, string sal, string group, TrzIExfObject TrzIExfObject)
{
if (UnitDatabase.CreateConection(userName, password, ace, sal, group))
{
string invCode = UnitPublic.SpiltCodeCama(TrzIExfObject.InvCode);
string sql = string.Format(CultureInfo.InvariantCulture,
@"select * FROM dbo.Web_TrzIKalaExf('{0}', '{1}','{2}') AS TrzIExf where 1 = 1 ",
TrzIExfObject.azTarikh, TrzIExfObject.taTarikh, invCode);
if (TrzIExfObject.KGruCode != "0")
{
sql += string.Format(" and KGruCode = '{0}' ", TrzIExfObject.KGruCode);
}
// sql += UnitPublic.SpiltCodeAnd("InvCode", TrzIExfObject.InvCode);
sql += UnitPublic.SpiltCodeAnd("KalaCode", TrzIExfObject.KalaCode);
sql += " order by KalaCode,KalaFileNo,KalaState,KalaExf1,KalaExf2,KalaExf3,KalaExf4,KalaExf5,KalaExf6,KalaExf7,KalaExf8,KalaExf9,KalaExf10,KalaExf11,KalaExf12,KalaExf13,KalaExf14,KalaExf15,InvCode,Tag ";
var listTrzIExf = UnitDatabase.db.Database.SqlQuery <Web_TrzIKalaExf>(sql);
return(Ok(listTrzIExf));
}
return(null);
}
