protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
string strQry0 = "SELECT '' as ID, N'- Бүгд -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_AUTOMARK_TYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")";
string strQry1 = "SELECT '' as ID, N'- Сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_CARCOLORTYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")";
DataSet ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1);
//bind auto mark ddl
pTab1SelectMarktype.DataSource = ds.Tables[0];
pTab1SelectMarktype.DataTextField = "NAME";
pTab1SelectMarktype.DataValueField = "ID";
pTab1SelectMarktype.DataBind();
pTab1ModalSelectMarktype.DataSource = ds.Tables[0];
pTab1ModalSelectMarktype.DataTextField = "NAME";
pTab1ModalSelectMarktype.DataValueField = "ID";
pTab1ModalSelectMarktype.DataBind();
pTab2ModalSelectColortype.DataSource = ds.Tables[1];
pTab2ModalSelectColortype.DataTextField = "NAME";
pTab2ModalSelectColortype.DataValueField = "ID";
pTab2ModalSelectColortype.DataBind();
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
pTab1SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
pTab1SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
pTab3SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
pTab3SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
pTab4SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
pTab4SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
int highyr = DateTime.Now.Year + 10;
int lowyr = DateTime.Now.Year - 25;
for (highyr = DateTime.Now.Year; highyr >= lowyr; highyr--)
{
pTab1SelectYear.Items.Add(new ListItem(highyr.ToString(), highyr.ToString()));
}
pTab1SelectYear.SelectedIndex = pTab1SelectYear.Items.IndexOf(pTab1SelectYear.Items.FindByValue(DateTime.Now.Year.ToString()));
pTab1SelectMonth.SelectedIndex = pTab1SelectMonth.Items.IndexOf(pTab1SelectMonth.Items.FindByValue(DateTime.Now.Month.ToString()));
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
string strQry0 = "SELECT a.ID, a.NAME FROM ( SELECT null as ID, N'- Нийт -' as NAME UNION ALL SELECT ID, NAME FROM TBL_APPOINTMENT_TYPE ) a ORDER BY a.ID";
string strQry1 = "SELECT '' as ID, N'Бүгд' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME+' ('+CAST(CHAIRNUM as varchar)+')' as NAME FROM TBL_ROOM WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")";
ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1);
rprt1Tab1SelectAppointmentType.DataSource = ds.Tables[0];
rprt1Tab1SelectAppointmentType.DataTextField = "NAME";
rprt1Tab1SelectAppointmentType.DataValueField = "ID";
rprt1Tab1SelectAppointmentType.DataBind();
rprt1Tab4SelectRoom.DataSource = ds.Tables[1];
rprt1Tab4SelectRoom.DataTextField = "NAME";
rprt1Tab4SelectRoom.DataValueField = "ID";
rprt1Tab4SelectRoom.DataBind();
myObjModifyDB.DBDisconnectSql();
rprt1Tab1SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab1SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab2SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab2SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab3SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab3SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab4SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab4SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab1BeginDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt1Tab1EndDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt1Tab2BeginDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt1Tab2EndDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt1Tab3BeginDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt1Tab3EndDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt1Tab4BeginDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt1Tab4EndDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt1Tab5t1SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab5t1SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab5t2SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab5t2SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab5t3SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab5t3SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab5t4SelectStartDate.Value = dtime.ToString("yyyy-MM-dd");
rprt1Tab5t4SelectEndDate.Value = dtime.ToString("yyyy-MM-dd");
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
if (Request.QueryString["id"] != null)
{
string strMyVal = "";
string strQry0 = "SELECT a.CODE, a.NAME, CASE WHEN a.TYPE=1 THEN N'Хувь хүн' ELSE N'Байгууллага' END as TYPE, a.TEL, a.TEL2, a.EMAIL, a.ADDRESS, b.NAME as MARK_NAME, a.PRODUCEDYEAR, a.AUTONO, a.VINNO, CASE WHEN a.FUELTYPE=1 THEN N'Бензин' ELSE N'Дизель' END as FUELTYPE, CASE WHEN a.TRANSMISSIONTYPE=1 THEN N'Автомат' ELSE N'Механик' END as TRANSMISSIONTYPE FROM TBL_PATIENT a INNER JOIN TBL_AUTOMARK b ON a.MARK_ID=b.ID WHERE a.ID=" + Request.QueryString["id"];
string strQry1 = "SELECT a.ID, a.DT, a.STARTTIME, a.ENDTIME, b.NAME as ROOM_NAME, a.CHAIRNUM, a.NUM as APPNO, c.LISTDATA as REQUESTTYPELIST, ISNULL(a.REQUESTMEMO,'-') as REQUESTMEMO, ISNULL(d.DIAGNOSTICSUMPRICE,0) as DIAGNOSTICSUMPRICE, f.LISTDATA as DIAGNOSTICTYPELIST, ISNULL(g.DESCRIPTION,'-') as DIAGNOSTICDESCRIPTION, ISNULL(LEFT(h.LNAME,1)+'.'+h.FNAME,'-') as DIAGNOSTICSENIORMECHANICAL_STAFFNAME, ISNULL(LEFT(i.LNAME,1)+'.'+i.FNAME,'-') as DIAGNOSTICSERVICECONSULTANT_STAFFNAME, ISNULL(j.SERVICESUMPRICE,0) as SERVICESUMPRICE, p.NAME as REPAIRTYPENAME, LEFT(q.LNAME,1)+'.'+q.FNAME as REPAIRMECHANICAL_STAFFNAME, LEFT(r.LNAME,1)+'.'+r.FNAME as REPAIRSENIORMECHANICAL_STAFFNAME, LEFT(s.LNAME,1)+'.'+s.FNAME as REPAIRSERVICECONSULTANT_STAFFNAME, k.LISTDATA as SERVICELIST, ISNULL(l.PARTSUMPRICE,0) as PARTSUMPRICE, m.LISTDATA as PARTLIST, ISNULL(n.SUMPRICE,0) as SUMPRICE FROM TBL_APPOINTMENT a INNER JOIN TBL_ROOM b ON a.ROOM_ID=b.ID INNER JOIN ( select APPOINTMENT_ID, ( select ' <span class=\"label bg-color-blueDark\">'+ ISNULL(b.NAME,'')+'</span>' from TBL_APPOINTMENT_REQUESTTYPE a INNER JOIN TBL_REQUESTTYPE b ON a.REQUESTTYPE_ID=b.ID where a.APPOINTMENT_ID = t.APPOINTMENT_ID for XML path('') ) as LISTDATA from ( SELECT DISTINCT a.APPOINTMENT_ID FROM TBL_APPOINTMENT_REQUESTTYPE a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID WHERE b.PATIENT_ID=" + Request.QueryString["id"] + " )t ) c ON a.ID=c.APPOINTMENT_ID LEFT JOIN ( SELECT a.APPOINTMENT_ID, SUM((a.PRICE*CNT)) as DIAGNOSTICSUMPRICE FROM TBL_APPOINTMENT_DIAGNOSTICTYPE a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID WHERE b.PATIENT_ID=" + Request.QueryString["id"] + " GROUP BY a.APPOINTMENT_ID ) d ON a.ID=d.APPOINTMENT_ID LEFT JOIN ( select APPOINTMENT_ID, ( select ' <span class=\"label bg-color-blueDark\">'+ ISNULL(a.NAME,'') + N' <i>/₮'+REPLACE(CONVERT(varchar, CAST(ISNULL(a.PRICE,0) AS money), 1),'.00','')+'/</i></span>' from TBL_APPOINTMENT_DIAGNOSTICTYPE a where a.APPOINTMENT_ID = t.APPOINTMENT_ID for XML path('') ) as LISTDATA from ( SELECT DISTINCT a.APPOINTMENT_ID FROM TBL_APPOINTMENT_DIAGNOSTICTYPE a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID WHERE b.PATIENT_ID=" + Request.QueryString["id"] + " )t ) f ON a.ID=f.APPOINTMENT_ID LEFT JOIN TBL_APPOINTMENT_DIAGNOSTIC g ON a.ID=g.APPOINTMENT_ID LEFT JOIN TBL_STAFF h ON g.SENIORMECHANICAL_STAFFID=h.ID LEFT JOIN TBL_STAFF i ON g.SERVICECONSULTANT_STAFFID = i.ID LEFT JOIN ( SELECT a.APPOINTMENT_ID, SUM((a.SERVICE_PRICE*CNT)) as SERVICESUMPRICE FROM TBL_APPOINTMENT_SERVICE a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID WHERE b.PATIENT_ID=" + Request.QueryString["id"] + " GROUP BY a.APPOINTMENT_ID ) j ON a.ID=j.APPOINTMENT_ID LEFT JOIN ( select APPOINTMENT_ID, ( select '<tr><td>'+ ISNULL(a.SERVICE_CODE,'')+'</td><td>'+ISNULL(a.SERVICE_NAME,'')+'</td><td>'+ISNULL(a.SERVICE_DESCRIPTION,'')+'</td><td>'+ISNULL(a.DESCRIPTION,'')+'</td><td class=\"text-center\">'+ISNULL(CAST(a.CNT as varchar),'')+N'</td><td class=\"text-right\">₮'+REPLACE(CONVERT(varchar, CAST(ISNULL(a.SERVICE_PRICE,0) AS money), 1),'.00','')+N'</td><td class=\"text-right\">₮'+REPLACE(CONVERT(varchar, CAST((ISNULL(a.SERVICE_PRICE,0)*a.CNT) AS money), 1),'.00','')+'</td></tr>' from TBL_APPOINTMENT_SERVICE a where a.APPOINTMENT_ID = t.APPOINTMENT_ID for XML path('') ) as LISTDATA from ( SELECT DISTINCT a.APPOINTMENT_ID FROM TBL_APPOINTMENT_SERVICE a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID WHERE b.PATIENT_ID=" + Request.QueryString["id"] + " )t ) k ON a.ID=k.APPOINTMENT_ID LEFT JOIN ( SELECT a.APPOINTMENT_ID, SUM((a.PART_PRICE*CNT)) as PARTSUMPRICE FROM TBL_APPOINTMENT_PART a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID WHERE b.PATIENT_ID=" + Request.QueryString["id"] + " GROUP BY a.APPOINTMENT_ID ) l ON a.ID=l.APPOINTMENT_ID LEFT JOIN ( select APPOINTMENT_ID, ( select '<tr><td>'+ ISNULL(a.PART_CODE,'')+'</td><td>'+ISNULL(a.PART_NAME,'')+'</td><td>'+ISNULL(a.PART_DESCRIPTION,'')+'</td><td>'+ISNULL(a.DESCRIPTION,'')+'</td><td class=\"text-center\">'+CAST(a.CNT as varchar)+N'</td><td class=\"text-right\">₮'+REPLACE(CONVERT(varchar, CAST(ISNULL(a.PART_PRICE,0) AS money), 1),'.00','')+N'</td><td class=\"text-right\">₮'+REPLACE(CONVERT(varchar, CAST((ISNULL(a.PART_PRICE,0)*a.CNT) AS money), 1),'.00','')+'</td></tr>' from TBL_APPOINTMENT_PART a where a.APPOINTMENT_ID = t.APPOINTMENT_ID for XML path('') ) as LISTDATA from ( SELECT DISTINCT a.APPOINTMENT_ID FROM TBL_APPOINTMENT_PART a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID WHERE b.PATIENT_ID=" + Request.QueryString["id"] + " )t ) m ON a.ID=m.APPOINTMENT_ID LEFT JOIN ( SELECT a.APPOINTMENT_ID, SUM(a.SUMPRICE) as SUMPRICE FROM ( SELECT a.APPOINTMENT_ID, SUM((a.PRICE*CNT)) as SUMPRICE FROM TBL_APPOINTMENT_DIAGNOSTICTYPE a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID WHERE b.PATIENT_ID=" + Request.QueryString["id"] + " GROUP BY a.APPOINTMENT_ID UNION ALL SELECT a.APPOINTMENT_ID, SUM((a.SERVICE_PRICE*CNT)) as SUMPRICE FROM TBL_APPOINTMENT_SERVICE a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID WHERE b.PATIENT_ID=" + Request.QueryString["id"] + " GROUP BY a.APPOINTMENT_ID UNION ALL SELECT a.APPOINTMENT_ID, SUM((a.PART_PRICE*CNT)) as SUMPRICE FROM TBL_APPOINTMENT_PART a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID WHERE b.PATIENT_ID=" + Request.QueryString["id"] + " GROUP BY a.APPOINTMENT_ID ) a GROUP BY a.APPOINTMENT_ID ) n ON a.ID=n.APPOINTMENT_ID LEFT JOIN TBL_APPOINTMENT_REPAIR o ON a.ID=o.APPOINTMENT_ID LEFT JOIN TBL_REPAIRTYPE p ON o.REPAIRTYPE_ID=p.ID LEFT JOIN TBL_STAFF q ON o.MECHANICAL_STAFFID = q.ID LEFT JOIN TBL_STAFF r ON o.SENIORMECHANICAL_STAFFID = r.ID LEFT JOIN TBL_STAFF s ON o.SERVICECONSULTANT_STAFFID = s.ID INNER JOIN TBL_APPOINTMENT_TYPE t ON a.APPOINTMENT_TYPE_ID=t.ID WHERE a.PATIENT_ID=" + Request.QueryString["id"] + " AND a.DT BETWEEN '" + Request.QueryString["begindt"] + "' AND '" + Request.QueryString["enddt"] + "' AND t.ISACTIVESHOW=1 ORDER BY a.DT DESC, a.STARTTIME DESC, a.ENDTIME DESC";
ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1);
appointmentListUl.InnerHtml = "";
if (ds.Tables[1].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
strMyVal += "<li>";
strMyVal += "<div class=\"smart-timeline-icon\"><img src=\"img/staff/male.jpg\" width=\"32\" height=\"32\"></div>";
strMyVal += "<div class=\"smart-timeline-time\"><small>" + dr["DT"].ToString() + " " + dr["STARTTIME"].ToString() + "-" + dr["ENDTIME"].ToString() + "</small></div>";
strMyVal += "<div class=\"smart-timeline-content\">";
strMyVal += "<h3 class=\"margin-top-0\">" + dr["ROOM_NAME"].ToString() + " - <span lang=\"mn\">Өргөгч</span> " + dr["CHAIRNUM"].ToString() + " | <span lang=\"mn\">Захиалгын дугаар</span> #" + dr["APPNO"].ToString() + " | <span lang=\"mn\">Нийт дүн</span>: ₮" + String.Format("{0:C0}", Convert.ToDecimal(dr["SUMPRICE"].ToString())).Replace("$", String.Empty) + "</h3>";
strMyVal += "<h4 class=\"text-primary\" lang=\"mn\">Үйлчлүүлэгчийн хүсэлт</h4>";
strMyVal += "<p>" + dr["REQUESTTYPELIST"].ToString().Replace("<", "<").Replace(">", ">") + "<br><strong><span lang=\"mn\">Хүсэлтийн тэмдэглэл</span>: </strong> <i>" + dr["REQUESTMEMO"].ToString() + "</i></p>";
strMyVal += "<h4 class=\"text-primary\"><span lang=\"mn\">Оношлогоо</span> <i>/₮" + String.Format("{0:C0}", Convert.ToDecimal(dr["DIAGNOSTICSUMPRICE"].ToString())).Replace("$", String.Empty) + "/</i></h4>";
strMyVal += "<p>" + dr["DIAGNOSTICTYPELIST"].ToString().Replace("<", "<").Replace(">", ">") + "<br><strong lang=\"mn\">Дүгнэлт:</strong> <i>" + dr["DIAGNOSTICDESCRIPTION"].ToString() + "</i><br><strong lang=\"mn\">Дүгнэлт гаргасан ахлах механик:</strong> <i>" + dr["DIAGNOSTICSENIORMECHANICAL_STAFFNAME"].ToString() + "</i> <strong lang=\"mn\">Дүгнэлт гаргасан үйлчилгээний зөвлөх:</strong> <i>" + dr["DIAGNOSTICSERVICECONSULTANT_STAFFNAME"].ToString() + "</i></p>";
strMyVal += "<h4 class=\"text-primary\"><span lang=\"mn\">Засвар үйлчилгээ</span> <i>/₮" + String.Format("{0:C0}", Convert.ToDecimal(dr["SERVICESUMPRICE"].ToString())).Replace("$", String.Empty) + "/</i></h4>";
strMyVal += "<p><span class=\"label bg-color-blueDark\">" + dr["REPAIRTYPENAME"].ToString() + "</span><br><strong lang=\"mn\">Механик:</strong> <i>" + dr["REPAIRMECHANICAL_STAFFNAME"].ToString() + "</i> <strong lang=\"mn\">Ахлах механик:</strong> <i>" + dr["REPAIRSENIORMECHANICAL_STAFFNAME"].ToString() + "</i> <strong lang=\"mn\">Үйлчилгээний зөвлөх:</strong> <i>" + dr["REPAIRSERVICECONSULTANT_STAFFNAME"].ToString() + "</i></p>";
strMyVal += "<div><table class=\"table table-hover\"><thead><tr><th lang=\"mn\">Код</th><th lang=\"mn\">ЗҮ нэр</th><th lang=\"mn\">ЗҮ тайлбар</th><th lang=\"mn\">ЗҮ авсан тайлбар</th><th class=\"text-center\" lang=\"mn\">/ш/</th><th class=\"text-right\" lang=\"mn\">Нэгж үнэ</th><th class=\"text-right\" lang=\"mn\">Нийт үнэ</th></tr></thead><tbody>" + dr["SERVICELIST"].ToString().Replace("<", "<").Replace(">", ">") + "</tbody></table></div>";
strMyVal += "<h4 class=\"text-primary\"><span lang=\"mn\">Солисон сэлбэг</span> <i>/₮" + String.Format("{0:C0}", Convert.ToDecimal(dr["PARTSUMPRICE"].ToString())).Replace("$", String.Empty) + "/</i></h4>";
strMyVal += "<div><table class=\"table table-hover\"><thead><tr><th lang=\"mn\">Код</th><th lang=\"mn\">Сэлбэг нэр</th><th lang=\"mn\">Сэлбэг тайлбар</th><th lang=\"mn\">Сэлбэг авсан тайлбар</th><th class=\"text-center\" lang=\"mn\">/ш/</th><th class=\"text-right\" lang=\"mn\">Нэгж үнэ</th><th class=\"text-right\" lang=\"mn\">Нийт үнэ</th></tr></thead><tbody>" + dr["PARTLIST"].ToString().Replace("<", "<").Replace(">", ">") + "</tbody></table></div>";
strMyVal += "</div>";
strMyVal += "</li>";
}
appointmentListUl.InnerHtml = strMyVal;
}
}
else
{
Response.Redirect("~/#pg/error500.aspx");
}
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
if (Request.QueryString["id"] != null)
{
ModifyDB myObjModifyDB = new ModifyDB();
string strQry0 = "SELECT ID, NAME, CLINIC_ID FROM TBL_TASK_MISSIONTYPE WHERE ID=" + Request.QueryString["id"];
string strQry1 = "SELECT ID, CAST(NO as varchar)+'. '+NAME as NAME FROM TBL_TASK_STAT_TYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_TASK_MISSIONTYPE WHERE ID=" + Request.QueryString["id"] + ") ORDER BY NO";
string strQry2 = "SELECT ID, NAME, COLOR FROM TBL_TASK_MISSIONEVALTYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_TASK_MISSIONTYPE WHERE ID=" + Request.QueryString["id"] + ") ORDER BY ID";
string strQry3 = @"SELECT
a.ID
, LEFT(a.LNAME, 1) + '.' + a.FNAME + ' | ' + b.NAME as NAME
FROM TBL_STAFF a
INNER JOIN TBL_STAFF_POSITION b ON a.STAFF_POSITION_ID = b.ID
WHERE a.CLINIC_ID = (SELECT CLINIC_ID FROM TBL_TASK_MISSIONTYPE WHERE ID=" + Request.QueryString["id"] + @") AND a.ISACTIVE = 1
ORDER BY LEFT(a.LNAME, 1) + '.' + a.FNAME";
ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1 + " " + strQry2 + " " + strQry3);
headTitleName.InnerHtml = ds.Tables[0].Rows[0]["NAME"].ToString().ToUpper();
modalHeadTitleName.InnerHtml = ds.Tables[0].Rows[0]["NAME"].ToString();
pTab1SelectType.DataSource = ds.Tables[1];
pTab1SelectType.DataTextField = "NAME";
pTab1SelectType.DataValueField = "ID";
pTab1SelectType.DataBind();
pTab1ModalSelectType.DataSource = ds.Tables[1];
pTab1ModalSelectType.DataTextField = "NAME";
pTab1ModalSelectType.DataValueField = "ID";
pTab1ModalSelectType.DataBind();
pTab1SelectMissionType.DataSource = ds.Tables[2];
pTab1SelectMissionType.DataTextField = "NAME";
pTab1SelectMissionType.DataValueField = "ID";
pTab1SelectMissionType.DataBind();
pTab1SelectStaff.DataSource = ds.Tables[3];
pTab1SelectStaff.DataTextField = "NAME";
pTab1SelectStaff.DataValueField = "ID";
pTab1SelectStaff.DataBind();
pTab1ModalSelectCreatedStaff.DataSource = ds.Tables[3];
pTab1ModalSelectCreatedStaff.DataTextField = "NAME";
pTab1ModalSelectCreatedStaff.DataValueField = "ID";
pTab1ModalSelectCreatedStaff.DataBind();
}
else
{
Response.Redirect("~/");
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
ds = myObjModifyDB.ExecuteDataSet("SELECT a.ID, a.NAME FROM ( SELECT CAST(ID as varchar) as ID, NAME FROM TBL_PART_TYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ) a ORDER BY a.ID");
partTab1SelectPartType.DataSource = ds.Tables[0];
partTab1SelectPartType.DataTextField = "NAME";
partTab1SelectPartType.DataValueField = "ID";
partTab1SelectPartType.DataBind();
partTab1ModalSelectPartType.DataSource = ds.Tables[0];
partTab1ModalSelectPartType.DataTextField = "NAME";
partTab1ModalSelectPartType.DataValueField = "ID";
partTab1ModalSelectPartType.DataBind();
partTab3SelectPartType.DataSource = ds.Tables[0];
partTab3SelectPartType.DataTextField = "NAME";
partTab3SelectPartType.DataValueField = "ID";
partTab3SelectPartType.DataBind();
partTab4SelectPartType.DataSource = ds.Tables[0];
partTab4SelectPartType.DataTextField = "NAME";
partTab4SelectPartType.DataValueField = "ID";
partTab4SelectPartType.DataBind();
partTab3ModalSelectPartType.DataSource = ds.Tables[0];
partTab3ModalSelectPartType.DataTextField = "NAME";
partTab3ModalSelectPartType.DataValueField = "ID";
partTab3ModalSelectPartType.DataBind();
partTab1ModalExcelSelectPartType.DataSource = ds.Tables[0];
partTab1ModalExcelSelectPartType.DataTextField = "NAME";
partTab1ModalExcelSelectPartType.DataValueField = "ID";
partTab1ModalExcelSelectPartType.DataBind();
partTab4SelectStartDate.Value = DateTime.Today.AddDays(((int)(DateTime.Today.DayOfWeek) * -1) + 1).ToString("yyyy-MM-dd");
partTab4SelectEndDate.Value = DateTime.Today.AddDays(((int)(DateTime.Today.DayOfWeek) * -1) + 7).ToString("yyyy-MM-dd");
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
public static void UPT_TASKMISSION(string ID, string MISSIONTYPE_ID, string TASK_STAT_TYPE_ID, string NO, string NAME, string DT, string MEMO, string CREATEDSTAFFID, string CREATEDUSERID, string STAFFLIST, string USERLIST, string FILENAME)
{
ModifyDB myObjModifyDB = new ModifyDB();
string[] ParamName = new string[12], ParamValue = new string[12];
try
{
ParamName[0] = "@ID";
ParamName[1] = "@MISSIONTYPE_ID";
ParamName[2] = "@TASK_STAT_TYPE_ID ";
ParamName[3] = "@NO";
ParamName[4] = "@NAME";
ParamName[5] = "@DT";
ParamName[6] = "@MEMO";
ParamName[7] = "@CREATEDSTAFFID";
ParamName[8] = "@CREATEDUSERID";
ParamName[9] = "@STAFFLIST";
ParamName[10] = "@USERLIST";
ParamName[11] = "@FILENAME";
ParamValue[0] = ID;
ParamValue[1] = MISSIONTYPE_ID;
ParamValue[2] = TASK_STAT_TYPE_ID;
ParamValue[3] = NO;
ParamValue[4] = NAME;
ParamValue[5] = DT;
ParamValue[6] = MEMO;
ParamValue[7] = CREATEDSTAFFID;
ParamValue[8] = CREATEDUSERID;
ParamValue[9] = STAFFLIST;
ParamValue[10] = USERLIST;
ParamValue[11] = FILENAME;
myObjModifyDB.SP_ExecuteNonQuery("UPT_TASKMISSION", ParamName, ParamValue);
}
catch (cs.MyException ex)
{
HttpContext.Current.Session["error500"] = "Message: " + ex.Message + "<br/>StackTrace: " + ex.StackTrace;
cs.WriteLogForEx.WriteLog(ex);
throw ex;
}
catch (Exception ex)
{
HttpContext.Current.Session["error500"] = "Message: " + ex.Message + "<br/>StackTrace: " + ex.StackTrace;
cs.WriteLogForEx.WriteLog(ex);
throw ex;
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
if (Request.QueryString["id"] != null)
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
string strQry0 = "SELECT a.ID, a.CODE, a.IDCARD, a.FNAME, a.LNAME, a.MNAME, a.BIRTHDATE, a.TEL, a.TEL2, a.EMAIL, a.ADDRESS, CASE WHEN a.GENDER=1 THEN N'Эр' ELSE N'Эм' END AS GENDER, ISNULL(a.PICTURE,'male.jpg') as PICTURE, b.NAME as POSITIONNAME, CASE WHEN a.ISACTIVE=1 THEN '<span class=\"label label-success\">ACTIVE</span>' ELSE '<span class=\"label label-default\">OFF</span>' END as TYPE FROM TBL_STAFF a INNER JOIN TBL_STAFF_POSITION b ON a.STAFF_POSITION_ID=b.ID WHERE a.ID=" + Request.QueryString["id"] + " ORDER BY CODE";
ds = myObjModifyDB.ExecuteDataSet(strQry0);
if (ds.Tables[0].Rows[0]["PICTURE"].ToString() == "")
{
staffImage.Src = "../img/staff/male.jpg";
}
else
{
staffImage.Src = "../img/staff/" + ds.Tables[0].Rows[0]["PICTURE"].ToString();
}
staffDetail.InnerHtml = ds.Tables[0].Rows[0]["TYPE"].ToString() + "<br><br><span lang=\"mn\">Код:</span> " + ds.Tables[0].Rows[0]["CODE"].ToString() + "<br><br><span lang=\"mn\">" + ds.Tables[0].Rows[0]["GENDER"].ToString() + "</span>";
staffNamePosition.InnerHtml = ds.Tables[0].Rows[0]["LNAME"].ToString() + " <span class=\"semi-bold\">" + ds.Tables[0].Rows[0]["FNAME"].ToString() + "</span><br><small>" + ds.Tables[0].Rows[0]["POSITIONNAME"].ToString() + "</small>";
staffMname.InnerHtml = ds.Tables[0].Rows[0]["MNAME"].ToString();
staffIDCard.InnerHtml = ds.Tables[0].Rows[0]["IDCARD"].ToString();
staffBirthday.InnerHtml = ds.Tables[0].Rows[0]["BIRTHDATE"].ToString();
staffPhone.InnerHtml = ds.Tables[0].Rows[0]["TEL"].ToString() + " " + ds.Tables[0].Rows[0]["TEL2"].ToString();
staffEmail.InnerHtml = ds.Tables[0].Rows[0]["EMAIL"].ToString();
staffAddress.InnerHtml = ds.Tables[0].Rows[0]["ADDRESS"].ToString();
//createdInfo.InnerHtml = ds.Tables[0].Rows[0]["CREATED_STAFFID"].ToString() + " " + ds.Tables[0].Rows[0]["CREATED_DATE"].ToString();
//updatedInfo.InnerHtml = ds.Tables[0].Rows[0]["UPDATED_STAFFID"].ToString() + " " + ds.Tables[0].Rows[0]["UPDATED_DATE"].ToString();
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
ds = myObjModifyDB.ExecuteDataSet("SELECT a.ID, a.NAME FROM ( SELECT CAST(ID as varchar) as ID, NAME FROM TBL_SERVICE_TYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ) a ORDER BY a.ID");
serviceTab1SelectServiceType.DataSource = ds.Tables[0];
serviceTab1SelectServiceType.DataTextField = "NAME";
serviceTab1SelectServiceType.DataValueField = "ID";
serviceTab1SelectServiceType.DataBind();
serviceTab1ModalSelectServiceType.DataSource = ds.Tables[0];
serviceTab1ModalSelectServiceType.DataTextField = "NAME";
serviceTab1ModalSelectServiceType.DataValueField = "ID";
serviceTab1ModalSelectServiceType.DataBind();
serviceTab3SelectServiceType.DataSource = ds.Tables[0];
serviceTab3SelectServiceType.DataTextField = "NAME";
serviceTab3SelectServiceType.DataValueField = "ID";
serviceTab3SelectServiceType.DataBind();
serviceTab3ModalSelectServiceType.DataSource = ds.Tables[0];
serviceTab3ModalSelectServiceType.DataTextField = "NAME";
serviceTab3ModalSelectServiceType.DataValueField = "ID";
serviceTab3ModalSelectServiceType.DataBind();
serviceTab1ModalExcelSelectServiceType.DataSource = ds.Tables[0];
serviceTab1ModalExcelSelectServiceType.DataTextField = "NAME";
serviceTab1ModalExcelSelectServiceType.DataValueField = "ID";
serviceTab1ModalExcelSelectServiceType.DataBind();
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
if (Request.QueryString["id"] != null)
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
string strQry0 = "SELECT a.CODE, a.NAME, CASE WHEN a.TYPE=1 THEN N'Хувь хүн' ELSE N'Байгууллага' END as TYPE, a.TEL, a.TEL2, a.EMAIL, a.ADDRESS, b.NAME as MARK_NAME, a.PRODUCEDYEAR, a.AUTONO, a.VINNO, CASE WHEN a.FUELTYPE=1 THEN N'Бензин' ELSE N'Дизель' END as FUELTYPE, CASE WHEN a.TRANSMISSIONTYPE=1 THEN N'Автомат' ELSE N'Механик' END as TRANSMISSIONTYPE, CREATED_STAFFID, CREATED_DATE, UPDATED_STAFFID, UPDATED_DATE, CASE WHEN a.ISMYSOLD=1 THEN N'Тийм' ELSE N'Үгүй' END as ISMYSOLDNAME FROM TBL_PATIENT a INNER JOIN TBL_AUTOMARK b ON a.MARK_ID=b.ID WHERE a.ID=" + Request.QueryString["id"];
ds = myObjModifyDB.ExecuteDataSet(strQry0);
patientCode.InnerHtml = ds.Tables[0].Rows[0]["CODE"].ToString();
patientName.InnerHtml = ds.Tables[0].Rows[0]["NAME"].ToString();
patientType.InnerHtml = ds.Tables[0].Rows[0]["TYPE"].ToString();
patientTel.InnerHtml = ds.Tables[0].Rows[0]["TEL"].ToString();
patientTel2.InnerHtml = ds.Tables[0].Rows[0]["TEL2"].ToString();
patientEmail.InnerHtml = ds.Tables[0].Rows[0]["EMAIL"].ToString();
patientAddress.InnerHtml = ds.Tables[0].Rows[0]["ADDRESS"].ToString();
patientAutoMark.InnerHtml = ds.Tables[0].Rows[0]["MARK_NAME"].ToString();
patientAutoYear.InnerHtml = ds.Tables[0].Rows[0]["PRODUCEDYEAR"].ToString();
patientAutoNo.InnerHtml = ds.Tables[0].Rows[0]["AUTONO"].ToString();
patientAutoVinNo.InnerHtml = ds.Tables[0].Rows[0]["VINNO"].ToString();
patientFuelType.InnerHtml = ds.Tables[0].Rows[0]["FUELTYPE"].ToString();
patientTransmission.InnerHtml = ds.Tables[0].Rows[0]["TRANSMISSIONTYPE"].ToString();
createdInfo.InnerHtml = ds.Tables[0].Rows[0]["CREATED_STAFFID"].ToString() + " " + ds.Tables[0].Rows[0]["CREATED_DATE"].ToString();
updatedInfo.InnerHtml = ds.Tables[0].Rows[0]["UPDATED_STAFFID"].ToString() + " " + ds.Tables[0].Rows[0]["UPDATED_DATE"].ToString();
patientIsMySold.InnerHtml = ds.Tables[0].Rows[0]["ISMYSOLDNAME"].ToString();
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
DataSet ds = myObjModifyDB.ExecuteDataSet("SELECT a.ID, a.NAME FROM ( SELECT '' as ID, N'-Албан тушаал-' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_STAFF_POSITION WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ) a ORDER BY a.ID");
staffTab1ModalSelectRole.DataSource = ds.Tables[0];
staffTab1ModalSelectRole.DataTextField = "NAME";
staffTab1ModalSelectRole.DataValueField = "ID";
staffTab1ModalSelectRole.DataBind();
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
string strQry0 = "SELECT ID, NAME FROM TBL_CLINIC WHERE ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")";
string strQry1 = "select USER_ID, USERNAME, stuff( ( select ','+ CAST(ROLE_ID as varchar) from TBL_USER_ROLE where USER_ID = t.USER_ID for XML path('') ),1,1,'') as LISTDATA from ( SELECT DISTINCT ID as USER_ID, USERNAME FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + " )t";
string strQry2 = "SELECT ID, NAME FROM TBL_TASK_MISSIONTYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ORDER BY ID";
DataSet ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1 + " " + strQry2);
indexStaffId.InnerHtml = Session["eBook_UserID"].ToString();
indexClinicId.InnerHtml = ds.Tables[0].Rows[0]["ID"].ToString();
indexClinicName.InnerHtml = ds.Tables[0].Rows[0]["NAME"].ToString();
indexUserName.InnerHtml = ds.Tables[1].Rows[0]["USERNAME"].ToString();
indexUserRolesId.InnerHtml = ds.Tables[1].Rows[0]["LISTDATA"].ToString().Trim();
indexSessionID.InnerHtml = Session.SessionID;
bool boolPatient = false, boolStaff = false, boolService = false, boolPart = false, boolSetup = false, boolReport = false;
for (int i = 0; i < ds.Tables[1].Rows[0]["LISTDATA"].ToString().Trim().Split(',').Length; i++)
{
if (ds.Tables[1].Rows[0]["LISTDATA"].ToString().Trim().Split(',')[i] == "1")
{
boolPatient = true; boolStaff = true; boolService = true; boolPart = true; boolSetup = true; boolReport = true;
break;
}
else if (ds.Tables[1].Rows[0]["LISTDATA"].ToString().Trim().Split(',')[i] == "2")
{
boolPatient = true;
}
else if (ds.Tables[1].Rows[0]["LISTDATA"].ToString().Trim().Split(',')[i] == "7")
{
boolStaff = true;
}
else if (ds.Tables[1].Rows[0]["LISTDATA"].ToString().Trim().Split(',')[i] == "8")
{
boolService = true;
}
else if (ds.Tables[1].Rows[0]["LISTDATA"].ToString().Trim().Split(',')[i] == "9")
{
boolPart = true;
}
else if (ds.Tables[1].Rows[0]["LISTDATA"].ToString().Trim().Split(',')[i] == "10")
{
boolSetup = true;
}
else if (ds.Tables[1].Rows[0]["LISTDATA"].ToString().Trim().Split(',')[i] == "11")
{
boolReport = true;
}
}
if (!boolPatient)
{
indexMenuPatient.Attributes.Add("class", "hide");
}
if (!boolStaff)
{
indexMenuStaff.Attributes.Add("class", "hide");
}
if (!boolService)
{
indexMenuService.Attributes.Add("class", "hide");
}
if (!boolPart)
{
indexMenuPart.Attributes.Add("class", "hide");
}
if (!boolSetup)
{
indexMenuSetup.Attributes.Add("class", "hide");
}
if (!boolReport)
{
indexMenuReport.Attributes.Add("class", "hide");
}
//taskmission
strreturnval = "<li><a href = \"pg/taskstat.aspx\" lang=\"mn\" ><i class=\"fa fa-globe\"></i> Статистик</a></li>";
if (ds.Tables[2].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[2].Rows)
{
strreturnval += "<li><a href = \"pg/taskmission.aspx?id=" + dr["ID"].ToString() + "\" lang = \"mn\" ><i class=\"fa fa-globe\"></i> " + dr["NAME"].ToString() + "</a></li>";
}
}
strreturnval += "<li><a href = \"pg/tasknews.aspx\" lang=\"mn\" ><i class=\"fa fa-globe\"></i> Мэдээ мэдээлэл</a></li>";
indexTaskUl.InnerHtml = strreturnval;
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
throw ex;
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
throw ex;
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
string strQry0 = "SELECT 1";
string strQry1 = "SELECT ID, NAME FROM TBL_REQUESTTYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ORDER BY ID";
string strQry2 = "SELECT a.ID, a.AUTONO, a.NAME, b.NAME as MARK_NAME, a.PRODUCEDYEAR FROM TBL_PATIENT a INNER JOIN TBL_AUTOMARK b ON a.MARK_ID=b.ID WHERE a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ORDER BY a.CODE";
string strQry3 = "SELECT ID, NAME, CHAIRNUM FROM TBL_ROOM WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ORDER BY ID";
string strQry4 = "SELECT (SELECT VALUE FROM TBL_SETUP WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") AND KEYCODE='calendarstarttime')+'~'+(SELECT VALUE FROM TBL_SETUP WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") AND KEYCODE='calendarendtime')+'~'+(SELECT VALUE FROM TBL_SETUP WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") AND KEYCODE='calendarinterval')+'~'+(SELECT VALUE FROM TBL_SETUP WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") AND KEYCODE='calendarlunchstarttime')+'~'+(SELECT VALUE FROM TBL_SETUP WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") AND KEYCODE='calendarlunchendtime')";
string strQry5 = "SELECT a.ID, a.NAME FROM ( SELECT '' as ID, N'- Сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_AUTOMARK WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ) a ORDER BY a.NAME";
string strQry6 = "SELECT a.ID, a.NAME FROM ( SELECT '' as ID, N'- Заал сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_ROOM WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ) a ORDER BY a.ID";
string strQry7 = @"SELECT a.ID, a.NAME
FROM (
SELECT '' as ID, N'- Сонго -' as NAME
UNION ALL
SELECT CAST(a.ID as varchar) as ID, a.FNAME+'.'+LEFT(a.LNAME,1)+' | '+b.NAME as NAME
FROM TBL_STAFF a
INNER JOIN TBL_STAFF_POSITION b ON a.STAFF_POSITION_ID=b.ID
WHERE
a.ISACTIVE=1
AND a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + @")
AND a.ID IN (SELECT a.STAFF_ID
FROM TBL_USER_STAFF a
INNER JOIN TBL_USER b ON a.[USER_ID]=b.ID
INNER JOIN TBL_USER_ROLE c ON b.ID=c.[USER_ID]
WHERE c.ROLE_ID = 2)
) a ORDER BY a.NAME";
string strQry8 = "SELECT ID, NAME FROM TBL_DIAGNOSTICTYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ORDER BY ID";
string strQry9 = "SELECT ID, NAME FROM TBL_REPAIRTYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ORDER BY ID";
string strQry10 = "SELECT ID, NAME FROM TBL_SERVICE_TYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")";
string strQry11 = "SELECT ID, CODE+' '+NAME as NAME FROM TBL_SERVICE WHERE SERVICE_TYPE_ID=(SELECT MIN(ID) FROM TBL_SERVICE_TYPE WHERE ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")) ORDER BY CODE";
string strQry12 = "SELECT ID, NAME FROM TBL_PART_TYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")";
string strQry13 = "SELECT ID, CODE+' '+NAME as NAME FROM TBL_PART WHERE PART_TYPE_ID=(SELECT MIN(ID) FROM TBL_SERVICE_TYPE WHERE ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")) ORDER BY CODE";
string strQry14 = "SELECT ROOM_ID, CHAIR, TITLE FROM TBL_ROOMTITLE ORDER BY ROOM_ID, CHAIR";
string strQry15 = "SELECT a.ID, a.NAME FROM ( SELECT '' as ID, N'- Сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_AUTOMARK_TYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ) a ORDER BY a.NAME";
//ahlah mehanik
string strQry16 = @"SELECT a.ID, a.NAME
FROM (
SELECT '' as ID, N'- Сонго -' as NAME
UNION ALL
SELECT CAST(a.ID as varchar) as ID, a.FNAME+'.'+LEFT(a.LNAME,1)+' | '+b.NAME as NAME
FROM TBL_STAFF a
INNER JOIN TBL_STAFF_POSITION b ON a.STAFF_POSITION_ID=b.ID
WHERE a.ISACTIVE=1 AND a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + @") AND a.STAFF_POSITION_ID IN (SELECT STAFF_POSITION_ID FROM TBL_JOBPOSITION WHERE ID=1)
) a
ORDER BY a.NAME";
//mehanik
string strQry17 = @"SELECT a.ID, a.NAME
FROM (
SELECT '' as ID, N'- Сонго -' as NAME
UNION ALL
SELECT CAST(a.ID as varchar) as ID, a.FNAME+'.'+LEFT(a.LNAME,1)+' | '+b.NAME as NAME
FROM TBL_STAFF a
INNER JOIN TBL_STAFF_POSITION b ON a.STAFF_POSITION_ID=b.ID
WHERE a.ISACTIVE=1 AND a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + @") AND a.STAFF_POSITION_ID IN (SELECT STAFF_POSITION_ID FROM TBL_JOBPOSITION WHERE ID=2)
) a
ORDER BY a.NAME";
//uilchilgeenii zuwluh
string strQry18 = @"SELECT a.ID, a.NAME
FROM (
SELECT '' as ID, N'- Сонго -' as NAME
UNION ALL
SELECT CAST(a.ID as varchar) as ID, a.FNAME+'.'+LEFT(a.LNAME,1)+' | '+b.NAME as NAME
FROM TBL_STAFF a
INNER JOIN TBL_STAFF_POSITION b ON a.STAFF_POSITION_ID=b.ID
WHERE a.ISACTIVE=1 AND a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + @") AND a.STAFF_POSITION_ID IN (SELECT STAFF_POSITION_ID FROM TBL_JOBPOSITION WHERE ID=3)
) a
ORDER BY a.NAME";
//Patient discount list
string strQry19 = @"SELECT ID, VALUE, NAME, PER FROM TBL_PATIENTDISCOUNT ORDER BY PER";
strreturnval = "<div class=\"inline-group\">";
ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1 + " " + strQry2 + " " + strQry3 + " " + strQry4 + " " + strQry5 + " " + strQry6 + " " + strQry7 + " " + strQry8 + " " + strQry9 + " " + strQry10 + " " + strQry11 + " " + strQry12 + " " + strQry13 + " " + strQry14 + " " + strQry15 + " " + strQry16 + " " + strQry17 + " " + strQry18 + " " + strQry19);
if (ds.Tables[1].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
strreturnval += "<label class=\"checkbox margin-right-5 font-sm\"><input id=\"calendarInputRequest" + dr["ID"].ToString() + "\" name=\"calendarInputRequest\" type=\"checkbox\" value=\"" + dr["ID"].ToString() + "\"><i></i><span>" + dr["NAME"].ToString() + "</span></label>";
strreturnval2 += "<label class=\"checkbox margin-right-5 font-sm\"><input id=\"calendarAppointmentModalInputRequest" + dr["ID"].ToString() + "\" name=\"calendarAppointmentModalInputRequest\" type=\"checkbox\" value=\"" + dr["ID"].ToString() + "\"><i></i><span>" + dr["NAME"].ToString() + "</span></label>";
}
strreturnval += "</div>";
calendarAppInsertRequestsDiv.InnerHtml = strreturnval;
calendarAppModalRequestsDiv.InnerHtml = strreturnval2;
}
//draw calendar patient datatable
strreturnval = "";
//draw block header
calendarBlockHeaderListDiv.InnerHtml = "<ul class=\"nav nav-tabs pull-right in\">";
if (ds.Tables[3].Rows.Count != 0)
{
string strcalendarCurrentRoomChiarNumArr = "";
string strChairTitle = "";
foreach (DataRow dr in ds.Tables[3].Rows)
{
strcalendarCurrentRoomChiarNumArr = "[";
strChairTitle = "";
DataRow[] drS;
for (int i = 1; i <= Int32.Parse(dr["CHAIRNUM"].ToString()); i++)
{
if (strcalendarCurrentRoomChiarNumArr != "[")
{
strcalendarCurrentRoomChiarNumArr += ",";
}
strChairTitle = "";
drS = ds.Tables[14].Select("ROOM_ID=" + dr["ID"].ToString() + " AND CHAIR=" + i.ToString());
if (drS != null && drS.Length > 0)
{
strChairTitle = " " + drS[0]["TITLE"].ToString();
}
strcalendarCurrentRoomChiarNumArr += "{ \"id\": \"" + i.ToString() + "\", \"title\": \"" + i.ToString() + " " + strChairTitle + "\" }";
}
strcalendarCurrentRoomChiarNumArr += "]";
if (calendarBlockHeaderListDiv.InnerHtml == "<ul class=\"nav nav-tabs pull-right in\">")
{
calendarCurrentRoomId.InnerHtml = dr["ID"].ToString();
calendarBlockHeaderListDiv.InnerHtml += "<li class=\"active\"><a data-toggle=\"tab\" href=\"\" data-roomid=\"" + dr["ID"].ToString() + "\" class=\"calendarBlockClick\"><span class=\"hide\">" + strcalendarCurrentRoomChiarNumArr + "</span><i class=\"fa fa-desktop\"></i> " + dr["NAME"].ToString() + " (" + dr["CHAIRNUM"].ToString() + ")</a></li>";
calendarCurrentRoomChiarNumArr.InnerHtml = strcalendarCurrentRoomChiarNumArr;
}
else
{
calendarBlockHeaderListDiv.InnerHtml += "<li><a data-toggle=\"tab\" href=\"\" data-roomid=\"" + dr["ID"].ToString() + "\" class=\"calendarBlockClick\"><span class=\"hide\">" + strcalendarCurrentRoomChiarNumArr + "</span><i class=\"fa fa-desktop\"></i> " + dr["NAME"].ToString() + " (" + dr["CHAIRNUM"].ToString() + ")</a></li>";
}
}
}
calendarBlockHeaderListDiv.InnerHtml += "</ul>";
//set settings
calendarSettings.InnerHtml = ds.Tables[4].Rows[0][0].ToString();
//insert appointment modal automark
calendarSelectAutomarkType.DataSource = ds.Tables[15];
calendarSelectAutomarkType.DataTextField = "NAME";
calendarSelectAutomarkType.DataValueField = "ID";
calendarSelectAutomarkType.DataBind();
patientModalSelectAutomarkType.DataSource = ds.Tables[15];
patientModalSelectAutomarkType.DataTextField = "NAME";
patientModalSelectAutomarkType.DataValueField = "ID";
patientModalSelectAutomarkType.DataBind();
if (ds.Tables[15].Rows.Count > 2)
{
calendarSelectAutomarkType.SelectedIndex = 0;
calendarSelectAutomarkType.Disabled = false;
calendarSelectAutomark.Disabled = true;
patientModalSelectAutomarkType.SelectedIndex = 0;
patientModalSelectAutomarkType.Disabled = false;
patientModalSelectAutomark.Disabled = true;
}
else if (ds.Tables[15].Rows.Count == 2)
{
calendarSelectAutomarkType.SelectedIndex = 1;
calendarSelectAutomarkType.Disabled = true;
calendarSelectAutomark.Disabled = false;
patientModalSelectAutomarkType.SelectedIndex = 1;
patientModalSelectAutomarkType.Disabled = true;
patientModalSelectAutomark.Disabled = false;
calendarSelectAutomark.DataSource = ds.Tables[5];
calendarSelectAutomark.DataTextField = "NAME";
calendarSelectAutomark.DataValueField = "ID";
calendarSelectAutomark.DataBind();
patientModalSelectAutomark.DataSource = ds.Tables[5];
patientModalSelectAutomark.DataTextField = "NAME";
patientModalSelectAutomark.DataValueField = "ID";
patientModalSelectAutomark.DataBind();
}
calendarSelectSubmitStaff.DataSource = ds.Tables[7];
calendarSelectSubmitStaff.DataTextField = "NAME";
calendarSelectSubmitStaff.DataValueField = "ID";
calendarSelectSubmitStaff.DataBind();
//tab1
int highyr = DateTime.Now.Year;
int lowyr = DateTime.Now.Year - 100;
for (highyr = DateTime.Now.Year; highyr >= lowyr; highyr--)
{
calendarSelectAutoYear.Items.Add(new ListItem(highyr.ToString(), highyr.ToString()));
//tab1
patientModalSelectAutoYear.Items.Add(new ListItem(highyr.ToString(), highyr.ToString()));
}
calendarSelectRoom.DataSource = ds.Tables[6];
calendarSelectRoom.DataTextField = "NAME";
calendarSelectRoom.DataValueField = "ID";
calendarSelectRoom.DataBind();
calendarAppointmentModalSelectRoom.DataSource = ds.Tables[6];
calendarAppointmentModalSelectRoom.DataTextField = "NAME";
calendarAppointmentModalSelectRoom.DataValueField = "ID";
calendarAppointmentModalSelectRoom.DataBind();
//tab2
appmodaltab2SelectSeniorMechanical.DataSource = ds.Tables[16];
appmodaltab2SelectSeniorMechanical.DataTextField = "NAME";
appmodaltab2SelectSeniorMechanical.DataValueField = "ID";
appmodaltab2SelectSeniorMechanical.DataBind();
appmodaltab2SelectMechanical.DataSource = ds.Tables[17];
appmodaltab2SelectMechanical.DataTextField = "NAME";
appmodaltab2SelectMechanical.DataValueField = "ID";
appmodaltab2SelectMechanical.DataBind();
appmodaltab2SelectServiceConsultant.DataSource = ds.Tables[18];
appmodaltab2SelectServiceConsultant.DataTextField = "NAME";
appmodaltab2SelectServiceConsultant.DataValueField = "ID";
appmodaltab2SelectServiceConsultant.DataBind();
//tab3
appmodaltab3SelectMechanical.DataSource = ds.Tables[17];
appmodaltab3SelectMechanical.DataTextField = "NAME";
appmodaltab3SelectMechanical.DataValueField = "ID";
appmodaltab3SelectMechanical.DataBind();
appmodaltab3SelectSeniorMechanical.DataSource = ds.Tables[16];
appmodaltab3SelectSeniorMechanical.DataTextField = "NAME";
appmodaltab3SelectSeniorMechanical.DataValueField = "ID";
appmodaltab3SelectSeniorMechanical.DataBind();
appmodaltab3SelectServiceConsultant.DataSource = ds.Tables[18];
appmodaltab3SelectServiceConsultant.DataTextField = "NAME";
appmodaltab3SelectServiceConsultant.DataValueField = "ID";
appmodaltab3SelectServiceConsultant.DataBind();
//tab2
strreturnval = "<div class=\"inline-group\">";
if (ds.Tables[8].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[8].Rows)
{
strreturnval += "<label class=\"checkbox font-sm\"><input id=\"appmodaltab2CheckDiagnostic" + dr["ID"].ToString() + "\" name=\"appmodaltab2CheckDiagnostic\" type=\"checkbox\"value=\"" + dr["ID"].ToString() + "\"><i></i><span>" + dr["NAME"].ToString() + "</span></label>";
}
strreturnval += "</div>";
appmodaltab2DiagnosticsDiv.InnerHtml = strreturnval;
}
//tab3
strreturnval = "";
if (ds.Tables[9].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[9].Rows)
{
strreturnval += "<label class=\"radio radio-inline no-margin font-sm\"><input id=\"appmodaltab3CheckRepair" + dr["ID"].ToString() + "\" name=\"appmodaltab3CheckRepair\" type=\"radio\" class=\"radiobox\" value=\"" + dr["ID"].ToString() + "\"><span>" + dr["NAME"].ToString() + "</span></label>";
}
appmodaltab3RepairsDiv.InnerHtml = strreturnval;
}
//tab3
appmodaltab3SelectServiceType.DataSource = ds.Tables[10];
appmodaltab3SelectServiceType.DataTextField = "NAME";
appmodaltab3SelectServiceType.DataValueField = "ID";
appmodaltab3SelectServiceType.DataBind();
//tab3
strreturnval = "";
if (ds.Tables[11].Rows.Count != 0)
{
strreturnval += "<table id=\"appmodaltab3ServiceListTable\" class=\"table table-hover\"><thead class=\"hide\"><tr><th> </th><th> </th></tr></thead><tbody>";
foreach (DataRow dr in ds.Tables[11].Rows)
{
if (dr["NAME"].ToString().Length > 35)
{
strreturnval += "<tr><td><a href=\"javascript:void(0);\" class=\"btn btn-link btn-xs font-sm txt-color-blueDark no-padding no-margin\" rel=\"popover-hover\" data-placement=\"bottom\" data-content=\"" + dr["NAME"].ToString() + "\">" + dr["NAME"].ToString().Substring(0, 35) + "...</a></td><td><a href=\"javascript:void(0);\" rel=\"tooltip\" title=\"\" data-placement=\"left\" data-original-title=\"Сонгох\" class=\"pull-right txt-color-darken font-sm\" data-id=\"" + dr["ID"].ToString() + "\" data-toggle=\"modal\" data-target=\"#appmodaltab3AddServiceModal\" onclick=\"appModaltab3ShowAddTab1(this)\"><i class=\"fa fa-plus\"></i></a></td></tr>";
}
else
{
strreturnval += "<tr><td class=\"font-sm\">" + dr["NAME"].ToString() + "</td><td><a href=\"javascript:void(0);\" rel=\"tooltip\" title=\"\" data-placement=\"left\" data-original-title=\"Сонгох\" class=\"pull-right txt-color-darken font-sm\" data-id=\"" + dr["ID"].ToString() + "\" data-toggle=\"modal\" data-target=\"#appmodaltab3AddServiceModal\" onclick=\"appModaltab3ShowAddTab1(this)\"><i class=\"fa fa-plus\"></i></a></td></tr>";
}
}
strreturnval += "</tbody></table>";
strreturnval += "<script>var responsiveHelper_appmodaltab3ServiceListTable = undefined;var breakpointDefinition = {tablet: 1024, phone: 480 };$('#appmodaltab3ServiceListTable').dataTable({\"bLengthChange\" : false, \"iDisplayLength\": \"All\", \"paging\": false, \"ordering\": false, \"info\": false, \"sDom\": \"<'dt-toolbar'<'col-xs-12 col-sm-6'f><'col-sm-6 col-xs-12 hidden-xs'l>r>\" + \"t\" + \"<'dt-toolbar-footer'<'col-sm-6 col-xs-12 hidden-xs'i><'col-xs-12 col-sm-6'p>>\",\"autoWidth\": true,\"preDrawCallback\": function () {if (!responsiveHelper_appmodaltab3ServiceListTable) {responsiveHelper_appmodaltab3ServiceListTable = new ResponsiveDatatablesHelper($('#appmodaltab3ServiceListTable'), breakpointDefinition);}},\"rowCallback\": function (nRow) {responsiveHelper_appmodaltab3ServiceListTable.createExpandIcon(nRow);},\"drawCallback\": function (oSettings) {responsiveHelper_appmodaltab3ServiceListTable.respond();}}); $('#appmodaltab3ServiceListDiv').find('.dt-toolbar').find('div:eq(0)').attr('class','col-xs-12 col-sm-12');</script>";
}
else
{
strreturnval += "<i>Мэдээлэл олдсонгүй</i>";
}
appmodaltab3ServiceListDiv.InnerHtml = strreturnval;
//tab4
appmodaltab4SelectPartType.DataSource = ds.Tables[12];
appmodaltab4SelectPartType.DataTextField = "NAME";
appmodaltab4SelectPartType.DataValueField = "ID";
appmodaltab4SelectPartType.DataBind();
//tab4
strreturnval = "";
if (ds.Tables[13].Rows.Count != 0)
{
strreturnval += "<table id=\"appmodaltab4PartListTable\" class=\"table table-hover\"><thead class=\"hide\"><tr><th> </th><th> </th></tr></thead><tbody>";
foreach (DataRow dr in ds.Tables[13].Rows)
{
if (dr["NAME"].ToString().Length > 35)
{
strreturnval += "<tr><td><a href=\"javascript:void(0);\" class=\"btn btn-link btn-xs font-sm txt-color-blueDark no-padding no-margin\" rel=\"popover-hover\" data-placement=\"bottom\" data-content=\"" + dr["NAME"].ToString() + "\">" + dr["NAME"].ToString().Substring(0, 35) + "...</a></td><td><a href=\"javascript:void(0);\" rel=\"tooltip\" title=\"\" data-placement=\"left\" data-original-title=\"Сонгох\" class=\"pull-right txt-color-darken font-sm\" data-id=\"" + dr["ID"].ToString() + "\" data-toggle=\"modal\" data-target=\"#appmodaltab4AddPartModal\" onclick=\"appModaltab4ShowAddTab1(this)\"><i class=\"fa fa-plus\"></i></a></td></tr>";
}
else
{
strreturnval += "<tr><td class=\"font-sm\">" + dr["NAME"].ToString() + "</td><td><a href=\"javascript:void(0);\" rel=\"tooltip\" title=\"\" data-placement=\"left\" data-original-title=\"Сонгох\" class=\"pull-right txt-color-darken font-sm\" data-id=\"" + dr["ID"].ToString() + "\" data-toggle=\"modal\" data-target=\"#appmodaltab4AddPartModal\" onclick=\"appModaltab4ShowAddTab1(this)\"><i class=\"fa fa-plus\"></i></a></td></tr>";
}
}
strreturnval += "</tbody></table>";
strreturnval += "<script>var responsiveHelper_appmodaltab4PartListTable = undefined;var breakpointDefinition = {tablet: 1024, phone: 480 };$('#appmodaltab4PartListTable').dataTable({\"bLengthChange\" : false, \"iDisplayLength\": \"All\", \"paging\": false, \"ordering\": false, \"info\": false, \"sDom\": \"<'dt-toolbar'<'col-xs-12 col-sm-6'f><'col-sm-6 col-xs-12 hidden-xs'l>r>\" + \"t\" + \"<'dt-toolbar-footer'<'col-sm-6 col-xs-12 hidden-xs'i><'col-xs-12 col-sm-6'p>>\",\"autoWidth\": true,\"preDrawCallback\": function () {if (!responsiveHelper_appmodaltab4PartListTable) {responsiveHelper_appmodaltab4PartListTable = new ResponsiveDatatablesHelper($('#appmodaltab4PartListTable'), breakpointDefinition);}},\"rowCallback\": function (nRow) {responsiveHelper_appmodaltab4PartListTable.createExpandIcon(nRow);},\"drawCallback\": function (oSettings) {responsiveHelper_appmodaltab4PartListTable.respond();}}); $('#appmodaltab4PartListDiv').find('.dt-toolbar').find('div:eq(0)').attr('class','col-xs-12 col-sm-12');</script>";
}
else
{
strreturnval += "<i>Мэдээлэл олдсонгүй</i>";
}
appmodaltab4PartListDiv.InnerHtml = strreturnval;
//calendarActiveMechanicalList
strreturnval = "";
if (ds.Tables[17].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[17].Rows)
{
if (dr["ID"].ToString() != "")
{
//strreturnval += "<div class=\"checkbox\">";
strreturnval += "<label class=\"checkbox\">";
strreturnval += "<input id=\"calendarActiveMechanicModalSelectStaff" + dr["ID"].ToString() + "\" name=\"calendarActiveMechanicModalSelectStaff\" type=\"checkbox\" value=\"" + dr["ID"].ToString() + "\"><i></i><span>" + dr["NAME"].ToString() + "</span>";
strreturnval += "</label>";
//strreturnval += "</div>";
}
}
calendarActiveMechanicModalDivStaffList.InnerHtml = strreturnval;
}
myObjModifyDB.DBDisconnectSql();
//patient discount list
strreturnval = "<label class=\"label\" lang=\"mn\">*Хөнглөлт/карт</label><div class=\"inline-group\">";
if (ds.Tables[19].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[19].Rows)
{
strreturnval += "<label class=\"radio margin-right-5 font-sm\"><input id=\"calendarInputDiscount" + dr["ID"].ToString() + "\" name=\"calendarInputDiscount\" type=\"radio\" value=\"" + dr["ID"].ToString() + "\"><i></i><span>" + dr["NAME"].ToString() + "</span></label>";
}
strreturnval += "</div>";
calendarDiscountsDiv.InnerHtml = strreturnval;
}
//patient discount list
strreturnval = "<label class=\"label font-sm\" lang=\"mn\">*Хөнглөлт/карт</label><div class=\"inline-group\">";
if (ds.Tables[19].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[19].Rows)
{
strreturnval += "<label class=\"radio margin-right-5 font-sm\"><input id=\"patientModalInputDiscount" + dr["ID"].ToString() + "\" name=\"patientModalInputDiscount\" type=\"radio\" value=\"" + dr["ID"].ToString() + "\" class=\"input-sm\"><i></i><span>" + dr["NAME"].ToString() + "</span></label>";
}
strreturnval += "</div>";
patientModalDiscountsDiv.InnerHtml = strreturnval;
}
//limit
applmtmsg.Value = "ӨНӨӨДРИЙН ЗАХИАЛГЫН ХЯЗГААР ДҮҮРСЭН БАЙНА. СИСТЕМИЙН АДМИНТАЙ ХОЛБОО БАРИНА УУ!";
applmtnm.Value = "10";
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
ModifyDB myObjModifyDB = new ModifyDB();
memoDiv.InnerHtml = myObjModifyDB.ExecuteScalar("SELECT MEMO FROM TBL_TASK_MISSION WHERE ID=" + Request.QueryString["id"]).ToString();
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
string strQry0 = @"SELECT ID, NAME FROM TBL_ROLE ORDER BY ID";
string strQry1 = @"SELECT CAST(a.ID as varchar) as ID, a.FNAME+'.'+LEFT(a.LNAME,1)+' | '+b.NAME as NAME
FROM TBL_STAFF a
INNER JOIN TBL_STAFF_POSITION b ON a.STAFF_POSITION_ID=b.ID
WHERE a.ISACTIVE=1 AND a.CLINIC_ID = (SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + @")
ORDER BY a.FNAME+'.'+LEFT(a.LNAME,1)";
DataSet ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1);
roleListDiv.InnerHtml = "<label class=\"label\" lang=\"mn\">*Модулын эрх</label>";
if (ds.Tables[0].Rows.Count != 0)
{
int valIndex = 0;
roleListDiv.InnerHtml += "<div class=\"row\">";
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (valIndex % 10 == 0)
{
if (valIndex != 0)
{
roleListDiv.InnerHtml += "</div>";
}
roleListDiv.InnerHtml += "<div class=\"col col-6\">";
}
roleListDiv.InnerHtml += "<label class=\"checkbox\"><input id=\"usersetupModalInputRole" + dr["ID"].ToString() + "\" name=\"usersetupModalInputRole\" type=\"checkbox\" value=\"" + dr["ID"].ToString() + "\"><i></i><span lang=\"mn\">" + dr["NAME"].ToString() + "</span></label>";
valIndex++;
}
roleListDiv.InnerHtml += "</div>";
}
else
{
roleListDiv.InnerHtml += "Мэдээлэл олдсонгүй...";
}
staffListDiv.InnerHtml = "<label class=\"label\" lang=\"mn\">*Хамрах ажилтан</label>";
if (ds.Tables[1].Rows.Count != 0)
{
staffListDiv.InnerHtml += "<label class=\"select\">";
staffListDiv.InnerHtml += "<select id=\"usersetupModalSelectStaffs\" name=\"usersetupModalSelectStaffs\" multiple style=\"width: 100%\" class=\"select2\">";
foreach (DataRow dr in ds.Tables[1].Rows)
{
staffListDiv.InnerHtml += "<option value=\"" + dr["ID"].ToString() + "\">" + dr["NAME"].ToString() + "</option>";
}
staffListDiv.InnerHtml += "</select>";
staffListDiv.InnerHtml += "</label>";
}
else
{
staffListDiv.InnerHtml += "Мэдээлэл олдсонгүй...";
}
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
if (Request.QueryString["id"] != null)
{
int i = 0;
string strMyVal = "";
string strMyVal2 = "";
string strQry0 = "SELECT a.ID as APPOINTMENTID, a.NUM as APPOINTMENTNUM, a.APPOINTMENTTYPE, a.DT, LEFT(a.STARTTIME, 2) as STARTTIME, RIGHT(a.STARTTIME, 2) as STARTMINUTE, b.NAME as PATIENTNAME, CASE WHEN b.TEL2 IS NULL THEN b.TEL ELSE b.TEL + ', ' + b.TEL2 END as TEL, b.TYPE as PATIENTTYPE, b.ADDRESS, b.EMERGENCYTEL, b.EMERGENCYTELTYPE, b.EMERGENCYPERSONNAME, a.REQUESTMEMO, a.ISWASHING, a.ISGETPART, c.NAME as MARKNAME, b.VINNO, b.TRANSMISSIONTYPE, b.AUTONO, a.MILEAGE, b.PRODUCEDYEAR, b.FUELTYPE, LEFT(d.LNAME, 1) + '. ' + d.FNAME as STAFFNAME, CONVERT(VARCHAR(19),a.CREATED_DATE, 120) as CREATED_DATE, b.PATIENTDISCOUNT_ID FROM TBL_APPOINTMENT a INNER JOIN TBL_PATIENT b ON a.PATIENT_ID = b.ID INNER JOIN TBL_AUTOMARK c ON b.MARK_ID = c.ID LEFT JOIN TBL_STAFF d ON a.SUBMIT_STAFFID = d.ID WHERE a.ID = " + Request.QueryString["id"];
string strQry1 = "SELECT * FROM TBL_REQUESTTYPE ORDER BY ID";
string strQry2 = "SELECT * FROM TBL_APPOINTMENT_REQUESTTYPE WHERE APPOINTMENT_ID = " + Request.QueryString["id"] + " ORDER BY REQUESTTYPE_ID";
//Patient discount list
string strQry3 = @"SELECT ID, VALUE, NAME, PER FROM TBL_PATIENTDISCOUNT ORDER BY PER";
string strQry4 = @"SELECT
a.ID, a.DT, a.MILEAGE, ISNULL(c.NAME,N'Км') as MILEAGE_NAME, a.REQUESTMEMO, d.MEMO as REPAIR_MEMO, f.LISTDATA
FROM TBL_APPOINTMENT a
INNER JOIN TBL_PATIENT b ON a.PATIENT_ID=b.ID
LEFT JOIN TBL_ZAALTTYPE c ON b.ZAALTTYPE=c.ID
LEFT JOIN TBL_APPOINTMENT_REPAIR d ON a.ID=d.APPOINTMENT_ID
LEFT JOIN (
select t.APPOINTMENT_ID, stuff( (
select ','+ CAST(b.NAME as nvarchar)
from TBL_APPOINTMENT_REQUESTTYPE a
inner join TBL_REQUESTTYPE b on a.REQUESTTYPE_ID = b.ID
where a.APPOINTMENT_ID = t.APPOINTMENT_ID for XML path('') ),1,1,'') as LISTDATA
from (
SELECT DISTINCT APPOINTMENT_ID
FROM TBL_APPOINTMENT_REQUESTTYPE
WHERE APPOINTMENT_ID=(SELECT MAX(ID) AS APPOINTMENT_ID FROM TBL_APPOINTMENT
WHERE PATIENT_ID = (SELECT PATIENT_ID FROM TBL_APPOINTMENT WHERE ID = " + Request.QueryString["id"] + @") AND ID < " + Request.QueryString["id"] + @")
)t
) f ON a.ID = f.APPOINTMENT_ID
WHERE a.ID = (SELECT MAX(ID) AS APPOINTMENT_ID FROM TBL_APPOINTMENT
WHERE PATIENT_ID = (SELECT PATIENT_ID FROM TBL_APPOINTMENT WHERE ID = " + Request.QueryString["id"] + ") AND ID < " + Request.QueryString["id"] + ")";
//string strQry1 = "SELECT DIAGNOSTICTYPE_ID FROM TBL_APPOINTMENT_DIAGNOSTICTYPE WHERE APPOINTMENT_ID=" + Request.QueryString["id"] + " ORDER BY DIAGNOSTICTYPE_ID";
//string strQry2 = "SELECT a.DESCRIPTION, LEFT(b.LNAME,1)+'. '+b.FNAME as SENIORMECHNICAL_NAME, LEFT(c.LNAME,1)+'. '+c.FNAME as SERVICECONSULTANT_NAME FROM TBL_APPOINTMENT_DIAGNOSTIC a INNER JOIN TBL_STAFF b ON a.SENIORMECHANICAL_STAFFID=b.ID INNER JOIN TBL_STAFF c ON a.SERVICECONSULTANT_STAFFID=c.ID WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"];
//string strQry3 = "SELECT a.REPAIRTYPE_ID, LEFT(b.LNAME,1)+'. '+b.FNAME as MECHNICAL_NAME, LEFT(c.LNAME,1)+'. '+c.FNAME as SENIORMECHNICAL_NAME, LEFT(d.LNAME,1)+'. '+d.FNAME as SERVICECONSULTANT_NAME FROM TBL_APPOINTMENT_REPAIR a INNER JOIN TBL_STAFF b ON a.MECHANICAL_STAFFID=b.ID INNER JOIN TBL_STAFF c ON a.SENIORMECHANICAL_STAFFID=c.ID INNER JOIN TBL_STAFF d ON a.SERVICECONSULTANT_STAFFID=d.ID WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"];
//string strQry4 = "SELECT PART_NAME, CNT, DESCRIPTION FROM TBL_APPOINTMENT_PART WHERE APPOINTMENT_ID=" + Request.QueryString["id"];
ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1 + " " + strQry2 + " " + strQry3 + " " + strQry4);
strMyVal = "";
i = 0;
if (ds.Tables[1].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
strMyVal2 = " ";
foreach (DataRow dr2 in ds.Tables[2].Rows)
{
if (dr["ID"].ToString() == dr2["REQUESTTYPE_ID"].ToString())
{
strMyVal2 = "✔";
break;
}
}
if (i != 0)
{
strMyVal += " ";
}
strMyVal += dr["NAME"].ToString() + ": <span style=\"border: 1px solid #000; border-radius: 3px; padding: 1px 3px;\">" + strMyVal2 + "</span>";
i++;
}
pModalRequest.InnerHtml = strMyVal;
}
else
{
pModalRequest.InnerHtml = "";
}
strMyVal = "";
i = 0;
if (ds.Tables[3].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[3].Rows)
{
strMyVal2 = " ";
if (dr["ID"].ToString() == ds.Tables[0].Rows[0]["PATIENTDISCOUNT_ID"].ToString())
{
strMyVal2 = "✔";
}
if (i != 0)
{
strMyVal += " ";
}
strMyVal += dr["NAME"].ToString() + ": <span style=\"border: 1px solid #000; border-radius: 3px; padding: 1px 3px;\">" + strMyVal2 + "</span>";
i++;
}
pModalDiscount.InnerHtml = strMyVal;
}
else
{
pModalDiscount.InnerHtml = "";
}
if (ds.Tables[0].Rows.Count != 0)
{
pModalAppointmentno.InnerHtml = ds.Tables[0].Rows[0]["APPOINTMENTNUM"].ToString();
pModalAppointmentType1.InnerHtml = " ";
pModalAppointmentType2.InnerHtml = " ";
if (ds.Tables[0].Rows[0]["APPOINTMENTTYPE"].ToString() == "1")
{
pModalAppointmentType1.InnerHtml = "✔";
}
else if (ds.Tables[0].Rows[0]["APPOINTMENTTYPE"].ToString() == "0")
{
pModalAppointmentType2.InnerHtml = "✔";
}
pModalCreatedYear.InnerHtml = ds.Tables[0].Rows[0]["CREATED_DATE"].ToString().Split(' ')[0].Split('-')[0];
pModalCreatedMonth.InnerHtml = ds.Tables[0].Rows[0]["CREATED_DATE"].ToString().Split(' ')[0].Split('-')[1];
pModalCreatedDay.InnerHtml = ds.Tables[0].Rows[0]["CREATED_DATE"].ToString().Split(' ')[0].Split('-')[2];
pModalCreatedHour.InnerHtml = ds.Tables[0].Rows[0]["CREATED_DATE"].ToString().Split(' ')[1].Split(':')[0];
pModalCreatedMinute.InnerHtml = ds.Tables[0].Rows[0]["CREATED_DATE"].ToString().Split(' ')[1].Split(':')[1];
pModalYear.InnerHtml = ds.Tables[0].Rows[0]["DT"].ToString().Split('-')[0];
pModalMonth.InnerHtml = ds.Tables[0].Rows[0]["DT"].ToString().Split('-')[1];
pModalDay.InnerHtml = ds.Tables[0].Rows[0]["DT"].ToString().Split('-')[2];
pModalHour.InnerHtml = ds.Tables[0].Rows[0]["STARTTIME"].ToString();
pModalMinute.InnerHtml = ds.Tables[0].Rows[0]["STARTMINUTE"].ToString();
pModalOwnername.InnerHtml = ds.Tables[0].Rows[0]["PATIENTNAME"].ToString();
pModalTel.InnerHtml = ds.Tables[0].Rows[0]["TEL"].ToString();
pModalTel2.InnerHtml = ds.Tables[0].Rows[0]["TEL"].ToString();
pModalType1.InnerHtml = " ";
pModalType2.InnerHtml = " ";
if (ds.Tables[0].Rows[0]["PATIENTTYPE"].ToString() == "1")
{
pModalType1.InnerHtml = "✔";
}
else if (ds.Tables[0].Rows[0]["PATIENTTYPE"].ToString() == "0")
{
pModalType2.InnerHtml = "✔";
}
if (ds.Tables[0].Rows[0]["ADDRESS"].ToString() == "")
{
pModalAddress.InnerHtml = "";
}
else
{
pModalAddress.InnerHtml = ds.Tables[0].Rows[0]["ADDRESS"].ToString();
}
//if (ds.Tables[0].Rows[0]["EMERGENCYTEL"].ToString() == "")
// pModalTelEmergency.InnerHtml = "...........................................................................";
//else
// pModalTelEmergency.InnerHtml = ds.Tables[0].Rows[0]["EMERGENCYTEL"].ToString();
//if (ds.Tables[0].Rows[0]["EMERGENCYTELTYPE"].ToString() == "1")
//{
// pModalTelEmergencyType1.InnerHtml = "☑";
// pModalTelEmergencyType2.InnerHtml = "☐";
// pModalTelEmergencyType3.InnerHtml = "☐";
//}
//else if (ds.Tables[0].Rows[0]["EMERGENCYTELTYPE"].ToString() == "2")
//{
// pModalTelEmergencyType1.InnerHtml = "☐";
// pModalTelEmergencyType2.InnerHtml = "☑";
// pModalTelEmergencyType3.InnerHtml = "☐";
//}
//else if (ds.Tables[0].Rows[0]["EMERGENCYTELTYPE"].ToString() == "3")
//{
// pModalTelEmergencyType1.InnerHtml = "☐";
// pModalTelEmergencyType2.InnerHtml = "☑";
// pModalTelEmergencyType3.InnerHtml = "☑";
//}
//else
//{
// pModalTelEmergencyType1.InnerHtml = "☐";
// pModalTelEmergencyType2.InnerHtml = "☐";
// pModalTelEmergencyType3.InnerHtml = "☐";
//}
//if (ds.Tables[0].Rows[0]["EMERGENCYPERSONNAME"].ToString() == "")
// pModalTelEmergencyPersonname.InnerHtml = "...............................................................";
//else
// pModalTelEmergencyPersonname.InnerHtml = ds.Tables[0].Rows[0]["EMERGENCYPERSONNAME"].ToString();
if (ds.Tables[0].Rows[0]["REQUESTMEMO"].ToString() == "")
{
pModalRequestMemo.InnerHtml = "";
}
else
{
pModalRequestMemo.InnerHtml = myObjGetData.getReplaceDatabaseToDisplay(ds.Tables[0].Rows[0]["REQUESTMEMO"].ToString());
}
//if (ds.Tables[0].Rows[0]["ISWASHING"].ToString() == "1")
//{
// pModalIsWashing1.InnerHtml = "☑";
// pModalIsWashing0.InnerHtml = "☐";
//}
//else if (ds.Tables[0].Rows[0]["ISWASHING"].ToString() == "0")
//{
// pModalIsWashing1.InnerHtml = "☐";
// pModalIsWashing0.InnerHtml = "☑";
//}
//else
//{
// pModalIsWashing1.InnerHtml = "☐";
// pModalIsWashing0.InnerHtml = "☐";
//}
//if (ds.Tables[0].Rows[0]["ISGETPART"].ToString() == "1")
//{
// pModalIsGetPart1.InnerHtml = "☑";
// pModalIsGetPart0.InnerHtml = "☐";
//}
//else if (ds.Tables[0].Rows[0]["ISGETPART"].ToString() == "0")
//{
// pModalIsGetPart1.InnerHtml = "☐";
// pModalIsGetPart0.InnerHtml = "☑";
//}
//else
//{
// pModalIsGetPart1.InnerHtml = "☐";
// pModalIsGetPart0.InnerHtml = "☐";
//}
pModalMarkname.InnerHtml = ds.Tables[0].Rows[0]["MARKNAME"].ToString();
if (ds.Tables[0].Rows[0]["VINNO"].ToString() == "")
{
pModalVinno.InnerHtml = "";
}
else
{
pModalVinno.InnerHtml = ds.Tables[0].Rows[0]["VINNO"].ToString();
}
pModalTransmissionType1.InnerHtml = " ";
pModalTransmissionType2.InnerHtml = " ";
if (ds.Tables[0].Rows[0]["TRANSMISSIONTYPE"].ToString() == "1")
{
pModalTransmissionType1.InnerHtml = "✔";
}
else if (ds.Tables[0].Rows[0]["TRANSMISSIONTYPE"].ToString() == "0")
{
pModalTransmissionType2.InnerHtml = "✔";
}
pModalAutono.InnerHtml = ds.Tables[0].Rows[0]["AUTONO"].ToString();
pModalAutono2.InnerHtml = ds.Tables[0].Rows[0]["AUTONO"].ToString();
if (ds.Tables[0].Rows[0]["VINNO"].ToString() == "")
{
pModalMileage.InnerHtml = "";
}
else
{
pModalMileage.InnerHtml = ds.Tables[0].Rows[0]["MILEAGE"].ToString();
}
pModalProducedyear.InnerHtml = ds.Tables[0].Rows[0]["PRODUCEDYEAR"].ToString();
pModalFuelType1.InnerHtml = " ";
pModalFuelType2.InnerHtml = " ";
if (ds.Tables[0].Rows[0]["FUELTYPE"].ToString() == "1")
{
pModalFuelType1.InnerHtml = "✔";
}
else if (ds.Tables[0].Rows[0]["FUELTYPE"].ToString() == "0")
{
pModalFuelType2.InnerHtml = "✔";
}
pModalSubmitStaff.InnerHtml = ds.Tables[0].Rows[0]["STAFFNAME"].ToString();
}
else
{
pModalAppointmentno.InnerHtml = "......";
pModalAppointmentType1.InnerHtml = " ";
pModalAppointmentType2.InnerHtml = " ";
pModalYear.InnerHtml = "";
pModalMonth.InnerHtml = "";
pModalDay.InnerHtml = "";
pModalHour.InnerHtml = "";
pModalMinute.InnerHtml = "";
pModalOwnername.InnerHtml = "";
pModalTel.InnerHtml = "";
pModalTel2.InnerHtml = "";
pModalType1.InnerHtml = " ";
pModalType2.InnerHtml = " ";
pModalAddress.InnerHtml = "";
//pModalTelEmergency.InnerHtml = "...........................................................................";
//pModalTelEmergencyType1.InnerHtml = "☐";
//pModalTelEmergencyType2.InnerHtml = "☐";
//pModalTelEmergencyType3.InnerHtml = "☐";
//pModalTelEmergencyPersonname.InnerHtml = "...............................................................";
pModalRequestMemo.InnerHtml = "";
//pModalIsWashing1.InnerHtml = "☐";
//pModalIsWashing0.InnerHtml = "☐";
//pModalIsGetPart1.InnerHtml = "☐";
//pModalIsGetPart0.InnerHtml = "☐";
pModalMarkname.InnerHtml = "";
pModalVinno.InnerHtml = "";
pModalTransmissionType1.InnerHtml = " ";
pModalTransmissionType2.InnerHtml = " ";
pModalAutono.InnerHtml = "";
pModalAutono2.InnerHtml = "";
pModalMileage.InnerHtml = "";
pModalProducedyear.InnerHtml = "........";
pModalFuelType1.InnerHtml = " ";
pModalFuelType2.InnerHtml = " ";
}
strMyVal = "";
i = 0;
if (ds.Tables[4].Rows.Count != 0)
{
strMyVal += "Огноо: " + ds.Tables[4].Rows[0]["DT"].ToString() + "<br><br>";
strMyVal += "Заалт: " + ds.Tables[4].Rows[0]["MILEAGE"].ToString() + " " + ds.Tables[4].Rows[0]["MILEAGE_NAME"].ToString() + "<br><br>";
strMyVal += "Үйлчлүүлэгчийн хүсэлт: " + ds.Tables[4].Rows[0]["LISTDATA"].ToString() + "<br>Тайлбар:" + myObjGetData.getReplaceDatabaseToDisplay(ds.Tables[4].Rows[0]["REQUESTMEMO"].ToString());
pModalLastResult.InnerHtml = strMyVal;
}
else
{
pModalLastResult.InnerHtml = "";
}
}
else
{
Response.Redirect("~/#pg/calendar.aspx");
}
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
if (Convert.ToInt32(dtime.ToString("dd")) > 28)
{
rprt2Tab1SelectStartDate1.Value = dtime.ToString("yyyy-MM") + "-01";
rprt2Tab1SelectEndDate1.Value = dtime.AddMonths(1).AddDays(-2).ToString("yyyy-MM-dd");
rprt2Tab1BeginDate.InnerHtml = dtime.ToString("yyyy-MM") + "-01";
rprt2Tab1EndDate.InnerHtml = dtime.AddMonths(1).AddDays(-2).ToString("yyyy-MM-dd");
rprt2Tab2SelectStartDate1.Value = dtime.ToString("yyyy-MM") + "-01";
rprt2Tab2SelectEndDate1.Value = dtime.AddMonths(1).AddDays(-2).ToString("yyyy-MM-dd");
rprt2Tab2BeginDate.InnerHtml = dtime.ToString("yyyy-MM") + "-01";
rprt2Tab2EndDate.InnerHtml = dtime.AddMonths(1).AddDays(-2).ToString("yyyy-MM-dd");
rprt2Tab4SelectStartDate1.Value = dtime.ToString("yyyy-MM") + "-01";
rprt2Tab4SelectEndDate1.Value = dtime.AddMonths(1).AddDays(-2).ToString("yyyy-MM-dd");
rprt2Tab4BeginDate.InnerHtml = dtime.ToString("yyyy-MM") + "-01";
rprt2Tab4EndDate.InnerHtml = dtime.AddMonths(1).AddDays(-2).ToString("yyyy-MM-dd");
rprt2Tab5SelectStartDate1.Value = dtime.ToString("yyyy-MM") + "-01";
rprt2Tab5SelectEndDate1.Value = dtime.AddMonths(1).AddDays(-2).ToString("yyyy-MM-dd");
rprt2Tab5BeginDate.InnerHtml = dtime.ToString("yyyy-MM") + "-01";
rprt2Tab5EndDate.InnerHtml = dtime.AddMonths(1).AddDays(-2).ToString("yyyy-MM-dd");
}
else
{
rprt2Tab1SelectStartDate1.Value = dtime.AddMonths(-1).ToString("yyyy-MM-dd");
rprt2Tab1SelectEndDate1.Value = dtime.ToString("yyyy-MM-dd");
rprt2Tab1BeginDate.InnerHtml = dtime.AddMonths(-1).ToString("yyyy-MM-dd");
rprt2Tab1EndDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt2Tab2SelectStartDate1.Value = dtime.AddMonths(-1).ToString("yyyy-MM-dd");
rprt2Tab2SelectEndDate1.Value = dtime.ToString("yyyy-MM-dd");
rprt2Tab2BeginDate.InnerHtml = dtime.AddMonths(-1).ToString("yyyy-MM-dd");
rprt2Tab2EndDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt2Tab4SelectStartDate1.Value = dtime.AddMonths(-1).ToString("yyyy-MM-dd");
rprt2Tab4SelectEndDate1.Value = dtime.ToString("yyyy-MM-dd");
rprt2Tab4BeginDate.InnerHtml = dtime.AddMonths(-1).ToString("yyyy-MM-dd");
rprt2Tab4EndDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
rprt2Tab5SelectStartDate1.Value = dtime.AddMonths(-1).ToString("yyyy-MM-dd");
rprt2Tab5SelectEndDate1.Value = dtime.ToString("yyyy-MM-dd");
rprt2Tab5BeginDate.InnerHtml = dtime.AddMonths(-1).ToString("yyyy-MM-dd");
rprt2Tab5EndDate.InnerHtml = dtime.ToString("yyyy-MM-dd");
}
rprt2Tab1SelectStartDate2.Value = dtime.AddYears(-1).ToString("yyyy") + "-" + dtime.ToString("MM");
rprt2Tab1SelectEndDate2.Value = dtime.ToString("yyyy-MM");
rprt2Tab2SelectStartDate2.Value = dtime.AddYears(-1).ToString("yyyy") + "-" + dtime.ToString("MM");
rprt2Tab2SelectEndDate2.Value = dtime.ToString("yyyy-MM");
string strMyVal = "";
string strQry0 = "SELECT ROW_NUMBER() OVER(ORDER BY a.CNT DESC, a.MARK_NAME ASC) AS RW, a.MARK_NAME, a.CNT FROM ( SELECT a.MARK_ID, b.NAME as MARK_NAME, COUNT(a.MARK_ID) as CNT FROM TBL_PATIENT a INNER JOIN TBL_AUTOMARK b ON a.MARK_ID=b.ID WHERE a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") GROUP BY a.MARK_ID, b.NAME ) a";
ds = myObjModifyDB.ExecuteDataSet(strQry0);
strMyVal = "";
strMyVal += "<table style=\"border: 1px solid #DDD; border-collapse: collapse; font: 12px arial, sans-serif; width: 100%;\"><thead style=\"background-color:#C6D9F1; color:#666666;\"><tr><th style=\"border: 1px solid #DDD; padding:5px; text-align:center;\">#</th><th style=\"border: 1px solid #DDD; padding:5px; text-align:center;\" lang=\"mn\">Марк</th><th style=\"border: 1px solid #DDD; padding:5px; text-align:center;\" lang=\"mn\">Тоо</th></tr></thead><tbody>";
if (ds.Tables[0].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
strMyVal += "<tr><td style=\"border: 1px solid #DDD; padding:5px; text-align:center;\">" + dr["RW"].ToString() + "</td><td style=\"border: 1px solid #DDD; padding:5px; text-align:left;\">" + dr["MARK_NAME"].ToString() + "</td><td style=\"border: 1px solid #DDD; padding:5px; text-align:center;\">" + dr["CNT"].ToString() + "</td></tr>";
}
}
strMyVal += "</tbody></table>";
divrprt2Tab3Table.InnerHtml = strMyVal;
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
public string GetAppointCalendar()
{
ModifyDB myObjModifyDB = new ModifyDB();
if (Session["eBook_UserID"] != null)
{
string userid = Session["eBook_UserID"].ToString(), strreturnval = "[", strQry = "";
StringBuilder JSON = new StringBuilder();
try
{
if (Request.QueryString["tp"] == "timelineDay")
{
strQry = @"SELECT a.ID, a.CHAIRNUM, b.AUTONO, b.TEL, a.DT, a.STARTTIME, a.ENDTIME, a.APPOINTMENT_TYPE_ID, c.COLORCLASS, a.PATIENT_ID, a.APPOINTMENTTYPE, CONVERT(varchar, a.STARTDATETIME, 120) as STARTDATETIME, CONVERT(varchar, a.ENDDATETIME, 120) as ENDDATETIME, CONVERT(varchar, a.FIRST_STARTDATETIME, 120) as FIRST_STARTDATETIME, CONVERT(varchar, a.FIRST_ENDDATETIME, 120) as FIRST_ENDDATETIME, CASE
WHEN a.FIRST_ENDDATETIME < a.ENDDATETIME AND a.STARTDATETIME < a.FIRST_ENDDATETIME
THEN 100-(100*ROUND(CAST(DATEDIFF(MINUTE, a.STARTDATETIME, a.FIRST_ENDDATETIME) as float)/CAST(DATEDIFF(MINUTE, a.STARTDATETIME, a.ENDDATETIME) as float),4))
ELSE 0
END as EXTEND_PER FROM TBL_APPOINTMENT a INNER JOIN TBL_PATIENT b ON a.PATIENT_ID=b.ID INNER JOIN TBL_APPOINTMENT_TYPE c ON a.APPOINTMENT_TYPE_ID=c.ID WHERE a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + userid + ") AND a.DT BETWEEN '" + Request.QueryString["start"] + "' AND '" + Request.QueryString["start"] + "' AND a.ROOM_ID=" + Request.QueryString["room"];
}
else if (Request.QueryString["tp"] == "agendaWeek")
{
strQry = "SELECT a.ID, a.CHAIRNUM, b.AUTONO, b.TEL, a.DT, a.STARTTIME, a.ENDTIME, a.APPOINTMENT_TYPE_ID, c.COLORCLASS, a.PATIENT_ID, a.APPOINTMENTTYPE FROM TBL_APPOINTMENT a INNER JOIN TBL_PATIENT b ON a.PATIENT_ID=b.ID INNER JOIN TBL_APPOINTMENT_TYPE c ON a.APPOINTMENT_TYPE_ID=c.ID WHERE a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + userid + ") AND a.DT BETWEEN '" + Request.QueryString["start"] + "' AND '" + Request.QueryString["end"] + "' AND a.ROOM_ID=" + Request.QueryString["room"];
}
else if (Request.QueryString["tp"] == "month")
{
strQry = "SELECT a.DT, c.NAME, c.COLORCLASS, COUNT(a.ID) as CNT FROM TBL_APPOINTMENT a INNER JOIN TBL_PATIENT b ON a.PATIENT_ID=b.ID INNER JOIN TBL_APPOINTMENT_TYPE c ON a.APPOINTMENT_TYPE_ID=c.ID WHERE a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + userid + ") AND a.DT BETWEEN '" + Request.QueryString["start"] + "' AND '" + Request.QueryString["end"] + "' AND a.ROOM_ID=" + Request.QueryString["room"] + " GROUP BY a.DT, c.NAME, c.COLORCLASS";
}
strreturnval = "[";
ds = myObjModifyDB.ExecuteDataSet(strQry);
if (ds.Tables[0].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (strreturnval == "[")
{
strreturnval += "{";
}
else
{
strreturnval += ",{";
}
if (Request.QueryString["tp"] == "timelineDay")
{
strreturnval += "\"appointmentid\":\"" + dr["ID"].ToString() + "\",";
strreturnval += "\"resourceId\":\"" + dr["CHAIRNUM"].ToString() + "\",";
strreturnval += "\"title\":\"" + dr["AUTONO"].ToString() + " /" + dr["TEL"].ToString() + "/\",";
strreturnval += "\"start\":\"" + dr["DT"].ToString() + "T" + dr["STARTTIME"].ToString() + ":00\",";
strreturnval += "\"end\":\"" + dr["DT"].ToString() + "T" + dr["ENDTIME"].ToString() + ":00\",";
strreturnval += "\"appointmenttype\":\"" + dr["APPOINTMENT_TYPE_ID"].ToString() + "\",";
strreturnval += "\"className\":[\"event\", \"" + dr["COLORCLASS"].ToString() + "\"],";
strreturnval += "\"patientid\":\"" + dr["PATIENT_ID"].ToString() + "\",";
strreturnval += "\"apptype\":\"" + dr["APPOINTMENTTYPE"].ToString() + "\",";
strreturnval += "\"extend_per\":\"" + dr["EXTEND_PER"].ToString() + "\"";
}
else if (Request.QueryString["tp"] == "agendaWeek")
{
strreturnval += "\"appointmentid\":\"" + dr["ID"].ToString() + "\",";
strreturnval += "\"resourceId\":\"" + dr["CHAIRNUM"].ToString() + "\",";
strreturnval += "\"title\":\"" + dr["AUTONO"].ToString() + " /" + dr["TEL"].ToString() + "/\",";
strreturnval += "\"start\":\"" + dr["DT"].ToString() + "T" + dr["STARTTIME"].ToString() + ":00\",";
strreturnval += "\"end\":\"" + dr["DT"].ToString() + "T" + dr["ENDTIME"].ToString() + ":00\",";
strreturnval += "\"appointmenttype\":\"" + dr["APPOINTMENT_TYPE_ID"].ToString() + "\",";
strreturnval += "\"className\":[\"event\", \"" + dr["COLORCLASS"].ToString() + "\"],";
strreturnval += "\"patientid\":\"" + dr["PATIENT_ID"].ToString() + "\",";
strreturnval += "\"apptype\":\"" + dr["APPOINTMENTTYPE"].ToString() + "\"";
}
else if (Request.QueryString["tp"] == "month")
{
strreturnval += "\"title\":\"" + dr["NAME"].ToString() + " (" + dr["CNT"].ToString() + ")\",";
strreturnval += "\"className\":[\"event\", \"" + dr["COLORCLASS"].ToString() + "\"],";
strreturnval += "\"start\":\"" + dr["DT"].ToString() + "\",";
strreturnval += "\"end\":\"" + dr["DT"].ToString() + "\"";
}
strreturnval += "}";
}
}
}
catch (NullReferenceException ex)
{
}
catch (InvalidOperationException ex)
{
}
finally
{
myObjModifyDB.DBDisconnectSql();
}
strreturnval += "]";
JSON.Append(strreturnval);
return(JSON.ToString());
}
else
{
throw new cs.MyException("SessionDied");
}
}
protected void setDatas()
{
string strVal = "";
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
string strQry0 = "SELECT ID, CODE, NAME, ADDR, TEL, TEL2, EMAIL, WEB, FB, LOGO FROM TBL_CLINIC WHERE ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")";
string strQry1 = "SELECT ID, NAME, STAFF_POSITION_ID FROM TBL_JOBPOSITION WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ORDER BY ID";
string strQry2 = "SELECT '' as ID, N'- Сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_STAFF_POSITION WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ORDER BY NAME";
ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1 + " " + strQry2);
setupTab8Section1InputName.Value = ds.Tables[0].Rows[0]["NAME"].ToString();
setupTab8Section1InputAddr.Value = ds.Tables[0].Rows[0]["ADDR"].ToString();
setupTab8Section1InputTel1.Value = ds.Tables[0].Rows[0]["TEL"].ToString();
setupTab8Section1InputTel2.Value = ds.Tables[0].Rows[0]["TEL2"].ToString();
setupTab8Section1InputEmail.Value = ds.Tables[0].Rows[0]["EMAIL"].ToString();
setupTab8Section1InputWeb.Value = ds.Tables[0].Rows[0]["WEB"].ToString();
setupTab8Section1InputFb.Value = ds.Tables[0].Rows[0]["FB"].ToString();
if (ds.Tables[0].Rows[0]["LOGO"].ToString() != "")
{
setupTab8Section1ImgLogo.Src = "../files/cliniclogo/" + ds.Tables[0].Rows[0]["LOGO"].ToString();
}
//strVal = "";
if (ds.Tables[1].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
if (dr["ID"].ToString() == "1")
{
setupTab3DivJobPosition1Val.Attributes["data-value"] = dr["STAFF_POSITION_ID"].ToString();
}
else if (dr["ID"].ToString() == "2")
{
setupTab3DivJobPosition2Val.Attributes["data-value"] = dr["STAFF_POSITION_ID"].ToString();
}
else if (dr["ID"].ToString() == "3")
{
setupTab3DivJobPosition3Val.Attributes["data-value"] = dr["STAFF_POSITION_ID"].ToString();
}
}
}
setupTab3SelectJobPosition1.DataSource = ds.Tables[2];
setupTab3SelectJobPosition1.DataTextField = "NAME";
setupTab3SelectJobPosition1.DataValueField = "ID";
setupTab3SelectJobPosition1.DataBind();
setupTab3SelectJobPosition2.DataSource = ds.Tables[2];
setupTab3SelectJobPosition2.DataTextField = "NAME";
setupTab3SelectJobPosition2.DataValueField = "ID";
setupTab3SelectJobPosition2.DataBind();
setupTab3SelectJobPosition3.DataSource = ds.Tables[2];
setupTab3SelectJobPosition3.DataTextField = "NAME";
setupTab3SelectJobPosition3.DataValueField = "ID";
setupTab3SelectJobPosition3.DataBind();
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
int intTotalPg = 1, intPg = 1, intBeginRow = 1, intEndRow = 100;
ds = myObjModifyDB.ExecuteDataSet("SELECT COUNT(1) FROM TBL_PATIENT WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")");
patientTotalResult.InnerHtml = ds.Tables[0].Rows[0][0].ToString();
intTotalPg = countPages(Int32.Parse(ds.Tables[0].Rows[0][0].ToString()), 100);
if (Request.QueryString["pg"] != null)
{
if (System.Text.RegularExpressions.Regex.IsMatch(Request.QueryString["pg"], @"\d"))
{
if (Int32.Parse(ds.Tables[0].Rows[0][0].ToString()) < (Int32.Parse(Request.QueryString["pg"]) * 100))
{
intPg = intTotalPg;
}
else
{
intPg = Int32.Parse(Request.QueryString["pg"]);
}
if (intPg != 1)
{
intBeginRow = (intPg * 100) - 99;
intEndRow = (intPg * 100);
}
}
else
{
HttpContext.Current.Session["error500"] = "БУРУУ ХАНДАЛТ";
Response.Redirect("~/#pg/error500.aspx");
}
}
patientBeginResult.InnerHtml = intBeginRow.ToString();
patientEndResult.InnerHtml = intEndRow.ToString();
string strQry0 = "SELECT '' as ID, N'- Ажилтан сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_AUTOMARK";
string strQry1 = @"SELECT *
FROM (
SELECT ROW_NUMBER() OVER(ORDER BY a.CODE DESC) AS RW, a.ID, a.CODE, a.NAME, CASE WHEN a.[TYPE]=1 THEN N'Хувь хүн' ELSE N'Байгууллага' END as [TYPE], b.NAME as MARK_NAME, a.PRODUCEDYEAR, a.AUTONO, a.VINNO, ISNULL(c.CNT,0) as APP_CNT, CASE WHEN a.ISMYSOLD=1 THEN 'danger' ELSE null END AS ISMYSOLD, ISNULL(d.ZAALT,0) as ZAALT
FROM TBL_PATIENT a
INNER JOIN TBL_AUTOMARK b ON a.MARK_ID=b.ID
LEFT JOIN (
SELECT a.PATIENT_ID, COUNT(a.ID) as CNT
FROM TBL_APPOINTMENT a
INNER JOIN TBL_APPOINTMENT_TYPE b ON a.APPOINTMENT_TYPE_ID=b.ID
WHERE a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + @") AND b.ISACTIVESHOW=1
GROUP BY a.PATIENT_ID
) c ON a.ID = c.PATIENT_ID
LEFT JOIN (
SELECT a.PATIENT_ID, b.MILEAGE as ZAALT
FROM (
SELECT a.PATIENT_ID, MAX(a.ID) as APPID
FROM TBL_APPOINTMENT a
INNER JOIN TBL_APPOINTMENT_TYPE b ON a.APPOINTMENT_TYPE_ID=b.ID
WHERE a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + @") AND b.ISACTIVESHOW=1
GROUP BY a.PATIENT_ID
) a
INNER JOIN TBL_APPOINTMENT b ON a.APPID=b.ID
) d ON a.ID = d.PATIENT_ID
WHERE a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + @")
) a
WHERE RW>=" + intBeginRow.ToString() + " AND RW<=" + intEndRow.ToString();
string strQry2 = "SELECT a.ID, a.NAME FROM ( SELECT '' as ID, N'- Сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_AUTOMARK_TYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ) a ORDER BY a.NAME";
string strQry3 = "SELECT a.ID, a.NAME FROM ( SELECT '' as ID, N'- Сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_AUTOMARK WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ") ) a ORDER BY a.NAME";
//Patient discount list
string strQry4 = @"SELECT ID, VALUE, NAME, PER FROM TBL_PATIENTDISCOUNT ORDER BY PER";
ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1 + " " + strQry2 + " " + strQry3 + " " + strQry4);
//bind auto mark ddl
patientModalSelectAutomark.DataSource = ds.Tables[0];
patientModalSelectAutomark.DataTextField = "NAME";
patientModalSelectAutomark.DataValueField = "ID";
patientModalSelectAutomark.DataBind();
//bind year ddl
int highyr = DateTime.Now.Year;
int lowyr = DateTime.Now.Year - 100;
for (highyr = DateTime.Now.Year; highyr >= lowyr; highyr--)
{
patientModalSelectAutoYear.Items.Add(new ListItem(highyr.ToString(), highyr.ToString()));
}
//bind patient table
string strreturnval = "";
strreturnval += "<table id=\"patientDatatable\" class=\"table table-striped table-bordered table-hover\" width=\"100%\">";
strreturnval += "<thead>";
strreturnval += "<tr>";
strreturnval += "<th>#</th>";
strreturnval += "<th style=\"width:100px;\" data-class=\"expand\">Арал/дугаар</th>";
strreturnval += "<th style=\"width:85px;\">У/дугаар</th>";
strreturnval += "<th>Эзэмшигч/нэр</th>";
strreturnval += "<th style=\"width:98px;\" data-hide=\"phone,tablet\">Төрөл</th>";
strreturnval += "<th>Загвар</th>";
strreturnval += "<th style=\"width:51px;\">Он</th>";
strreturnval += "<th class=\"text-center\" style=\"width:51px;\" data-hide=\"phone,tablet\">Үйлчлүүлсэн тоо</th>";
strreturnval += "<th class=\"text-center\" style=\"width:70px;\" data-hide=\"phone,tablet\">КМ заалт</th>";
strreturnval += "<th style=\"width:85px;\" data-hide=\"phone,tablet\"> </th>";
strreturnval += "<th style=\"width:114px;\" data-hide=\"phone,tablet\"> </th>";
strreturnval += "<th style=\"width:67px;\"> </th>";
strreturnval += "</tr>";
strreturnval += "</thead>";
strreturnval += "<tbody>";
if (ds.Tables[1].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
strreturnval += "<tr data-id=\"" + dr["ID"].ToString() + "\" class=\"" + dr["ISMYSOLD"].ToString() + "\">";
strreturnval += "<td>" + dr["RW"].ToString() + "</td>";
strreturnval += "<td>" + dr["VINNO"].ToString() + "</td>";
strreturnval += "<td>" + dr["AUTONO"].ToString() + "</td>";
strreturnval += "<td>" + dr["NAME"].ToString() + "</td>";
strreturnval += "<td>" + dr["TYPE"].ToString() + "</td>";
strreturnval += "<td>" + dr["MARK_NAME"].ToString() + "</td>";
strreturnval += "<td>" + dr["PRODUCEDYEAR"].ToString() + "</td>";
strreturnval += "<td class=\"text-center\">" + dr["APP_CNT"].ToString() + "</td>";
strreturnval += "<td class=\"text-center\">" + dr["ZAALT"].ToString() + "</td>";
strreturnval += "<td><a class=\"btn btn-info btn-xs\" href=\"#pg/patienttimeline.aspx?id=" + dr["ID"].ToString() + "\"><i class=\"fa fa-archive\"></i> Архив</a></td>";
strreturnval += "<td><a class=\"btn btn-info btn-xs\" href=\"../pg/patientinfomodal.aspx?id=" + dr["ID"].ToString() + "\" data-toggle=\"modal\" data-target=\"#patientInfoModal\"><i class=\"fa fa-info\"></i> Дэлгэрэнгүй</a></td>";
strreturnval += "<td><button class=\"btn btn-xs btn-default\" data-toggle=\"modal\" data-target=\"#patientModal\" onclick=\"patientAddEdit(this,'засах')\"><i class=\"fa fa-pencil\"></i></button><button class=\"btn btn-xs btn-default\" onclick=\"patientDelete(this)\"><i class=\"fa fa-trash-o\"></i></button></td>";
strreturnval += "</tr>";
}
}
strreturnval += "</tbody>";
strreturnval += "</table>";
strreturnval += "<script>var responsiveHelper_patientDatatable = undefined; var breakpointDefinition = { tablet: 1024, phone: 480 }; $('#patientDatatable').dataTable({\"iDisplayLength\": 100, \"columns\": [ null, { \"width\": \"100px\" }, { \"width\": \"85px\" }, null, { \"width\": \"98px\" }, null, { \"width\": \"51px\" }, { \"width\": \"51px\" }, { \"width\": \"70px\" }, { \"width\": \"85px\" }, { \"width\": \"114px\" }, { \"width\": \"67px\" } ], \"sDom\": \"<'dt-toolbar'<'col-xs-12 col-sm-6'f><'col-sm-6 col-xs-12 hidden-xs'l>r>\" + \"t\" + \"<'dt-toolbar-footer'<'col-sm-6 col-xs-12 hidden-xs'i><'col-xs-12 col-sm-6'p>>\", \"autoWidth\": true, \"preDrawCallback\": function() { if (!responsiveHelper_patientDatatable) { responsiveHelper_patientDatatable = new ResponsiveDatatablesHelper($('#patientDatatable'), breakpointDefinition); } }, \"rowCallback\": function(nRow) { responsiveHelper_patientDatatable.createExpandIcon(nRow); }, \"drawCallback\": function(oSettings) { responsiveHelper_patientDatatable.respond(); }, \"paging\": false, \"info\": false });</script>";
patientDatatableDiv.InnerHtml = strreturnval;
//bind pagination
strreturnval = "";
strreturnval += "<ul class=\"pagination pagination-sm\">";
if (intPg != 1)
{
strreturnval += "<li><a href=\"#pg/patient.aspx?pg=" + (intPg - 1).ToString() + "\"><i class=\"fa fa-angle-left\"></i></a></li><li><a href=\"~/#pg/patient.aspx?pg=" + (intPg - 1).ToString() + "\">" + (intPg - 1).ToString() + "</a></li>";
}
strreturnval += "<li class=\"active\"><a href=\"javascript:void(0);\">" + intPg.ToString() + "</a></li>";
if (intPg < intTotalPg)
{
strreturnval += "<li><a href=\"#pg/patient.aspx?pg=" + (intPg + 1).ToString() + "\">" + (intPg + 1).ToString() + "</a></li><li><a href=\"~/#pg/patient.aspx?pg=" + (intPg + 1).ToString() + "\"><i class=\"fa fa-angle-right\"></i></a></li>";
}
strreturnval += "</ul>";
patientPagination.InnerHtml = strreturnval;
//
patientModalSelectAutomarkType.DataSource = ds.Tables[2];
patientModalSelectAutomarkType.DataTextField = "NAME";
patientModalSelectAutomarkType.DataValueField = "ID";
patientModalSelectAutomarkType.DataBind();
if (ds.Tables[2].Rows.Count > 2)
{
patientModalSelectAutomarkType.SelectedIndex = 0;
patientModalSelectAutomarkType.Disabled = false;
patientModalSelectAutomark.Disabled = true;
}
else if (ds.Tables[2].Rows.Count == 2)
{
patientModalSelectAutomarkType.SelectedIndex = 1;
patientModalSelectAutomarkType.Disabled = true;
patientModalSelectAutomark.Disabled = false;
patientModalSelectAutomark.DataSource = ds.Tables[3];
patientModalSelectAutomark.DataTextField = "NAME";
patientModalSelectAutomark.DataValueField = "ID";
patientModalSelectAutomark.DataBind();
}
//patient discount list
strreturnval = "<label class=\"control-label\" style=\"display:block;\" lang=\"mn\">Хөнглөлтийн карт</label>";
if (ds.Tables[4].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[4].Rows)
{
strreturnval += "<label class=\"radio radio-inline no-margin\"><input id=\"patientModalInputDiscount" + dr["ID"].ToString() + "\" name=\"patientModalInputDiscount\" type=\"radio\" class=\"radiobox\" value=\"" + dr["ID"].ToString() + "\"><span>" + dr["NAME"].ToString() + "</span></label>";
}
patientModalDiscountsDiv.InnerHtml = strreturnval;
}
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
if (Request.QueryString["id"] != null)
{
//string strMyVal = "";
string strQry0 = "SELECT a.ID as APPOINTMENTID, a.NUM as APPOINTMENTNUM, b.TYPE as PATIENTTYPE, b.NAME as PATIENTNAME, c.NAME as MARKNAME, b.AUTONO, b.TRANSMISSIONTYPE, b.FUELTYPE, a.REQUESTMEMO, a.CHAIRNUM, LEFT(a.STARTTIME,2) as STARTTIME, RIGHT(a.STARTTIME,2) as STARTMINUTE, LEFT(a.ENDTIME,2) as ENDTIME, RIGHT(a.ENDTIME,2) as ENDMINUTE FROM TBL_APPOINTMENT a INNER JOIN TBL_PATIENT b ON a.PATIENT_ID=b.ID INNER JOIN TBL_AUTOMARK c ON b.MARK_ID=c.ID WHERE a.ID=" + Request.QueryString["id"];
string strQry1 = "SELECT DIAGNOSTICTYPE_ID FROM TBL_APPOINTMENT_DIAGNOSTICTYPE WHERE APPOINTMENT_ID=" + Request.QueryString["id"] + " ORDER BY DIAGNOSTICTYPE_ID";
string strQry2 = "SELECT a.DESCRIPTION, LEFT(b.LNAME,1)+'. '+b.FNAME as SENIORMECHNICAL_NAME, LEFT(c.LNAME,1)+'. '+c.FNAME as SERVICECONSULTANT_NAME, LEFT(d.LNAME,1)+'. '+d.FNAME as MECHNICAL_NAME FROM TBL_APPOINTMENT_DIAGNOSTIC a INNER JOIN TBL_STAFF b ON a.SENIORMECHANICAL_STAFFID=b.ID INNER JOIN TBL_STAFF c ON a.SERVICECONSULTANT_STAFFID=c.ID INNER JOIN TBL_STAFF d ON a.MECHANICAL_STAFFID=d.ID WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"];
string strQry3 = "SELECT a.REPAIRTYPE_ID, LEFT(b.LNAME,1)+'. '+b.FNAME as MECHNICAL_NAME, LEFT(c.LNAME,1)+'. '+c.FNAME as SENIORMECHNICAL_NAME, LEFT(d.LNAME,1)+'. '+d.FNAME as SERVICECONSULTANT_NAME FROM TBL_APPOINTMENT_REPAIR a INNER JOIN TBL_STAFF b ON a.MECHANICAL_STAFFID=b.ID INNER JOIN TBL_STAFF c ON a.SENIORMECHANICAL_STAFFID=c.ID INNER JOIN TBL_STAFF d ON a.SERVICECONSULTANT_STAFFID=d.ID WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"];
string strQry4 = "SELECT PART_NAME, CNT, DESCRIPTION FROM TBL_APPOINTMENT_PART WHERE APPOINTMENT_ID=" + Request.QueryString["id"];
ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1 + " " + strQry2 + " " + strQry3 + " " + strQry4);
pModalAppointmentno.InnerHtml = ds.Tables[0].Rows[0]["APPOINTMENTNUM"].ToString();
if (ds.Tables[0].Rows[0]["PATIENTTYPE"].ToString() == "1")
{
pModalPatientType1.InnerHtml = "☑";
pModalPatientType0.InnerHtml = "☐";
}
else if (ds.Tables[0].Rows[0]["PATIENTTYPE"].ToString() == "0")
{
pModalPatientType1.InnerHtml = "☐";
pModalPatientType0.InnerHtml = "☑";
}
else
{
pModalPatientType1.InnerHtml = "☐";
pModalPatientType0.InnerHtml = "☐";
}
pModalPatientName.InnerHtml = ds.Tables[0].Rows[0]["PATIENTNAME"].ToString();
pModalPatientMarkname.InnerHtml = ds.Tables[0].Rows[0]["MARKNAME"].ToString();
pModalPatientAutono.InnerHtml = ds.Tables[0].Rows[0]["AUTONO"].ToString();
if (ds.Tables[0].Rows[0]["TRANSMISSIONTYPE"].ToString() == "1")
{
pModalPatientTransmissiontype1.InnerHtml = "☑";
pModalPatientTransmissiontype0.InnerHtml = "☐";
}
else if (ds.Tables[0].Rows[0]["TRANSMISSIONTYPE"].ToString() == "0")
{
pModalPatientTransmissiontype1.InnerHtml = "☐";
pModalPatientTransmissiontype0.InnerHtml = "☑";
}
else
{
pModalPatientTransmissiontype1.InnerHtml = "☐";
pModalPatientTransmissiontype0.InnerHtml = "☐";
}
if (ds.Tables[0].Rows[0]["FUELTYPE"].ToString() == "1")
{
pModalPatientFueltype1.InnerHtml = "☑";
pModalPatientFueltype0.InnerHtml = "☐";
}
else if (ds.Tables[0].Rows[0]["FUELTYPE"].ToString() == "0")
{
pModalPatientFueltype1.InnerHtml = "☐";
pModalPatientFueltype0.InnerHtml = "☑";
}
else
{
pModalPatientFueltype1.InnerHtml = "☐";
pModalPatientFueltype0.InnerHtml = "☐";
}
pModalAppontmentRequestMemo.InnerHtml = myObjGetData.getReplaceDatabaseToDisplay(ds.Tables[0].Rows[0]["REQUESTMEMO"].ToString());
pModalAppointmentBeginTime.InnerHtml = ds.Tables[0].Rows[0]["STARTTIME"].ToString();
pModalAppointmentBeginMinute.InnerHtml = ds.Tables[0].Rows[0]["STARTMINUTE"].ToString();
pModalAppointmentEndTime.InnerHtml = ds.Tables[0].Rows[0]["ENDTIME"].ToString();
pModalAppointmentEndMinute.InnerHtml = ds.Tables[0].Rows[0]["ENDMINUTE"].ToString();
pModalAppointmentUrgugchnum.InnerHtml = ds.Tables[0].Rows[0]["CHAIRNUM"].ToString();
pModalAppointmentBeginTime2.InnerHtml = ds.Tables[0].Rows[0]["STARTTIME"].ToString();
pModalAppointmentBeginMinute2.InnerHtml = ds.Tables[0].Rows[0]["STARTMINUTE"].ToString();
pModalAppointmentEndTime2.InnerHtml = ds.Tables[0].Rows[0]["ENDTIME"].ToString();
pModalAppointmentEndMinute2.InnerHtml = ds.Tables[0].Rows[0]["ENDMINUTE"].ToString();
pModalAppointmentUrgugchnum2.InnerHtml = ds.Tables[0].Rows[0]["CHAIRNUM"].ToString();
pModalDiagnostictype1.InnerHtml = "☐";
pModalDiagnostictype2.InnerHtml = "☐";
pModalDiagnostictype3.InnerHtml = "☐";
pModalDiagnostictype4.InnerHtml = "☐";
if (ds.Tables[1].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
if (dr["DIAGNOSTICTYPE_ID"].ToString() == "1")
{
pModalDiagnostictype1.InnerHtml = "☑";
}
else if (dr["DIAGNOSTICTYPE_ID"].ToString() == "2")
{
pModalDiagnostictype2.InnerHtml = "☑";
}
else if (dr["DIAGNOSTICTYPE_ID"].ToString() == "3")
{
pModalDiagnostictype3.InnerHtml = "☑";
}
else if (dr["DIAGNOSTICTYPE_ID"].ToString() == "4")
{
pModalDiagnostictype4.InnerHtml = "☑";
}
}
}
if (ds.Tables[2].Rows.Count != 0)
{
pModalDiagnosticDescription.InnerHtml = myObjGetData.getReplaceDatabaseToDisplay(ds.Tables[2].Rows[0]["DESCRIPTION"].ToString());
pModalSeniorMechanicalName.InnerHtml = ds.Tables[2].Rows[0]["SENIORMECHNICAL_NAME"].ToString();
pModalMechanicalName.InnerHtml = ds.Tables[2].Rows[0]["MECHNICAL_NAME"].ToString();
pModalServiceConsultantName.InnerHtml = ds.Tables[2].Rows[0]["SERVICECONSULTANT_NAME"].ToString();
}
pModalRepairtype1.InnerHtml = "☐";
pModalRepairtype2.InnerHtml = "☐";
pModalRepairtype3.InnerHtml = "☐";
pModalRepairtype4.InnerHtml = "☐";
if (ds.Tables[3].Rows.Count != 0)
{
if (ds.Tables[3].Rows[0]["REPAIRTYPE_ID"].ToString() == "1")
{
pModalRepairtype1.InnerHtml = "☑";
}
else if (ds.Tables[3].Rows[0]["REPAIRTYPE_ID"].ToString() == "2")
{
pModalRepairtype2.InnerHtml = "☑";
}
else if (ds.Tables[3].Rows[0]["REPAIRTYPE_ID"].ToString() == "3")
{
pModalRepairtype3.InnerHtml = "☑";
}
else if (ds.Tables[3].Rows[0]["REPAIRTYPE_ID"].ToString() == "4")
{
pModalRepairtype4.InnerHtml = "☑";
}
pModalMechanicalName2.InnerHtml = ds.Tables[3].Rows[0]["MECHNICAL_NAME"].ToString();
pModalSeniorMechanicalName2.InnerHtml = ds.Tables[3].Rows[0]["SENIORMECHNICAL_NAME"].ToString();
pModalServiceConsultantName2.InnerHtml = ds.Tables[3].Rows[0]["SERVICECONSULTANT_NAME"].ToString();
}
if (ds.Tables[4].Rows.Count != 0)
{
pModalPartList.InnerHtml = "";
foreach (DataRow dr in ds.Tables[4].Rows)
{
pModalPartList.InnerHtml += "<tr>";
pModalPartList.InnerHtml += "<td style=\"padding:1px 5px; text-align:left; vertical-align:middle; border:1px solid #D6D6D6;\">" + dr["PART_NAME"].ToString() + "</td>";
pModalPartList.InnerHtml += "<td style=\"padding:1px 5px; text-align:center; vertical-align:middle; border:1px solid #D6D6D6;\">" + dr["CNT"].ToString() + "</td>";
pModalPartList.InnerHtml += "<td style=\"padding:1px 5px; text-align:left; vertical-align:middle; border:1px solid #D6D6D6;\">" + dr["DESCRIPTION"].ToString() + "</td>";
pModalPartList.InnerHtml += "</tr>";
}
for (int i = 1; i <= (10 - ds.Tables[4].Rows.Count); i++)
{
pModalPartList.InnerHtml += "<tr>";
pModalPartList.InnerHtml += "<td style=\"padding:1px 5px; text-align:left; vertical-align:middle; border:1px solid #D6D6D6;\"> </td>";
pModalPartList.InnerHtml += "<td style=\"padding:1px 5px; text-align:center; vertical-align:middle; border:1px solid #D6D6D6;\"> </td>";
pModalPartList.InnerHtml += "<td style=\"padding:1px 5px; text-align:left; vertical-align:middle; border:1px solid #D6D6D6;\"> </td>";
pModalPartList.InnerHtml += "</tr>";
}
}
pModalCurrentDate.InnerHtml = DateTime.Now.Date.ToString("yyyy Оны MM Сар dd Өдөр");
}
else
{
Response.Redirect("~/#pg/calendar.aspx");
}
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
if (Request.QueryString["id"] != null)
{
string strMyVal = "";
string strQry0 = "SELECT a.NUM as APPOINTMENT_NUM, b.CODE as PATIENT_CODE, b.NAME as PATIENT_NAME, b.AUTONO as PATIENT_AUTONO, a.DT as APPOINTMENT_DT, a.STARTTIME as APPOINTMENT_STARTTIME, a.ENDTIME as APPOINTMENT_ENDTIME, c.NAME as ROOM_NAME, a.CHAIRNUM, d.ADDR as CLINIC_ADDR, CASE WHEN d.TEL2 is not null THEN CAST(d.TEL as varchar)+', '+CAST(d.TEL2 as varchar) ELSE CAST(d.TEL as varchar) END as CLINIC_TEL, d.EMAIL as CLINIC_EMAIL, d.WEB as CLINIC_WEB FROM TBL_APPOINTMENT a INNER JOIN TBL_PATIENT b ON a.PATIENT_ID=b.ID INNER JOIN TBL_ROOM c ON a.ROOM_ID=c.ID INNER JOIN TBL_CLINIC d ON a.CLINIC_ID=d.ID WHERE a.ID=" + Request.QueryString["id"];
string strQry1 = "SELECT a.NAME as REQUESTTYPE_NAME, CASE WHEN b.REQUESTTYPE_ID is null THEN null ELSE '✓' END as ISCHECK FROM TBL_REQUESTTYPE a LEFT JOIN TBL_APPOINTMENT_REQUESTTYPE b ON a.ID=b.REQUESTTYPE_ID AND b.APPOINTMENT_ID=" + Request.QueryString["id"] + " WHERE a.CLINIC_ID=(SELECT CLINIC_ID FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"] + ")";
string strQry2 = "SELECT a.NAME, a.PRICE, a.CNT, a.PRICE*a.CNT as TOTALPRICE, ISNULL(a.DISCPER, 0) as DISCPER, CEILING(((a.PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0)) as DISCPRICE, (a.PRICE*a.CNT)-(CEILING(((a.PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))) as PAYPRICE FROM TBL_APPOINTMENT_DIAGNOSTICTYPE a WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"] + " ORDER BY a.DIAGNOSTICTYPE_ID";
string strQry3 = "SELECT a.SERVICE_NAME as NAME, ISNULL(a.SERVICE_PRICE,0) as PRICE, a.CNT, ISNULL(a.SERVICE_PRICE*a.CNT,0) as TOTALPRICE, ISNULL(a.DISCPER, 0) as DISCPER, ISNULL(CEILING(((a.SERVICE_PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0)),0) as DISCPRICE, ISNULL((a.SERVICE_PRICE*a.CNT)-(CEILING(((a.SERVICE_PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))),0) as PAYPRICE FROM TBL_APPOINTMENT_SERVICE a WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"];
string strQry4 = "SELECT a.PART_NAME as NAME, ISNULL(a.PART_PRICE,0) as PRICE, a.CNT, ISNULL(a.PART_PRICE*a.CNT,0) as TOTALPRICE, ISNULL(a.DISCPER, 0) as DISCPER, ISNULL(CEILING(((a.PART_PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0)),0) as DISCPRICE, ISNULL((a.PART_PRICE*a.CNT)-(CEILING(((a.PART_PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))),0) as PAYPRICE FROM TBL_APPOINTMENT_PART a WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"];
string strQry5 = "SELECT ISNULL(SUM(a.TOTALPRICE),0) as TOTALPRICE FROM ( SELECT (a.PRICE*a.CNT)-(CEILING(((a.PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))) as TOTALPRICE FROM TBL_APPOINTMENT_DIAGNOSTICTYPE a WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"] + " UNION ALL SELECT (a.SERVICE_PRICE*a.CNT)-(CEILING(((a.SERVICE_PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))) as TOTALPRICE FROM TBL_APPOINTMENT_SERVICE a WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"] + " UNION ALL SELECT (a.PART_PRICE*a.CNT)-(CEILING(((a.PART_PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))) as TOTALPRICE FROM TBL_APPOINTMENT_PART a WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"] + " ) a";
string strQry6 = "SELECT ISNULL(SUM(a.DISCOUNT),0) as DISCOUNT FROM ( SELECT CEILING(((a.PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0)) as DISCOUNT FROM TBL_APPOINTMENT_DIAGNOSTICTYPE a WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"] + " UNION ALL SELECT (CEILING(((a.SERVICE_PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))) as DISCOUNT FROM TBL_APPOINTMENT_SERVICE a WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"] + " UNION ALL SELECT (CEILING(((a.PART_PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))) as DISCOUNT FROM TBL_APPOINTMENT_PART a WHERE a.APPOINTMENT_ID=" + Request.QueryString["id"] + " UNION ALL SELECT ISNULL(DISCOUNT,0) as DISCOUNT FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"] + " ) a";
//string strQry6 = "SELECT ISNULL(SUM(a.DISCOUNT),0) as DISCOUNT FROM ( SELECT ISNULL(DISCOUNT,0) as DISCOUNT FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"] + " ) a";
string strQry7 = "SELECT ISNULL(SUM(a.ULDEGDEL),0) as ULDEGDEL FROM ( SELECT a.APPOINTMENT_ID, (a.TOTALPRICE-ISNULL(b.DISCOUNT,0))-ISNULL(b.PAID,0) as ULDEGDEL FROM ( SELECT a.APPOINTMENT_ID, SUM(a.TOTALPRICE) as TOTALPRICE FROM ( SELECT a.APPOINTMENT_ID, (a.PRICE*a.CNT)-(CEILING(((a.PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))) as TOTALPRICE FROM TBL_APPOINTMENT_DIAGNOSTICTYPE a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID AND b.PATIENT_ID=(SELECT PATIENT_ID FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"] + ") WHERE a.APPOINTMENT_ID<>" + Request.QueryString["id"] + " AND CONVERT(datetime, b.DT) < CONVERT(datetime, (SELECT DT FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"] + ")) UNION ALL SELECT a.APPOINTMENT_ID, (a.SERVICE_PRICE*a.CNT)-(CEILING(((a.SERVICE_PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))) as TOTALPRICE FROM TBL_APPOINTMENT_SERVICE a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID AND b.PATIENT_ID=(SELECT PATIENT_ID FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"] + ") WHERE a.APPOINTMENT_ID<>" + Request.QueryString["id"] + " AND CONVERT(datetime, b.DT) < CONVERT(datetime, (SELECT DT FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"] + ")) UNION ALL SELECT a.APPOINTMENT_ID,(a.PART_PRICE*a.CNT)-(CEILING(((a.PART_PRICE*a.CNT)/100)*ISNULL(a.DISCPER, 0))) as TOTALPRICE FROM TBL_APPOINTMENT_PART a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID AND b.PATIENT_ID=(SELECT PATIENT_ID FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"] + ") WHERE a.APPOINTMENT_ID<>" + Request.QueryString["id"] + " AND CONVERT(datetime, b.DT) < CONVERT(datetime, (SELECT DT FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"] + ")) ) a GROUP BY a.APPOINTMENT_ID ) a INNER JOIN TBL_APPOINTMENT b ON a.APPOINTMENT_ID=b.ID ) a";
string strQry8 = "SELECT ISNULL(PAID,0) as PAID FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"];
string strQry9 = "SELECT ISNULL(WAGE,0) as WAGE FROM TBL_APPOINTMENT WHERE ID=" + Request.QueryString["id"];
int intTuluhDun = 0, intTulugduuguiDun = 0;
ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1 + " " + strQry2 + " " + strQry3 + " " + strQry4 + " " + strQry5 + " " + strQry6 + " " + strQry7 + " " + strQry8 + " " + strQry9);
pAppointmentCode.InnerHtml = ds.Tables[0].Rows[0]["APPOINTMENT_NUM"].ToString();
pPatientCode.InnerHtml = ds.Tables[0].Rows[0]["PATIENT_CODE"].ToString();
pPatientName.InnerHtml = ds.Tables[0].Rows[0]["PATIENT_NAME"].ToString();
pAutoNo.InnerHtml = ds.Tables[0].Rows[0]["PATIENT_AUTONO"].ToString();
pAppointmentDate.InnerHtml = ds.Tables[0].Rows[0]["APPOINTMENT_DT"].ToString();
pAppointmentStartTime.InnerHtml = ds.Tables[0].Rows[0]["APPOINTMENT_STARTTIME"].ToString();
pAppointmentEndTime.InnerHtml = ds.Tables[0].Rows[0]["APPOINTMENT_ENDTIME"].ToString();
pClinicAddr.InnerHtml = ds.Tables[0].Rows[0]["CLINIC_ADDR"].ToString();
pClinicTel.InnerHtml = ds.Tables[0].Rows[0]["CLINIC_TEL"].ToString();
pClinicEmail.InnerHtml = ds.Tables[0].Rows[0]["CLINIC_EMAIL"].ToString();
pClinicWeb.InnerHtml = ds.Tables[0].Rows[0]["CLINIC_WEB"].ToString();
strMyVal = "";
//if (ds.Tables[1].Rows.Count != 0)
//{
// foreach (DataRow dr in ds.Tables[1].Rows)
// {
// strMyVal += "<tr>";
// strMyVal += "<td style=\"width:50%; padding:1px 5px; border:1px solid #DDD; font-size:11px;\">" + dr["REQUESTTYPE_NAME"].ToString() + "</td>";
// strMyVal += "<td style=\"width:50%; padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">" + dr["ISCHECK"].ToString() + "</td>";
// strMyVal += "</tr>";
// }
// //pAppointmentRequestList.InnerHtml = strMyVal;
//}
//total services
strMyVal = "";
if (ds.Tables[2].Rows.Count != 0)
{
strMyVal += "<tr><th colspan=\"6\" style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">Оношлогоо</th></tr>";
foreach (DataRow dr in ds.Tables[2].Rows)
{
strMyVal += "<tr>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px;\">" + dr["NAME"].ToString() + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(dr["PRICE"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">" + dr["CNT"].ToString() + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(dr["TOTALPRICE"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">" + dr["DISCPER"].ToString() + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(dr["PAYPRICE"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "</tr>";
}
}
if (ds.Tables[3].Rows.Count != 0)
{
strMyVal += "<tr><th colspan=\"6\" style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">Засвар үйлчилгээ</th></tr>";
foreach (DataRow dr in ds.Tables[3].Rows)
{
strMyVal += "<tr>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px;\">" + dr["NAME"].ToString() + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(dr["PRICE"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">" + dr["CNT"].ToString() + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(dr["TOTALPRICE"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">" + dr["DISCPER"].ToString() + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(dr["PAYPRICE"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "</tr>";
}
}
if (ds.Tables[4].Rows.Count != 0)
{
strMyVal += "<tr><th colspan=\"6\" style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">Солисон сэлбэг</th></tr>";
foreach (DataRow dr in ds.Tables[4].Rows)
{
strMyVal += "<tr>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px;\">" + dr["NAME"].ToString() + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(dr["PRICE"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">" + dr["CNT"].ToString() + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(dr["TOTALPRICE"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">" + dr["DISCPER"].ToString() + "</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(dr["PAYPRICE"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "</tr>";
}
}
strMyVal += "<tr>";
strMyVal += "<th colspan=\"5\" style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">Нийт</th>";
strMyVal += "<th style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(ds.Tables[5].Rows[0]["TOTALPRICE"].ToString())).Replace("$", String.Empty) + "</th>";
strMyVal += "</tr>";
intTuluhDun = Int32.Parse(ds.Tables[5].Rows[0]["TOTALPRICE"].ToString());
strMyVal += "<tr>";
strMyVal += "<td colspan=\"5\" style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">Ажлын хөлс</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(ds.Tables[9].Rows[0]["WAGE"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "</tr>";
intTuluhDun += Int32.Parse(ds.Tables[9].Rows[0]["WAGE"].ToString());
//strMyVal += "<tr><td colspan=\"6\"> </td></tr>";
//strMyVal += "<tr>";
//strMyVal += "<td colspan=\"5\" style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">Хөнглөлт</td>";
//strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(ds.Tables[6].Rows[0]["DISCOUNT"].ToString())).Replace("$", String.Empty) + "</td>";
//strMyVal += "</tr>";
//intTuluhDun -= Int32.Parse(ds.Tables[6].Rows[0]["DISCOUNT"].ToString());
strMyVal += "<tr>";
strMyVal += "<td colspan=\"5\" style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">Өмнөх үлдэгдэл</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(ds.Tables[7].Rows[0]["ULDEGDEL"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "</tr>";
intTuluhDun += Int32.Parse(ds.Tables[7].Rows[0]["ULDEGDEL"].ToString());
strMyVal += "<tr>";
strMyVal += "<th colspan=\"5\" style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">Төлөх дүн</th>";
strMyVal += "<th style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(intTuluhDun.ToString())).Replace("$", String.Empty) + "</th>";
strMyVal += "</tr>";
strMyVal += "<tr>";
strMyVal += "<td colspan=\"5\" style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">Төлсөн дүн</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(ds.Tables[8].Rows[0]["PAID"].ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "</tr>";
intTulugduuguiDun = intTuluhDun - Int32.Parse(ds.Tables[8].Rows[0]["PAID"].ToString());
strMyVal += "<tr>";
strMyVal += "<td colspan=\"5\" style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:center;\">Төлөгдөөгүй дүн</td>";
strMyVal += "<td style=\"padding:1px 5px; border:1px solid #DDD; font-size:11px; text-align:right;\">" + String.Format("{0:C0}", Convert.ToDecimal(intTulugduuguiDun.ToString())).Replace("$", String.Empty) + "</td>";
strMyVal += "</tr>";
pAppointmentServicesList.InnerHtml = strMyVal;
}
else
{
Response.Redirect("~/#pg/patient.aspx");
}
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
ModifyDB myObj = new ModifyDB();
GetData myObjGetData = new GetData();
DataSet ds = null;
try
{
ds = myObj.ExecuteDataSet(@"SELECT
a.ID,
a.SELLCARS_ID,
g.NAME as AUTOMARK_TYPE_NAME,
f.NAME as AUTOMARK_NAME,
d.NAME as SPECTYPE_NAME,
c.PRODUCEDYEAR,
c.VINNO,
i.NAME as FUELTYPE_NAME,
j.NAME as TRANSMISSIONTYPE_NAME,
k.NAME as ZAALTTYPE_NAME,
l.CODE as EXTCOLOR_CODE,
l.NAME as EXTCOLOR_NAME,
l.HTMLCODE as EXTCOLOR_HTMLCODE,
m.CODE as INTCOLOR_CODE,
m.NAME as INTCOLOR_NAME,
m.HTMLCODE as INTCOLOR_HTMLCODE,
c.GETDT,
c.PRICE,
N'Үүсгэсэн: ' + CONVERT(VARCHAR(19),a.CREATED_DATE, 120) + N'lt;br/gt;Сүүлд засварласан: ' + CONVERT(VARCHAR(19),ISNULL(a.UPDATED_DATE,a.CREATED_DATE), 120) as MODIFIEDCAR,
b.RD as CUSTOMERRD,
b.NAME as CUSTOMERNAME,
CASE WHEN b.TEL2 is null THEN b.TEL ELSE b.TEL+', '+b.TEL2 END as CUSTOMERTEL,
b.EMAIL as CUSTOMEREMAIL,
b.ADDRESS as CUSTOMERADDRESS
FROM TBL_SOLDCARCUSTOMER_SELLCARS a
INNER JOIN TBL_SOLDCARCUSTOMER b ON a.SOLDCARCUSTOMER_ID=b.ID
INNER JOIN TBL_SELLCARS c ON a.SELLCARS_ID=c.ID
INNER JOIN TBL_SPECTYPE d ON c.SPECTYPE_ID=d.ID
INNER JOIN TBL_AUTOMARK f ON d.MARK_ID=f.ID
INNER JOIN TBL_AUTOMARK_TYPE g ON f.AUTOMARK_TYPE_ID=g.ID
INNER JOIN TBL_SELLCARSPAYMENTTYPE h ON a.SELLCARSPAYMENTTYPE_ID=h.ID
INNER JOIN TBL_FUELTYPE i ON c.FUELTYPE_ID=i.ID
INNER JOIN TBL_TRANSMISSIONTYPE j ON c.TRANSMISSIONTYPE_ID=j.ID
INNER JOIN TBL_ZAALTTYPE k ON c.ZAALTTYPE_ID=k.ID
INNER JOIN TBL_CARCOLOR l ON c.EXTCOLOR_ID=l.ID
INNER JOIN TBL_CARCOLOR m ON c.INTCOLOR_ID=m.ID
WHERE a.ID=" + Request.QueryString["id"]);
if (ds.Tables[0].Rows.Count != 0)
{
dealerTab4CarShowModalDivMarktype.InnerHtml = ds.Tables[0].Rows[0]["AUTOMARK_TYPE_NAME"].ToString();
dealerTab4CarShowModalDivMark.InnerHtml = ds.Tables[0].Rows[0]["AUTOMARK_NAME"].ToString();
dealerTab4CarShowModalDivSpec.InnerHtml = ds.Tables[0].Rows[0]["SPECTYPE_NAME"].ToString();
dealerTab4CarShowModalDivVinno.InnerHtml = ds.Tables[0].Rows[0]["VINNO"].ToString();
dealerTab4CarShowModalDivProducedyear.InnerHtml = ds.Tables[0].Rows[0]["PRODUCEDYEAR"].ToString();
dealerTab4CarShowModalDivFueltype.InnerHtml = ds.Tables[0].Rows[0]["FUELTYPE_NAME"].ToString();
dealerTab4CarShowModalDivTransmissiontype.InnerHtml = ds.Tables[0].Rows[0]["TRANSMISSIONTYPE_NAME"].ToString();
dealerTab4CarShowModalDivZaalttype.InnerHtml = ds.Tables[0].Rows[0]["ZAALTTYPE_NAME"].ToString();
dealerTab4CarShowModalDivGetdt.InnerHtml = ds.Tables[0].Rows[0]["GETDT"].ToString();
dealerTab4CarShowModalDivPrice.InnerHtml = ds.Tables[0].Rows[0]["PRICE"].ToString();
dealerTab4CarShowModalDivExternalcolorcode.InnerHtml = ds.Tables[0].Rows[0]["EXTCOLOR_HTMLCODE"].ToString();
dealerTab4CarShowModalDivInternalcolorcode.InnerHtml = ds.Tables[0].Rows[0]["INTCOLOR_HTMLCODE"].ToString();
dealerTab4CarShowModalDivExternalcolorname.InnerHtml = ds.Tables[0].Rows[0]["EXTCOLOR_NAME"].ToString();
dealerTab4CarShowModalDivInternalcolorname.InnerHtml = ds.Tables[0].Rows[0]["INTCOLOR_NAME"].ToString();
dealerTab4CarShowModalModifyDescription.InnerHtml = myObjGetData.getReplaceDatabaseToDisplay(ds.Tables[0].Rows[0]["MODIFIEDCAR"].ToString());
}
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
ModifyDB myObj = new ModifyDB();
myPdfFile.Src = "../files/agreement/" + myObj.ExecuteScalar("SELECT AGREEMENTATTACH FROM TBL_SOLDCARCUSTOMER_SELLCARS WHERE ID=" + Request.QueryString["id"]).ToString();
}
protected void setDatas()
{
ModifyDB myObjModifyDB = new ModifyDB();
GetData myObjGetData = new GetData();
try
{
string strQry0 = "SELECT '' as ID, N'- Бүгд -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME+' /'+CODE+'/' as NAME FROM TBL_CARCOLOR WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=1) AND CARCOLORTYPE_ID=1 ORDER BY NAME";
string strQry1 = "SELECT '' as ID, N'- Бүгд -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME+' /'+CODE+'/' as NAME FROM TBL_CARCOLOR WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=1) AND CARCOLORTYPE_ID=2 ORDER BY NAME";
string strQry2 = "SELECT '' as ID, N'- Сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_AUTOMARK_TYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")";
string strQry3 = "SELECT '' as ID, N'- Сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_SELLCARSORDERTYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")";
string strQry4 = "SELECT '' as ID, N'- Сонго -' as NAME UNION ALL SELECT CAST(ID as varchar) as ID, NAME FROM TBL_SELLCARSPAYMENTTYPE WHERE CLINIC_ID=(SELECT CLINIC_ID FROM TBL_USER WHERE ID=" + Session["eBook_UserID"].ToString() + ")";
string strQry5 = @"SELECT a.ID, a.NAME, a.POSNAME
FROM (
SELECT '' as ID, N'- Сонго -' as NAME, null as POSNAME
UNION ALL
SELECT CAST(a.ID as varchar) as ID, a.FNAME+'.'+LEFT(a.LNAME,1)+' | '+b.NAME as NAME, b.NAME as POSNAME
FROM TBL_STAFF a
INNER JOIN TBL_STAFF_POSITION b ON a.STAFF_POSITION_ID=b.ID
WHERE a.ISACTIVE=1 AND a.CLINIC_ID=1
) a
ORDER BY a.POSNAME, a.NAME";
DataSet ds = myObjModifyDB.ExecuteDataSet(strQry0 + " " + strQry1 + " " + strQry2 + " " + strQry3 + " " + strQry4 + " " + strQry5);
pTab1SelectExtcolor.DataSource = ds.Tables[0];
pTab1SelectExtcolor.DataTextField = "NAME";
pTab1SelectExtcolor.DataValueField = "ID";
pTab1SelectExtcolor.DataBind();
pTab2SelectExtcolor.DataSource = ds.Tables[0];
pTab2SelectExtcolor.DataTextField = "NAME";
pTab2SelectExtcolor.DataValueField = "ID";
pTab2SelectExtcolor.DataBind();
pTab1SelectIntcolor.DataSource = ds.Tables[1];
pTab1SelectIntcolor.DataTextField = "NAME";
pTab1SelectIntcolor.DataValueField = "ID";
pTab1SelectIntcolor.DataBind();
pTab2SelectIntcolor.DataSource = ds.Tables[1];
pTab2SelectIntcolor.DataTextField = "NAME";
pTab2SelectIntcolor.DataValueField = "ID";
pTab2SelectIntcolor.DataBind();
pTab1ModalSelectMarktype.DataSource = ds.Tables[2];
pTab1ModalSelectMarktype.DataTextField = "NAME";
pTab1ModalSelectMarktype.DataValueField = "ID";
pTab1ModalSelectMarktype.DataBind();
pTab3ModalSelectOrdertype.DataSource = ds.Tables[3];
pTab3ModalSelectOrdertype.DataTextField = "NAME";
pTab3ModalSelectOrdertype.DataValueField = "ID";
pTab3ModalSelectOrdertype.DataBind();
pTab1ModalSellSelectPaymenttype.DataSource = ds.Tables[4];
pTab1ModalSellSelectPaymenttype.DataTextField = "NAME";
pTab1ModalSellSelectPaymenttype.DataValueField = "ID";
pTab1ModalSellSelectPaymenttype.DataBind();
pTab1ModalSellSelectSoldstaff.DataSource = ds.Tables[5];
pTab1ModalSellSelectSoldstaff.DataTextField = "NAME";
pTab1ModalSellSelectSoldstaff.DataValueField = "ID";
pTab1ModalSellSelectSoldstaff.DataBind();
int highyr = DateTime.Now.Year;
int lowyr = DateTime.Now.Year - 100;
for (highyr = DateTime.Now.Year; highyr >= lowyr; highyr--)
{
pTab1ModalSelectProducedyear.Items.Add(new ListItem(highyr.ToString(), highyr.ToString()));
pTab3ModalSelectProducedyear.Items.Add(new ListItem(highyr.ToString(), highyr.ToString()));
pTab3SelectYr.Items.Add(new ListItem(highyr.ToString(), highyr.ToString()));
}
pTab3SelectYr.SelectedIndex = pTab3SelectYr.Items.IndexOf(pTab3SelectYr.Items.FindByValue(DateTime.Now.Year.ToString()));
pTab3SelectMnth.SelectedIndex = pTab3SelectMnth.Items.IndexOf(pTab3SelectMnth.Items.FindByValue(DateTime.Now.Month.ToString()));
}
catch (cs.MyException ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
catch (Exception ex)
{
myObjGetData.exeptionMethod(ex);
Response.Redirect("~/#pg/error500.aspx");
}
}
