سلام
یک کوری دارم که به DataSet پاس دادم و به شکل زیر هست
db.SetCommand(@"Select * From (Select dbo.patients.id as PID,dbo.patients.fname, dbo.patients.lname, dbo.pezeshk.pezeshk_name, dbo.pezeshk.nezam_code, dbo.pezeshk.khadamat_code, dbo.patients.serial,
dbo.patients.sexID, dbo.patients.expr_date, dbo.patients.nos_date, dbo.patients.page_no, dbo.patients.bimar_normal, dbo.patients.bimar_khas, dbo.invoice.tarefe, dbo.invoice.sazman,
dbo.invoice.feranshiz, dbo.khedmat_type.kh_code_khadamat, dbo.pezeshk.pezeshktypeID,(Select Sum(tarefe) From invoice) AS Tarefe_Total,(Select Sum(sazman) From invoice) AS Sazman_Total,(Select Sum(feranshiz) From invoice) AS Feranshiz_Total, row_number() over(partition by dbo.patients.serial, dbo.patients.nos_date_miladi order by dbo.patients.nos_date_miladi) as rnk
FROM dbo.patients INNER JOIN
dbo.pezeshk ON dbo.patients.pezeshkID = dbo.pezeshk.id INNER JOIN
dbo.invoice ON dbo.patients.id = dbo.invoice.patientid INNER JOIN
dbo.khedmat_type ON dbo.invoice.khID = dbo.khedmat_type.id
WHERE dbo.patients.bimeID = '2' AND dbo.patients.khadamatID = '" + comboBox2.SelectedValue + "' AND dbo.patients.centerID = '" + comboBox1.SelectedValue + "' AND dbo.khedmat_type.kh_groupID = '" + comboBox3.SelectedValue + "' AND patients.nos_date BETWEEN '" + Date1.VDate + "' AND '" + Date2.VDate + "')d where rnk = 1 Order By nos_date");
حالا کوری رو به صورت زیر تغییر میدم اما مشکل Syntax میده
db.SetCommand(@"Select * From (SELECT top 100 PERCENT dbo.patients.id AS PID, dbo.patients.fname, dbo.patients.lname, dbo.pezeshk.pezeshk_name, dbo.pezeshk.nezam_code,
dbo.pezeshk.khadamat_code, dbo.patients.serial, dbo.patients.sexID, dbo.patients.expr_date, dbo.patients.nos_date, dbo.patients.page_no,
dbo.patients.bimar_normal, dbo.patients.bimar_khas, dbo.invoice.tarefe, dbo.invoice.sazman, dbo.invoice.feranshiz, dbo.khedmat_type.kh_code_khadamat, dbo.pezeshk.pezeshktypeID,
dbo.khedmat_type.kh_groupID,(Select Sum(tarefe) From dbo.patients INNER JOIN dbo.invoice ON dbo.patients.id = dbo.invoice.patientid INNER JOIN dbo.khedmat_usage ON dbo.patients.id = dbo.khedmat_usage.patientid INNER JOIN dbo.khedmat_type ON dbo.invoice.khID = dbo.khedmat_type.id AND dbo.khedmat_usage.khID = dbo.khedmat_type.id WHERE dbo.patients.bimeID = '2' AND dbo.patients.khadamatID = " +comboBox2.SelectedValue + " AND dbo.patients.centerID = " + comboBox1.SelectedValue +" AND (dbo.khedmat_type.kh_groupID = '1' OR dbo.khedmat_type.kh_groupID = '13') AND patients.nos_date_miladi BETWEEN @Date1 AND @Date2) AS Tarefe_Total,(Select Sum(sazman) From Invoice) AS Tarefe_Total,(Select Sum(sazman) From invoice) AS Sazman_Total,(Select Sum(feranshiz) From invoice) AS Feranshiz_Total,row_number() over(partition by dbo.patients.serial, dbo.patients.nos_date_miladi order by dbo.patients.nos_date_miladi) as rnk
FROM dbo.patients INNER JOIN
dbo.pezeshk ON dbo.patients.pezeshkID = dbo.pezeshk.id INNER JOIN
dbo.invoice ON dbo.patients.id = dbo.invoice.patientid INNER JOIN
dbo.khedmat_type ON dbo.invoice.khID = dbo.khedmat_type.id);
WHERE dbo.patients.bimeID = '2' AND dbo.patients.khadamatID = '" + comboBox2.SelectedValue + "' AND dbo.patients.centerID = '" + comboBox1.SelectedValue + "' AND patients.nos_date BETWEEN '" + Date1.VDate + "' AND '" + Date2.VDate + "')d where rnk = 1 Order By nos_date, CASE kh_groupID WHEN '1' THEN '1' WHEN '13' THEN '13' ELSE 10000 END");
ds = db.GetData();
db.exec();
در قسمت Select کوری در خط 4 ام کوری رو تغییر دادم و یک مقدار دهی کردم با دابل کوتیشن و + + ،،
اما کلی اررور میده مبنی بر نبود علامت ( و Newline in constant .
مشکل چیه ؟
پاسخ با نقل قول
نوشته شده توسط dev-dev-dev
