public async Task <IHttpActionResult> PostWeb_TrzIKala(string ace, string sal, string group, TrzIObject TrzIObject) { var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers); string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "22", 9, 0); if (con == "ok") { string modeCode = UnitPublic.SpiltCodeCama(TrzIObject.ModeCode); string kGruCode = UnitPublic.SpiltCodeCama(TrzIObject.KGruCode); string thvlCode = UnitPublic.SpiltCodeCama(TrzIObject.ThvlCode); string tGruCode = UnitPublic.SpiltCodeCama(TrzIObject.TGruCode); string oprCode = UnitPublic.SpiltCodeCama(TrzIObject.OprCode); string mkzCode = UnitPublic.SpiltCodeCama(TrzIObject.MkzCode); string invCode = UnitPublic.SpiltCodeCama(TrzIObject.InvCode); string statusCode = UnitPublic.SpiltCodeCama(TrzIObject.StatusCode); string sql = string.Format(CultureInfo.InvariantCulture, @"select top (10000) * FROM dbo.Web_TrzIKala('{0}', '{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}') AS TrzI where 1 = 1 ", TrzIObject.azTarikh, TrzIObject.taTarikh, modeCode, kGruCode, thvlCode, tGruCode, mkzCode, oprCode, invCode, statusCode, dataAccount[2] ); sql += UnitPublic.SpiltCodeAnd("KalaCode", TrzIObject.KalaCode); var listTrzI = UnitDatabase.db.Database.SqlQuery <Web_TrzIKala>(sql); return(Ok(listTrzI)); } return(Ok(con)); }
public async Task <IHttpActionResult> PostWeb_TrzIKala(string userName, string password, string ace, string sal, string group, TrzIObject TrzIObject) { if (UnitDatabase.CreateConection(userName, password, ace, sal, group)) { string sql = string.Format(CultureInfo.InvariantCulture, @"select * FROM dbo.Web_TrzIKala('{0}', '{1}') AS TrzI where 1 = 1 ", TrzIObject.azTarikh, TrzIObject.taTarikh); //if (TrzIObject.InvCode != "0") // sql += string.Format(" and InvCode = '{0}' ", TrzIObject.InvCode); if (TrzIObject.KGruCode != "0") { sql += string.Format(" and KGruCode = '{0}' ", TrzIObject.KGruCode); } sql += UnitPublic.SpiltCodeAnd("InvCode", TrzIObject.InvCode); sql += UnitPublic.SpiltCodeAnd("KalaCode", TrzIObject.KalaCode); var listTrzI = UnitDatabase.db.Database.SqlQuery <Web_TrzIKala>(sql); return(Ok(listTrzI)); } return(null); }