public async Task <IHttpActionResult> PostWeb_ErjDocK(string userName, string password, string ace, string sal, string group, ErjDocKObject ErjDocKObject)
{
if (UnitDatabase.CreateConection(userName, password, ace, sal, group))
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"select * FROM Web_ErjDocK('{0}') AS ErjDocK where 1 = 1",
ErjDocKObject.SrchSt);
if (ErjDocKObject.userMode == "USER")
{
sql += string.Format(" and Eghdam = '{0}' ", ErjDocKObject.userName);
}
if (ErjDocKObject.azTarikh != "")
{
sql += string.Format(" and DocDate >= '{0}' ", ErjDocKObject.azTarikh);
}
if (ErjDocKObject.taTarikh != "")
{
sql += string.Format(" and DocDate <= '{0}' ", ErjDocKObject.taTarikh);
}
if (ErjDocKObject.Status != "")
{
sql += string.Format(" and Status = '{0}' ", ErjDocKObject.Status);
}
sql += UnitPublic.SpiltCodeAnd("CustCode", ErjDocKObject.CustCode);
sql += UnitPublic.SpiltCodeAnd("KhdtCode", ErjDocKObject.KhdtCode);
var listTrzI = UnitDatabase.db.Database.SqlQuery <Web_ErjDocK>(sql);
return(Ok(listTrzI));
}
return(null);
}
public async Task <IHttpActionResult> PostWeb_ErjDocK(string ace, string sal, string group, ErjDocKObject ErjDocKObject)
{
if (UnitDatabase.CreateConection(ace, sal, group))
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"select * FROM Web_ErjDocK('{0}') AS ErjDocK where 1 = 1 ",
ErjDocKObject.SrchSt);
if (ErjDocKObject.azTarikh != "")
{
sql += string.Format(" and DocDate >= '{0}' ", ErjDocKObject.azTarikh);
}
if (ErjDocKObject.taTarikh != "")
{
sql += string.Format(" and DocDate <= '{0}' ", ErjDocKObject.taTarikh);
}
if (ErjDocKObject.Status != "")
{
sql += string.Format(" and Status = '{0}' ", ErjDocKObject.Status);
}
if (ErjDocKObject.CustCode != "")
{
sql += " and ( ";
string[] CustCode = ErjDocKObject.CustCode.Split('*');
for (int i = 0; i < CustCode.Length; i++)
{
if (i < CustCode.Length - 1)
{
sql += string.Format(" CustCode = '{0}' Or ", CustCode[i]);
}
else
{
sql += string.Format(" CustCode = '{0}' )", CustCode[i]);
}
}
//sql += string.Format(" and CustCode = '{0}' ", ErjDocKObject.CustCode);
}
if (ErjDocKObject.KhdtCode != "")
{
sql += " and ( ";
string[] KhdtCode = ErjDocKObject.KhdtCode.Split('*');
for (int i = 0; i < KhdtCode.Length; i++)
{
if (i < KhdtCode.Length - 1)
{
sql += string.Format(" KhdtCode = {0} Or ", KhdtCode[i]);
}
else
{
sql += string.Format(" KhdtCode = {0} )", KhdtCode[i]);
}
}
}
var listTrzI = UnitDatabase.db.Database.SqlQuery <Web_ErjDocK>(sql);
return(Ok(listTrzI));
}
return(null);
}