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