private void bntLoad_Click(object sender, EventArgs e)
{
Tang k = new Tang();
k.MATANG = "Ms23";
k.MACAOOC = "ssldj";
k.SOPHONG = 5;
tbll.Add(k);
}
private Tang GetThuocFromDataRow(DataRow row)
{
Tang k = new Tang();
k.MATANG = row["MATANG"].ToString().Trim();
k.MACAOOC = row["MACAOOC"].ToString().Trim();
k.SOPHONG = int.Parse(row["GIA"].ToString().Trim());
return(k);
}
public bool Update(Tang bs)
{
try
{
return(dal.Update(bs));
}
catch (Exception ex)
{
throw ex;
}
}
public bool Add(Tang k)
{
try
{
return(dal.Add(k));
}
catch (Exception ex)
{
throw ex;
}
}
private void setDataView()
{
try
{
dxErrorProviderInfo.ClearErrors();
if (listViTriHienThi.Count > 0)
{
if (treeListViTri.FocusedNode != null && treeListViTri.FocusedNode.GetValue(colloai) != null && !GUID.From(treeListViTri.FocusedNode.GetValue(colid)).Equals(Guid.Empty))
{
if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(CoSo).Name))
{
editGUI("view", typeof(CoSo).Name);
objCoSo = CoSo.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objCoSo.ten;
txtMoTa.Text = objCoSo.mota;
node = typeof(CoSo).Name;
}
else if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(Dayy).Name))
{
editGUI("view", typeof(Dayy).Name);
objDay = Dayy.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objDay.ten;
txtMoTa.Text = objDay.mota;
node = typeof(Dayy).Name;
_ucComboBoxCoSo.ViTri = ViTri.request(objDay.coso, null, null);
}
else if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(Tang).Name))
{
editGUI("view", typeof(Tang).Name);
objTang = Tang.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objTang.ten;
txtMoTa.Text = objTang.mota;
node = typeof(Tang).Name;
_ucComboBoxDay.ViTri = ViTri.request(null, objTang.day, null);
}
}
else
{
editGUI("nothing", "");
}
}
else
{
editGUI("nothing", "");
}
}
catch (Exception ex)
{
Debug.WriteLine(this.Name + "->setDataView: " + ex.Message);
}
}
public bool Update(Tang k)
{
string query = string.Format("UPDATE TANG SET MACAOOC = (N'{0}'), SOPHONG = (N'{1}') WHERE MATANG = (N'{2}')", k.MACAOOC, k.SOPHONG, k.MATANG);
try
{
helper.ExecuteNonQuery(query);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
private void btnThemQuyenTang_Click(object sender, EventArgs e)
{
//Nếu trong ds hiện tại có quyền cấu hình y chang
Permission tmp = input.Where(
c =>
c.key.ToUpper().Equals(Tang.USNAME)
&&
c.stand_alone == false
&&
c.recursive_to_child == checkEdit_quyenBaoHam.Checked
&&
c.allow_or_deny == !checkEdit_quyenDeny.Checked
&&
c.can_edit == checkEdit_quyenSua.Checked
&&
c.can_delete == checkEdit_quyenXoa.Checked
&&
c.can_view == checkEdit_quyenXem.Checked
).FirstOrDefault();
Tang dangChon = (gridView_Tang.GetFocusedRow() as TangFilter).tang;
if (dangChon == null)
{
return;
}
if (tmp == null)
{
tmp = Permission.request(false, Tang.USNAME, !checkEdit_quyenDeny.Checked, checkEdit_quyenBaoHam.Checked, checkEdit_quyenXem.Checked, checkEdit_quyenSua.Checked, checkEdit_quyenXoa.Checked);
//add object list to tmp
tmp.tangs.Add(dangChon);
//add to input
input.Add(tmp);
//reload
reloadDSQuyen();
}
else
{
//Nếu CS chưa có trong ds thì mới add
if (!tmp.tangs.Contains(dangChon))
{
//add object list to tmp
tmp.tangs.Add(dangChon);
//reload
reloadDSQuyen();
}
}
}
public bool Add(Tang k)
{
string query = string.Format("INSERT INTO TANG values (N'{0}',N'{1}',{2}')", k.MATANG, k.MACAOOC, k.SOPHONG);
try
{
helper.ExecuteNonQuery(query);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public ViTri getVitri()
{
try
{
ViTri obj = new ViTri();
obj.coso = CoSo.getById(cosoid);
obj.day = Dayy.getById(dayid);
obj.tang = Tang.getById(tangid);
return(obj);
}
catch (Exception ex)
{
Debug.WriteLine(this.Name + "->getVitri: " + ex.Message);
return(null);
}
}
public Tang Search(string id)
{
DataTable table = null;
int n = 0;
string query = string.Format("SELECT * FROM TANG WHERE MATANG = (N'{0}')", id);
table = helper.ExecuteQuery(query);
n = table.Rows.Count;
if (n == 0)
{
return(null);
}
Tang k = GetThuocFromDataRow(table.Rows[0]);
return(k);
}
public Tang[] GetList()
{
Tang[] list = null;
DataTable table = null;
int n = 0;
table = helper.ExecuteQuery("select * from TANG");
n = table.Rows.Count;
if (n == 0)
{
return(null);
}
list = new Tang[n];
for (int i = 0; i < n; i++)
{
Tang s = GetThuocFromDataRow(table.Rows[i]);
list[i] = s;
}
return(list);
}
public static bool ImportPhong(String fileName, String sheet)
{
try
{
int line = 0;
System.Data.DataTable dt = new System.Data.DataTable();
const int STT = 0;
const int MAPHONG = 1;
const int TENPHONG = 2;
const int LOAIPHONG = 3;
//const int SOCHONGOI = 4;
const int MOTA = 5;
const int COSO = 6;
const int DAY = 7;
const int TANG = 8;
const int PASS = 9;
dt = OpenFile(fileName, sheet);
if (dt != null)
{
int lines = dt.Rows.Count;
foreach (System.Data.DataRow row in dt.Rows)
{
line++;
DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Import Phòng... " +
String.Format(System.Globalization.CultureInfo.InvariantCulture, "{0:0.0}", (line * 1.0 / lines) * 100) + "%");
bool ok = false;
if (!row[PASS].Equals("Pass"))
{
if (row[TENPHONG] != DBNull.Value)
{
if (Phong.getAll().FirstOrDefault(c => c.ten.ToUpper() == row[TENPHONG].ToString().Trim().ToUpper()) == null)
{
try
{
ViTri objViTri = new ViTri();
CoSo objCoSo = new CoSo();
Dayy objDay = new Dayy();
Tang objTang = new Tang();
LoaiPhong objLoai = new LoaiPhong();
if (row[COSO] != DBNull.Value)
{
objCoSo = CoSo.getAll().Where(c => c.ten.ToUpper().Equals(row[COSO].ToString().Trim().ToUpper())).FirstOrDefault();
if (objCoSo != null && objCoSo.id != Guid.Empty)
{
if (row[DAY] != DBNull.Value && objCoSo.days.Count > 0)
{
objDay = objCoSo.days.Where(c => c.ten.ToUpper().Equals(row[DAY].ToString().Trim().ToUpper())).FirstOrDefault();
if (objDay != null && objDay.id != Guid.Empty)
{
if (row[TANG] != DBNull.Value && objDay.tangs.Count > 0)
{
objTang = objDay.tangs.Where(c => c.ten.ToUpper().Equals(row[TANG].ToString().Trim().ToUpper())).FirstOrDefault();
if (objTang != null && objTang.id != Guid.Empty)
{
objViTri.coso = objCoSo;
objViTri.day = objDay;
objViTri.tang = objTang;
ok = true;
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có tầng)");
}
}
else if (row[TANG] == DBNull.Value)
{
objViTri.coso = objCoSo;
objViTri.day = objDay;
objViTri.tang = null;
ok = true;
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có tầng)");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có dãy)");
}
}
else if (row[DAY] == DBNull.Value)
{
objViTri.coso = objCoSo;
objViTri.day = null;
objViTri.tang = null;
ok = true;
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có dãy)");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có cơ sở)");
}
}
if (row[LOAIPHONG] != DBNull.Value)
{
objLoai = LoaiPhong.getAll().Where(c => c.ten.ToUpper().Equals(row[LOAIPHONG].ToString().Trim().ToUpper())).FirstOrDefault();
if (objLoai == null || objLoai.id == Guid.Empty)
{
objLoai = new LoaiPhong();
objLoai.ten = row[LOAIPHONG].ToString().Trim();
objLoai.mota = row[LOAIPHONG].ToString().Trim();
//ok = false;
//WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có loại phòng)");
}
}
else
{
ok = false;
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có loại phòng)");
}
if (ok)
{
Phong obj = new Phong();
obj.subId = row[MAPHONG] != DBNull.Value ? row[MAPHONG].ToString().Trim() : null;
obj.vitri = objViTri;
obj.ten = row[TENPHONG].ToString().Trim();
//obj.sochongoi = row[SOCHONGOI] != DBNull.Value ? Convert.ToInt32(row[SOCHONGOI].ToString()) : 0;
obj.mota = row[MOTA].ToString().Trim();
obj.loaiphong = objLoai;
if (obj.add() > 0 && DBInstance.commit() > 0)
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Pass");
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error");
}
}
}
catch (Exception ex)
{
Debug.WriteLine("ExcelDataBaseHelper->ImportPhong: " + ex.Message);
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Exist");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không đủ thông tin)");
}
}
}
}
return true;
}
catch (Exception ex)
{
Debug.WriteLine("ExcelDataBaseHelper->ImportPhong: " + ex.Message);
return false;
}
}
public void LoadData()
{
listViTriHienThi = ViTriHienThi.getAll();
if (listViTriHienThi.Count > 0)
{
_ucTreeViTri.CreateTreeList();
_ucTreeViTri.ASPxTreeList_ViTri.DataSource = listViTriHienThi;
_ucTreeViTri.ASPxTreeList_ViTri.DataBind();
SearchFunction();
if (Request.QueryString["key"] != null)
{
string key = "";
try
{
key = Request.QueryString["key"].ToString();
}
catch
{
Response.Redirect(Request.Url.AbsolutePath);
}
DevExpress.Web.ASPxTreeList.TreeListNode node = _ucTreeViTri.ASPxTreeList_ViTri.FindNodeByKeyValue(key);
if (node != null)
{
Guid id = GUID.From(node.GetValue("id"));
string type = node.GetValue("loai").ToString();
if (type.Equals(typeof(CoSo).Name))
{
objCoSo = CoSo.getById(id);
if (objCoSo != null)
{
Panel_ThongTinObj.Visible = true;
Label_ThongTin.Text = "Thông tin " + objCoSo.ten;
Libraries.ImageHelper.LoadImageWeb(objCoSo.hinhanhs.ToList(), _ucASPxImageSlider_Mobile.ASPxImageSlider_Object);
Label_Ten.Text = objCoSo.ten;
ucViTri_BreadCrumb.Label_TenViTri.Text = Label_Ten.Text = objCoSo.ten;
Label_Thuoc.Text = "[Đại học Sài Gòn]";
Panel_DiaChi.Visible = true;
Label_DiaChi.Text = objCoSo.diachi;
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objCoSo.mota);
if (objCoSo.diachi != null)
{
if (objCoSo.diachi.Length > 0)
{
Button_Map.Visible = true;
}
else
{
Button_Map.Visible = false;
}
}
else
{
Button_Map.Visible = false;
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else if (type.Equals(typeof(Dayy).Name))
{
objDay = Dayy.getById(id);
if (objDay != null)
{
Panel_ThongTinObj.Visible = true;
Label_ThongTin.Text = "Thông tin " + objDay.ten;
Libraries.ImageHelper.LoadImageWeb(objDay.hinhanhs.ToList(), _ucASPxImageSlider_Mobile.ASPxImageSlider_Object);
Label_Ten.Text = objDay.ten;
Label_Thuoc.Text = objDay.coso != null ? objDay.coso.ten : "[Cơ sở]";
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Panel_DiaChi.Visible = false;
Label_DiaChi.Text = "";
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objDay.mota);
Button_Map.Visible = false;
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else if (type.Equals(typeof(Tang).Name))
{
objTang = Tang.getById(id);
if (objTang != null)
{
Panel_ThongTinObj.Visible = true;
Label_ThongTin.Text = "Thông tin " + objTang.ten;
Libraries.ImageHelper.LoadImageWeb(objTang.hinhanhs.ToList(), _ucASPxImageSlider_Mobile.ASPxImageSlider_Object);
Label_Ten.Text = objTang.ten;
if (objTang.day != null)
{
if (objTang.day.coso != null)
{
Label_Thuoc.Text = objTang.day.coso.ten + " - " + objTang.day.ten;
}
else
{
Label_Thuoc.Text = "[Cơ sở] - " + objTang.day.ten;
}
}
else
{
Label_Thuoc.Text = "[Cơ sở] - [Dãy]";
}
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Panel_DiaChi.Visible = false;
Label_DiaChi.Text = "";
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objTang.mota);
Button_Map.Visible = false;
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
Panel_TreeViTri.Visible = true;
}
}
else
{
ucThongBaoLoi.Panel_ThongBaoLoi.Visible = true;
ucThongBaoLoi.Label_ThongBaoLoi.Text = "Chưa có vị trí";
}
}
private void setDataView()
{
try
{
dxErrorProvider1.ClearErrors();
if (listViTriHienThi.Count > 0)
{
if (treeListViTri.FocusedNode != null && treeListViTri.FocusedNode.GetValue(colloai) != null && !GUID.From(treeListViTri.FocusedNode.GetValue(colid)).Equals(Guid.Empty))
{
if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(CoSo).Name))
{
editGUI("view", typeof(CoSo).Name);
objCoSo = CoSo.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objCoSo.ten;
txtDiaChi.Text = objCoSo.diachi;
txtMoTa.Text = objCoSo.mota;
node = typeof(CoSo).Name;
listHinh = objCoSo.hinhanhs.ToList();
reloadImage();
editGUI2("view", typeof(CoSo).Name);
}
else if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(Dayy).Name))
{
editGUI("view", typeof(Dayy).Name);
objDay = Dayy.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objDay.ten;
txtMoTa.Text = objDay.mota;
node = typeof(Dayy).Name;
listHinh = objDay.hinhanhs.ToList();
ViTri objViTri = new ViTri();
objViTri.coso = objDay.coso;
_ucComboBoxViTri.ViTri = objViTri;
reloadImage();
editGUI2("view", typeof(Dayy).Name);
}
else if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(Tang).Name))
{
editGUI("view", typeof(Tang).Name);
objTang = Tang.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objTang.ten;
txtMoTa.Text = objTang.mota;
node = typeof(Tang).Name;
listHinh = objTang.hinhanhs.ToList();
ViTri objViTri = new ViTri();
objViTri.coso = objTang.day.coso;
objViTri.day = objTang.day;
_ucComboBoxViTriChonDay.ViTri = objViTri;
reloadImage();
editGUI2("view", typeof(Tang).Name);
}
}
else
{
editGUI("nothing", "");
editGUI2("nothing", "");
}
}
else
{
editGUI("nothing", "");
editGUI2("nothing", "");
}
}
catch (Exception ex)
{
Debug.WriteLine(this.Name + "->setDataView: " + ex.Message);
}
}
private void addObj(String _type)
{
try
{
switch (_type)
{
case "CoSo":
CoSo objCoSoNew = new CoSo();
objCoSoNew.ten = txtTen.Text;
objCoSoNew.mota = txtMoTa.Text;
objCoSo.diachi = txtDiaChi.Text;
objCoSoNew.hinhanhs = listHinh;
if (objCoSoNew.add() > 0 && DBInstance.commit() > 0)
{
XtraMessageBox.Show("Thêm cơ sở thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
reLoadAndSelectNode(objCoSoNew.id);
}
else
{
XtraMessageBox.Show("Thêm cơ sở không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
break;
case "Dayy":
Dayy objDayNew = new Dayy();
objDayNew.ten = txtTen.Text;
objDayNew.mota = txtMoTa.Text;
objDayNew.hinhanhs = listHinh;
ViTri _vitri = _ucComboBoxViTri.ViTri;
objDayNew.coso = _vitri.coso;
if (objDayNew.add() > 0 && DBInstance.commit() > 0)
{
XtraMessageBox.Show("Thêm dãy thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
reLoadAndSelectNode(objDayNew.id);
}
else
{
XtraMessageBox.Show("Thêm dãy không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
break;
case "Tang":
Tang objTangNew = new Tang();
objTangNew.ten = txtTen.Text;
objTangNew.mota = txtMoTa.Text;
objTangNew.hinhanhs = listHinh;
ViTri _vitri2 = _ucComboBoxViTriChonDay.ViTri;
objTangNew.day = _vitri2.day;
if (objTangNew.add() > 0 && DBInstance.commit() > 0)
{
XtraMessageBox.Show("Thêm tầng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
reLoadAndSelectNode(objTangNew.id);
}
else
{
XtraMessageBox.Show("Thêm tầng không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
break;
}
}
catch (Exception ex)
{
Debug.WriteLine(this.Name + "->addObj: " + ex.Message);
}
}
private void LoadDataObj(Guid id, int type)
{
switch (type)
{
case 1:
objCoSo = CoSo.getById(id);
if (objCoSo != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objCoSo.ten);
ucViTri_BreadCrumb.Label_TenViTri.Text = Label_Ten.Text = objCoSo.ten;
Label_Thuoc.Text = "[Đại học Sài Gòn]";
Label_MoTa.Text = StringHelper.ConvertRNToBR(objCoSo.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
case 2:
objDay = Dayy.getById(id);
if (objDay != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objDay.ten);
Label_Ten.Text = objDay.ten;
Label_Thuoc.Text = objDay.coso != null ? objDay.coso.ten : "[Cơ sở]";
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Label_MoTa.Text = StringHelper.ConvertRNToBR(objDay.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
case 3:
objTang = Tang.getById(id);
if (objTang != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objTang.ten);
Label_Ten.Text = objTang.ten;
if (objTang.day != null)
{
if (objTang.day.coso != null)
{
Label_Thuoc.Text = objTang.day.coso.ten + " - " + objTang.day.ten;
}
else
{
Label_Thuoc.Text = "[Cơ sở] - " + objTang.day.ten;
}
}
else
{
Label_Thuoc.Text = "[Cơ sở] - [Dãy]";
}
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Label_MoTa.Text = StringHelper.ConvertRNToBR(objTang.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
default:
Response.Redirect(Request.Url.AbsolutePath);
return;
}
}
private void setDataView()
{
try
{
dxErrorProviderInfo.ClearErrors();
if (listViTriHienThi.Count > 0)
{
if (treeListViTri.FocusedNode != null && treeListViTri.FocusedNode.GetValue(colloai) != null && !GUID.From(treeListViTri.FocusedNode.GetValue(colid)).Equals(Guid.Empty))
{
if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(CoSo).Name))
{
editGUI("view", typeof(CoSo).Name);
objCoSo = CoSo.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objCoSo.ten;
txtMoTa.Text = objCoSo.mota;
node = typeof(CoSo).Name;
}
else if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(Dayy).Name))
{
editGUI("view", typeof(Dayy).Name);
objDay = Dayy.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objDay.ten;
txtMoTa.Text = objDay.mota;
node = typeof(Dayy).Name;
_ucComboBoxCoSo.ViTri = ViTri.request(objDay.coso, null, null);
}
else if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(Tang).Name))
{
editGUI("view", typeof(Tang).Name);
objTang = Tang.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objTang.ten;
txtMoTa.Text = objTang.mota;
node = typeof(Tang).Name;
_ucComboBoxDay.ViTri = ViTri.request(null, objTang.day, null);
}
}
else
{
editGUI("nothing", "");
}
}
else
{
editGUI("nothing", "");
}
}
catch (Exception ex)
{
Debug.WriteLine(this.Name + "->setDataView: " + ex.Message);
}
}
private void LoadDataObj(Guid id, int type)
{
switch (type)
{
case 1:
CoSo objCoSo = CoSo.getById(id);
if (objCoSo != null)
{
ucPhong_BreadCrumb.Label_TenViTri.Text = objCoSo.ten;
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
case 2:
Dayy objDay = Dayy.getById(id);
if (objDay != null)
{
ucPhong_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", objDay.ten, objDay.coso != null ? objDay.coso.ten : "[Cơ sở]");
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
case 3:
Tang objTang = Tang.getById(id);
string thuoc = string.Empty;
if (objTang != null)
{
if (objTang.day != null)
{
if (objTang.day.coso != null)
{
thuoc = objTang.day.coso.ten + " - " + objTang.day.ten;
}
else
{
thuoc = "[Cơ sở] - " + objTang.day.ten;
}
}
else
{
thuoc = "[Cơ sở] - [Dãy]";
}
ucPhong_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", objTang.ten, thuoc);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
default:
Response.Redirect(Request.Url.AbsolutePath);
return;
}
}
public void ProcessRequest(HttpContext context)
{
if (context.Request.HttpMethod == "GET")
{
BaseServices.ValidUrl(Token);
}
if (context.Request.HttpMethod == "POST")
{
using (StreamReader sr = new StreamReader(context.Request.InputStream))
{
string str = sr.ReadToEnd();
//这时候其实应该新建工具类的，暂时放一放吧。先快速的把功能实现。
XElement xe = XElement.Parse(str);
string MsgType = xe.Element("MsgType").Value;
OurID = xe.Element("ToUserName").Value;
CounterID = xe.Element("FromUserName").Value;
if (MsgType != "text" && MsgType != "event" && MsgType != "voice" && MsgType != "location" && MsgType != "image")
{
Msg.RetrurnTextMsg(CounterID, OurID, "抱歉，暂不支持此类消息。");
}
if (MsgType == "event")
{
string Event = xe.Element("Event").Value.Trim();
if (Event == "CLICK" || Event == "VIEW" || Event == "pic_photo_or_album")
{
#region CLICK
string EventKey = xe.Element("EventKey").Value.Trim();
switch (EventKey)
{
case "查快递状态":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
Msg.RetrurnTextMsg(CounterID, OurID, "查快递状态\n请输入快递单号，如： 883000768272760447");
}
break;
case "查基金":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
Msg.RetrurnTextMsg(CounterID, OurID, "查基金\n请输入基金代码或基金名称。如：000001或华夏成长\n（支持模糊查询）\n注：服务器每天凌晨自动更新前一天的基金数据。");
//string[] titles = new string[] { "1", "2", "3"};
//string[] dess = new string[] { "one", "two", "three"};
//string[] pics = new string[] {"https://mmbiz.qpic.cn/mmbiz_jpg/Cf9GRFAWRNJZ29SDMydqYQ0dBkficAP0Aj6nGRHEbMAhtvDRozQLBRsVskDrb4kyPd6JJqZBwSMCjjd6Jo9hu6w/0?wx_fmt=jpeg","https://mmbiz.qpic.cn/mmbiz_jpg/Cf9GRFAWRNJZ29SDMydqYQ0dBkficAP0Aj6nGRHEbMAhtvDRozQLBRsVskDrb4kyPd6JJqZBwSMCjjd6Jo9hu6w/0?wx_fmt=jpeg","https://mmbiz.qpic.cn/mmbiz_jpg/Cf9GRFAWRNJZ29SDMydqYQ0dBkficAP0Aj6nGRHEbMAhtvDRozQLBRsVskDrb4kyPd6JJqZBwSMCjjd6Jo9hu6w/0?wx_fmt=jpeg"};
//string[] urls = new string[] {"","https://mp.weixin.qq.com/mp/homepage?__biz=MzIwODYwOTU3OA==&hid=6&sn=989b0faf398ee1ebdbe7e5303a142fe6","https://mp.weixin.qq.com/mp/homepage?__biz=MzIwODYwOTU3OA==&hid=6&sn=989b0faf398ee1ebdbe7e5303a142fe6"};
//Msg.ReturnNewsMsg(CounterID,OurID,3,titles,dess,pics,urls);
}
break;
case "数学的笔记与练习":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
com = "SELECT * FROM blue.articles where valid = '1' order by articleId";
dt = msql.S(com);
string[] titles = new string[dt.Rows.Count];
string[] dess = new string[dt.Rows.Count];
string[] pics = new string[dt.Rows.Count];
string[] urls = new string[dt.Rows.Count];
int i = 0;
foreach (DataRow dr in dt.Rows)
{
titles[i] = dr["title"].ToString();
dess[i] = dr["des"].ToString();
pics[i] = dr["pic"].ToString();
urls[i] = dr["url"].ToString();
i = i + 1;
}
//string[] titles = Convert.ToString(dt.Columns["title"]);
//Msg.RetrurnTextMsg(CounterID, OurID, "查基金\n请输入基金代码或基金名称。如：000001或华夏成长\n（支持模糊查询）\n注：服务器每天凌晨自动更新前一天的基金数据。");
//string[] titles = new string[] { "1", "2", "3"};
//string[] dess = new string[] { "one", "two", "three"};
//string[] pics = new string[] {"https://mmbiz.qpic.cn/mmbiz_jpg/Cf9GRFAWRNJZ29SDMydqYQ0dBkficAP0Aj6nGRHEbMAhtvDRozQLBRsVskDrb4kyPd6JJqZBwSMCjjd6Jo9hu6w/0?wx_fmt=jpeg","https://mmbiz.qpic.cn/mmbiz_jpg/Cf9GRFAWRNJZ29SDMydqYQ0dBkficAP0Aj6nGRHEbMAhtvDRozQLBRsVskDrb4kyPd6JJqZBwSMCjjd6Jo9hu6w/0?wx_fmt=jpeg","https://mmbiz.qpic.cn/mmbiz_jpg/Cf9GRFAWRNJZ29SDMydqYQ0dBkficAP0Aj6nGRHEbMAhtvDRozQLBRsVskDrb4kyPd6JJqZBwSMCjjd6Jo9hu6w/0?wx_fmt=jpeg"};
//string[] urls = new string[] {"","https://mp.weixin.qq.com/mp/homepage?__biz=MzIwODYwOTU3OA==&hid=6&sn=989b0faf398ee1ebdbe7e5303a142fe6","https://mp.weixin.qq.com/mp/homepage?__biz=MzIwODYwOTU3OA==&hid=6&sn=989b0faf398ee1ebdbe7e5303a142fe6"};
Msg.ReturnNewsMsg(CounterID, OurID, dt.Rows.Count, titles, dess, pics, urls);
}
break;
case "计量金融学的Python实现":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
com = "SELECT * FROM blue.articles where valid = '3' order by articleId";
dt = msql.S(com);
string[] titles = new string[dt.Rows.Count];
string[] dess = new string[dt.Rows.Count];
string[] pics = new string[dt.Rows.Count];
string[] urls = new string[dt.Rows.Count];
int i = 0;
foreach (DataRow dr in dt.Rows)
{
titles[i] = dr["title"].ToString();
dess[i] = dr["des"].ToString();
pics[i] = dr["pic"].ToString();
urls[i] = dr["url"].ToString();
i = i + 1;
}
//string[] titles = Convert.ToString(dt.Columns["title"]);
//Msg.RetrurnTextMsg(CounterID, OurID, "查基金\n请输入基金代码或基金名称。如：000001或华夏成长\n（支持模糊查询）\n注：服务器每天凌晨自动更新前一天的基金数据。");
//string[] titles = new string[] { "1", "2", "3"};
//string[] dess = new string[] { "one", "two", "three"};
//string[] pics = new string[] {"https://mmbiz.qpic.cn/mmbiz_jpg/Cf9GRFAWRNJZ29SDMydqYQ0dBkficAP0Aj6nGRHEbMAhtvDRozQLBRsVskDrb4kyPd6JJqZBwSMCjjd6Jo9hu6w/0?wx_fmt=jpeg","https://mmbiz.qpic.cn/mmbiz_jpg/Cf9GRFAWRNJZ29SDMydqYQ0dBkficAP0Aj6nGRHEbMAhtvDRozQLBRsVskDrb4kyPd6JJqZBwSMCjjd6Jo9hu6w/0?wx_fmt=jpeg","https://mmbiz.qpic.cn/mmbiz_jpg/Cf9GRFAWRNJZ29SDMydqYQ0dBkficAP0Aj6nGRHEbMAhtvDRozQLBRsVskDrb4kyPd6JJqZBwSMCjjd6Jo9hu6w/0?wx_fmt=jpeg"};
//string[] urls = new string[] {"","https://mp.weixin.qq.com/mp/homepage?__biz=MzIwODYwOTU3OA==&hid=6&sn=989b0faf398ee1ebdbe7e5303a142fe6","https://mp.weixin.qq.com/mp/homepage?__biz=MzIwODYwOTU3OA==&hid=6&sn=989b0faf398ee1ebdbe7e5303a142fe6"};
Msg.ReturnNewsMsg(CounterID, OurID, dt.Rows.Count, titles, dess, pics, urls);
}
break;
case "蓝色机器人":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
Msg.RetrurnTextMsg(CounterID, OurID, "您好，我是人工智能机器人。请问需要什么帮助？\n\n【类似Siri】");
}
break;
case "量化分析沪深300成份股":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
Msg.RetrurnTextMsg(CounterID, OurID, "量化分析沪深300成份股\n1、该功能将最近一个交易日的沪深300成份股与最近一个交易日的所有沪深A股进行量化分析，求涨跌幅的相似度。\n2、<a href=\"http://www.csindex.com.cn/zh-CN/indices/index-detail/000300\">点击查看关于沪深300指数</a>\n\n请回复沪深300成份股代码或名称，如000001或平安银行\n支持模糊查询");
}
break;
case "人工智能写宋词":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
dt = msql.S("SELECT * from song.rnt");
string song = dt.Rows[0][0].ToString();
Msg.RetrurnTextMsg(CounterID, OurID, "人工智能写宋词\n服务器每五分钟自动酝酿一篇宋词。\n\n" + song + "\n\n倘若这首词写得不太好，还请谅解。 \ue41d");
}
break;
case "测海拔高度":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
Msg.RetrurnTextMsg(CounterID, OurID, "测海拔高度\n请发送微信位置");
}
break;
case "人工智能写唐诗":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
Tang t = new Tang();
string msg = t.RntMsg();
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
break;
case "探索火星":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
MarsCuriosity mc = new MarsCuriosity();
String msg = mc.ReturnLast();
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
break;
case "花是什么花":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
Msg.RetrurnTextMsg(CounterID, OurID, "花是什么花\n请发送特写照片\n\n不只可以识别花哦");
}
break;
case "色觉辨认助手":
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + EventKey + "')";
msql.I_D_U(com);
}
break;
case "C# ⇋ Java":
{
string com = "select count(*) FROM blue.ch where cid = '" + CounterID + "' and handle = 'C# To Java'";
DataTable dt = msql.S(com);
if (dt.Rows[0][0].ToString() == "0")
{
com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + "C# To Java" + "')";
msql.I_D_U(com);
Msg.RetrurnTextMsg(CounterID, OurID, "当前操作为C# To Java\n如需Java To C#，请再次点击菜单。\n\n请输入代码");
}
else
{
com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + "Java To C#" + "')";
msql.I_D_U(com);
Msg.RetrurnTextMsg(CounterID, OurID, "当前操作为Java To C#\n如需C# To Java，请再次点击菜单。\n\n请输入代码");
}
}
break;
default:
{
string com = "DELETE from blue.ch where cid = '" + CounterID + "';";
com = com + "INSERT INTO blue.ch (cid,handle) values ('" + CounterID + "','" + "公众号文章" + "')";
msql.I_D_U(com);
}
break;
}
#endregion
}
else
{
#region subscribe
if (Event == "subscribe")
{
Msg.RetrurnTextMsg(CounterID, OurID, "BlueYifan\n\n数学、便捷与更多。");
}
#endregion
}
}
else
{
#region text voice
if (MsgType == "text" || MsgType == "voice")
{
//传进来的时候，就把空格去掉。
string Content = "";
if (MsgType == "text")
{
Content = xe.Element("Content").Value.Trim();
}
else
{
Content = xe.Element("Recognition").Value.Trim();
}
dt = msql.S("SELECT handle from blue.ch where cid = '" + CounterID + "'");
if (dt.Rows.Count == 0)
{
BlueRobot br = new BlueRobot();
string msg = br.RntMsg(Content, CounterID);
Msg.RetrurnTextMsg(CounterID, OurID, msg);
return;
}
switch (dt.Rows[0][0].ToString())
{
case "查快递状态":
{
Regex r = new Regex(@"[\u4e00-\u9fa5]");
if (r.IsMatch(Content))
{
Msg.RetrurnTextMsg(CounterID, OurID, "请输入正确的快递单号。");
}
else
{
BlueRobot br = new BlueRobot();
string msg = br.RntMsg("查快递 " + Content, CounterID);
string[] a = msg.Split('\n');
string rnt = "";
foreach (string astr in a)
{
rnt = astr + "\n" + rnt;
}
Msg.RetrurnTextMsg(CounterID, OurID, rnt);
}
}
break;
case "查基金":
{
Fund f = new Fund();
string msg = f.FundNet(Content);
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
break;
case "蓝色机器人":
{
BlueRobot br = new BlueRobot();
if (Content == "【收到不支持的消息类型，暂无法显示】")
{
Msg.RetrurnTextMsg(CounterID, OurID, "我还理解不了表情包这种复杂的人类情感。");
}
else
{
string msg = br.RntMsg(Content, CounterID);
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
}
break;
case "量化分析沪深300成份股":
{
Quant300 q3 = new Quant300();
string msg = q3.Rnt(Content);
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
break;
case "探索火星":
{
MarsCuriosity mc = new MarsCuriosity();
string msg = mc.ReturnOrder(Content);
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
break;
case "C# To Java":
case "Java To C#":
{
CodeConvert c = new CodeConvert();
string msg = c.RntMsg(dt.Rows[0][0].ToString(), Content);
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
break;
default:
{
BlueRobot br = new BlueRobot();
if (Content == "【收到不支持的消息类型，暂无法显示】")
{
Msg.RetrurnTextMsg(CounterID, OurID, "我还理解不了表情包这种复杂的人类情感。");
}
else
{
string msg = br.RntMsg(Content, CounterID);
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
}
break;
}
}
#endregion
if (MsgType == "location")
{
string Label = xe.Element("Label").Value;
string Location_X = xe.Element("Location_X").Value;
string Location_Y = xe.Element("Location_Y").Value;
Elevation e = new Elevation();
string msg = e.RntMsg(Location_X, Location_Y);
msg = "所在地：" + Label + "\n纬度：" + Location_X + "\n经度：" + Location_Y + "\n海拔：" + msg;
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
if (MsgType == "image")
{
dt = msql.S("SELECT handle from blue.ch where cid = '" + CounterID + "'");
if (dt.Rows[0][0].ToString() == "色觉辨认助手")
{
string PicUrl = xe.Element("PicUrl").Value;
Color c = new Color();
string msg = c.RntMsg(PicUrl);
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
else
{
string PicUrl = xe.Element("PicUrl").Value;
Flower f = new Flower();
string msg = f.RntMsg(PicUrl);
Msg.RetrurnTextMsg(CounterID, OurID, msg);
}
}
}
}
}
}
private void addObj(String _type)
{
try
{
switch (_type)
{
case "CoSo":
CoSo objCoSoNew = new CoSo();
objCoSoNew.ten = txtTen.Text;
objCoSoNew.mota = txtMoTa.Text;
objCoSo.diachi = txtDiaChi.Text;
objCoSoNew.hinhanhs = listHinh;
if (objCoSoNew.add() > 0 && DBInstance.commit() > 0)
{
XtraMessageBox.Show("Thêm cơ sở thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
reLoadAndSelectNode(objCoSoNew.id);
}
else
{
XtraMessageBox.Show("Thêm cơ sở không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
break;
case "Dayy":
Dayy objDayNew = new Dayy();
objDayNew.ten = txtTen.Text;
objDayNew.mota = txtMoTa.Text;
objDayNew.hinhanhs = listHinh;
ViTri _vitri = _ucComboBoxViTri.ViTri;
objDayNew.coso = _vitri.coso;
if (objDayNew.add() > 0 && DBInstance.commit() > 0)
{
XtraMessageBox.Show("Thêm dãy thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
reLoadAndSelectNode(objDayNew.id);
}
else
{
XtraMessageBox.Show("Thêm dãy không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
break;
case "Tang":
Tang objTangNew = new Tang();
objTangNew.ten = txtTen.Text;
objTangNew.mota = txtMoTa.Text;
objTangNew.hinhanhs = listHinh;
ViTri _vitri2 = _ucComboBoxViTriChonDay.ViTri;
objTangNew.day = _vitri2.day;
if (objTangNew.add() > 0 && DBInstance.commit() > 0)
{
XtraMessageBox.Show("Thêm tầng thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
reLoadAndSelectNode(objTangNew.id);
}
else
{
XtraMessageBox.Show("Thêm tầng không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
break;
}
}
catch (Exception ex)
{
Debug.WriteLine(this.Name + "->addObj: " + ex.Message);
}
}
public static bool ImportPhong(String fileName, String sheet)
{
try
{
int line = 0;
System.Data.DataTable dt = new System.Data.DataTable();
const int STT = 0;
const int MAPHONG = 1;
const int TENPHONG = 2;
const int MOTA = 3;
const int COSO = 4;
const int DAY = 5;
const int TANG = 6;
const int NHANVIENPT = 7;
const int MANHANVIEN = 8;
const int NGAYTAO = 9;
const int HINHANH = 10;
const int PASS = 11;
dt = OpenFile(fileName, sheet);
if (dt != null)
{
int lines = dt.Rows.Count;
foreach (System.Data.DataRow row in dt.Rows)
{
line++;
DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Import Phòng... " +
String.Format(System.Globalization.CultureInfo.InvariantCulture, "{0:0.0}", (line * 1.0 / lines) * 100) + "%");
bool ok = false;
if (!row[PASS].Equals("Pass"))
{
if (row[TENPHONG] != DBNull.Value)
{
if (Phong.getAll().FirstOrDefault(c => c.ten.ToUpper() == row[TENPHONG].ToString().Trim().ToUpper()) == null)
{
try
{
ViTri objViTri = new ViTri();
CoSo objCoSo = new CoSo();
Dayy objDay = new Dayy();
Tang objTang = new Tang();
if(row[COSO] != DBNull.Value)
{
objCoSo = CoSo.getAll().Where(c => c.ten.ToUpper().Equals(row[COSO].ToString().Trim().ToUpper())).FirstOrDefault();
if (objCoSo != null && objCoSo.id != Guid.Empty)
{
if (row[DAY] != DBNull.Value && objCoSo.days.Count > 0)
{
objDay = objCoSo.days.Where(c => c.ten.ToUpper().Equals(row[DAY].ToString().Trim().ToUpper())).FirstOrDefault();
if (objDay != null && objDay.id != Guid.Empty)
{
if (row[TANG] != DBNull.Value && objDay.tangs.Count > 0)
{
objTang = objDay.tangs.Where(c => c.ten.ToUpper().Equals(row[TANG].ToString().Trim().ToUpper())).FirstOrDefault();
if (objTang != null && objTang.id != Guid.Empty)
{
objViTri.coso = objCoSo;
objViTri.day = objDay;
objViTri.tang = objTang;
ok = true;
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có tầng)");
}
}
else if (row[TANG] == DBNull.Value)
{
objViTri.coso = objCoSo;
objViTri.day = objDay;
objViTri.tang = null;
ok = true;
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có tầng)");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có dãy)");
}
}
else if (row[DAY] == DBNull.Value)
{
objViTri.coso = objCoSo;
objViTri.day = null;
objViTri.tang = null;
ok = true;
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có dãy)");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có cơ sở)");
}
}
if (ok)
{
Phong obj = new Phong();
obj.subId = row[MAPHONG] != DBNull.Value ? row[MAPHONG].ToString().Trim() : null;
obj.vitri = objViTri;
obj.ten = row[TENPHONG].ToString().Trim();
obj.date_create = row[NGAYTAO] != DBNull.Value ? (DateTime?)Convert.ToDateTime(row[NGAYTAO]) : DateTime.Now;
obj.mota = row[MOTA].ToString().Trim();
if (row[HINHANH] != DBNull.Value)
{
String[] file_names = row[HINHANH].ToString().Trim().Split(',');
obj.hinhanhs = AddImage(fileName, file_names);
}
if(row[NHANVIENPT] != DBNull.Value)
{
if (NhanVienPT.getAll().Where(c => c.hoten.ToUpper() == row[NHANVIENPT].ToString().Trim().ToUpper()).Count() == 1)
{
obj.nhanvienpt = NhanVienPT.getAll().FirstOrDefault(c => c.hoten.ToUpper() == row[NHANVIENPT].ToString().Trim().ToUpper());
}
else if (NhanVienPT.getAll().Where(c => c.hoten.ToUpper() == row[NHANVIENPT].ToString().Trim().ToUpper()).Count() > 1)
{
if (row[MANHANVIEN] != DBNull.Value)
{
if (NhanVienPT.getAll().Where(c => c.hoten.ToUpper() == row[NHANVIENPT].ToString().Trim().ToUpper() && c.subId.ToUpper() == row[MANHANVIEN].ToString().Trim().ToUpper()).Count() == 1)
{
obj.nhanvienpt = NhanVienPT.getAll().FirstOrDefault(c => c.hoten.ToUpper() == row[NHANVIENPT].ToString().Trim().ToUpper() && c.subId.ToUpper() == row[MANHANVIEN].ToString().Trim().ToUpper());
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Pass - Error (Mã nhân viên không đúng)");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Pass - Error (Nhân viên trùng tên nhưng không có mã)");
}
}
}
if (obj.add() > 0 && DBInstance.commit() > 0)
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Pass");
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error");
}
}
else
{
//WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Vị trí lỗi)");
}
}
catch (Exception ex)
{
Debug.WriteLine("ExcelDataBaseHelper->ImportPhong: " + ex.Message);
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Exist");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không đủ thông tin)");
}
}
}
}
return true;
}
catch (Exception ex)
{
Debug.WriteLine("ExcelDataBaseHelper->ImportPhong: " + ex.Message);
return false;
}
}
private void LoadDataObj(Guid id, int type)
{
switch (type)
{
case 1:
objCoSo = CoSo.getById(id);
if (objCoSo != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objCoSo.ten);
Libraries.ImageHelper.LoadImageWeb(objCoSo.hinhanhs.ToList(), _ucASPxImageSlider_Web.ASPxImageSlider_Object);
_ucASPxImageSlider_Web.urlHinhAnh = string.Format("http://{0}/HinhAnh.aspx?id={1}&type=COSO", HttpContext.Current.Request.Url.Authority, objCoSo.id);
ucViTri_BreadCrumb.Label_TenViTri.Text = Label_Ten.Text = objCoSo.ten;
Label_Thuoc.Text = "[Đại học Sài Gòn]";
Panel_DiaChi.Visible = true;
Label_DiaChi.Text = objCoSo.diachi;
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objCoSo.mota);
if (objCoSo.diachi != null)
{
if (objCoSo.diachi.Length > 0)
{
strSrc = @"https://www.google.com/maps/embed/v1/place?key=AIzaSyB2ryXlc0dNmczXS7O6E5htyRpkR4zvmVo&q=" + objCoSo.diachi;
popup.HeaderText = string.Format("Bản đồ {0}", objCoSo.ten);
LinkButtonBanDo.Text = popup.HeaderText;
LinkButtonBanDo.OnClientClick = string.Format("_ShowMaps('{0}'); return false;", strSrc);
}
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
case 2:
objDay = Dayy.getById(id);
if (objDay != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objDay.ten);
Libraries.ImageHelper.LoadImageWeb(objDay.hinhanhs.ToList(), _ucASPxImageSlider_Web.ASPxImageSlider_Object);
_ucASPxImageSlider_Web.urlHinhAnh = string.Format("http://{0}/HinhAnh.aspx?id={1}&type=DAY", HttpContext.Current.Request.Url.Authority, objDay.id);
Label_Ten.Text = objDay.ten;
Label_Thuoc.Text = objDay.coso != null ? objDay.coso.ten : "[Cơ sở]";
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Panel_DiaChi.Visible = false;
Label_DiaChi.Text = "";
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objDay.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
case 3:
objTang = Tang.getById(id);
if (objTang != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objTang.ten);
Libraries.ImageHelper.LoadImageWeb(objTang.hinhanhs.ToList(), _ucASPxImageSlider_Web.ASPxImageSlider_Object);
_ucASPxImageSlider_Web.urlHinhAnh = string.Format("http://{0}/HinhAnh.aspx?id={1}&type=TANG", HttpContext.Current.Request.Url.Authority, objTang.id);
Label_Ten.Text = objTang.ten;
if (objTang.day != null)
{
if (objTang.day.coso != null)
{
Label_Thuoc.Text = objTang.day.coso.ten + " - " + objTang.day.ten;
}
else
{
Label_Thuoc.Text = "[Cơ sở] - " + objTang.day.ten;
}
}
else
{
Label_Thuoc.Text = "[Cơ sở] - [Dãy]";
}
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Panel_DiaChi.Visible = false;
Label_DiaChi.Text = "";
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objTang.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
default:
Response.Redirect(Request.Url.AbsolutePath);
return;
}
}
public static bool ImportViTri(String fileName, String sheet)
{
try
{
int line = 0;
System.Data.DataTable dt = new System.Data.DataTable();
const int STT = 0;
const int MACOSO = 1;
const int COSO = 2;
const int MADAY = 3;
const int DAY = 4;
const int MATANG = 5;
const int TANG = 6;
const int MOTA = 7;
const int PASS = 8;
dt = OpenFile(fileName, sheet);
if (dt != null)
{
int lines = dt.Rows.Count;
foreach (System.Data.DataRow row in dt.Rows)
{
try
{
line++;
DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Import Vị trí... " +
String.Format(System.Globalization.CultureInfo.InvariantCulture, "{0:0.0}", (line * 1.0 / lines) * 100) + "%");
if (row[COSO] != DBNull.Value && !row[PASS].Equals("Pass"))
{
if (row[COSO] != DBNull.Value && row[DAY] != DBNull.Value && row[TANG] != DBNull.Value)
{
CoSo objCoSo = CoSo.getAll().FirstOrDefault(c => c.ten.ToUpper().Equals(row[COSO].ToString().Trim().ToUpper()));
if (objCoSo != null)
{
Dayy objDay = objCoSo.days.FirstOrDefault(c => c.ten.ToUpper().Equals(row[DAY].ToString().Trim().ToUpper()));
if (objDay != null)
{
if (objDay.tangs.FirstOrDefault(c => c.ten.ToUpper().Equals(row[TANG].ToString().Trim().ToUpper())) == null)
{
Tang obj = new Tang();
obj.subId = row[MATANG] != DBNull.Value ? row[MATANG].ToString().Trim() : null;
obj.ten = row[TANG].ToString().Trim();
obj.mota = row[MOTA].ToString().Trim();
obj.day = objDay;
if (obj.add() > 0 && DBInstance.commit() > 0)
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Pass");
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Exist");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có dãy)");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có cơ sở)");
}
}
else if (row[COSO] != DBNull.Value && row[DAY] != DBNull.Value && row[TANG] == DBNull.Value)
{
CoSo objCoSo = CoSo.getAll().FirstOrDefault(c => c.ten.ToUpper().Equals(row[COSO].ToString().Trim().ToUpper()));
if (objCoSo != null)
{
if (objCoSo.days.FirstOrDefault(c => c.ten.ToUpper().Equals(row[DAY].ToString().Trim().ToUpper())) == null)
{
Dayy obj = new Dayy();
obj.subId = row[MADAY] != DBNull.Value ? row[MADAY].ToString().Trim() : null;
obj.ten = row[DAY].ToString().Trim();
obj.mota = row[MOTA].ToString().Trim();
obj.coso = objCoSo;
if (obj.add() > 0 && DBInstance.commit() > 0)
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Pass");
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Exist");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không có cơ sở)");
}
}
else if (row[COSO] != DBNull.Value && row[DAY] == DBNull.Value && row[TANG] == DBNull.Value)
{
if (CoSo.getAll().FirstOrDefault(c => c.ten.ToUpper().Equals(row[COSO].ToString().Trim().ToUpper())) == null)
{
CoSo obj = new CoSo();
obj.subId = row[MACOSO] != DBNull.Value ? row[MACOSO].ToString().Trim() : null;
obj.ten = row[COSO].ToString().Trim();
obj.mota = row[MOTA].ToString().Trim();
if (obj.add() > 0 && DBInstance.commit() > 0)
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Pass");
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Exist");
}
}
else
{
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không đủ thông tin)");
}
}
}
catch (Exception ex)
{
Debug.WriteLine("ExcelDataBaseHelper->ImportViTri: " + ex.Message);
WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error");
}
}
}
return true;
}
catch (Exception ex)
{
Debug.WriteLine("ExcelDataBaseHelper->ImportViTri: " + ex.Message);
return false;
}
}
public void LoadData()
{
listViTriHienThi = ViTriHienThi.getAll();
if (listViTriHienThi.Count > 0)
{
ucTreeViTri.CreateTreeList();
ucTreeViTri.ASPxTreeList_ViTri.DataSource = listViTriHienThi;
ucTreeViTri.ASPxTreeList_ViTri.DataBind();
SearchFunction();
treevitri.Visible = true;
if (Request.QueryString["key"] != null)
{
string key = "";
try
{
key = Request.QueryString["key"].ToString();
}
catch
{
Response.Redirect(Request.Url.AbsolutePath);
}
DevExpress.Web.ASPxTreeList.TreeListNode node = ucTreeViTri.ASPxTreeList_ViTri.FindNodeByKeyValue(key);
if (node != null)
{
node.Focus();
ucTreeViTri.FocusAndExpandToNode(node);
Guid id = GUID.From(node.GetValue("id"));
string type = node.GetValue("loai").ToString();
if (type.Equals(typeof(CoSo).Name))
{
objCoSo = CoSo.getById(id);
if (objCoSo != null)
{
info.Visible = true;
Label_ThongTin.Text = "Thông tin " + objCoSo.ten;
Label_Ten.Text = objCoSo.ten;
ucViTri_BreadCrumb.Label_TenViTri.Text = Label_Ten.Text = objCoSo.ten;
Label_Thuoc.Text = "[Đại học Sài Gòn]";
Label_MoTa.Text = StringHelper.ConvertRNToBR(objCoSo.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else if (type.Equals(typeof(Dayy).Name))
{
objDay = Dayy.getById(id);
if (objDay != null)
{
info.Visible = true;
Label_ThongTin.Text = "Thông tin " + objDay.ten;
Label_Ten.Text = objDay.ten;
Label_Thuoc.Text = objDay.coso != null ? objDay.coso.ten : "[Cơ sở]";
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Label_MoTa.Text = StringHelper.ConvertRNToBR(objDay.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else if (type.Equals(typeof(Tang).Name))
{
objTang = Tang.getById(id);
if (objTang != null)
{
info.Visible = true;
Label_ThongTin.Text = "Thông tin " + objTang.ten;
Label_Ten.Text = objTang.ten;
if (objTang.day != null)
{
if (objTang.day.coso != null)
{
Label_Thuoc.Text = objTang.day.coso.ten + " - " + objTang.day.ten;
}
else
{
Label_Thuoc.Text = "[Cơ sở] - " + objTang.day.ten;
}
}
else
{
Label_Thuoc.Text = "[Cơ sở] - [Dãy]";
}
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Label_MoTa.Text = StringHelper.ConvertRNToBR(objTang.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
DevExpress.Web.ASPxTreeList.TreeListNode node = ucTreeViTri.ASPxTreeList_ViTri.FindNodeByKeyValue("");
node.Focus();
}
}
else
{
thongbaoloi.Visible = true;
ucDanger.LabelInfo.Text = "Chưa có vị trí";
}
}
public void LoadData()
{
listViTriHienThi = ViTriHienThi.getAll();
if (listViTriHienThi.Count > 0)
{
_ucTreeViTri.CreateTreeList();
_ucTreeViTri.ASPxTreeList_ViTri.DataSource = listViTriHienThi;
_ucTreeViTri.ASPxTreeList_ViTri.DataBind();
SearchFunction();
if (Request.QueryString["key"] != null)
{
string key = "";
try
{
key = Request.QueryString["key"].ToString();
}
catch
{
Response.Redirect(Request.Url.AbsolutePath);
}
DevExpress.Web.ASPxTreeList.TreeListNode node = _ucTreeViTri.ASPxTreeList_ViTri.FindNodeByKeyValue(key);
if (node != null)
{
Guid id = GUID.From(node.GetValue("id"));
string type = node.GetValue("loai").ToString();
if (type.Equals(typeof(CoSo).Name))
{
objCoSo = CoSo.getById(id);
if (objCoSo != null)
{
Panel_ThongTinObj.Visible = true;
Label_ThongTin.Text = "Thông tin " + objCoSo.ten;
Libraries.ImageHelper.LoadImageWeb(objCoSo.hinhanhs.ToList(), _ucASPxImageSlider_Mobile.ASPxImageSlider_Object);
Label_Ten.Text = objCoSo.ten;
ucViTri_BreadCrumb.Label_TenViTri.Text = Label_Ten.Text = objCoSo.ten;
Label_Thuoc.Text = "[Đại học Sài Gòn]";
Panel_DiaChi.Visible = true;
Label_DiaChi.Text = objCoSo.diachi;
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objCoSo.mota);
if (objCoSo.diachi != null)
{
if (objCoSo.diachi.Length > 0)
{
Button_Map.Visible = true;
}
else
Button_Map.Visible = false;
}
else
Button_Map.Visible = false;
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else if (type.Equals(typeof(Dayy).Name))
{
objDay = Dayy.getById(id);
if (objDay != null)
{
Panel_ThongTinObj.Visible = true;
Label_ThongTin.Text = "Thông tin " + objDay.ten;
Libraries.ImageHelper.LoadImageWeb(objDay.hinhanhs.ToList(), _ucASPxImageSlider_Mobile.ASPxImageSlider_Object);
Label_Ten.Text = objDay.ten;
Label_Thuoc.Text = objDay.coso != null ? objDay.coso.ten : "[Cơ sở]";
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Panel_DiaChi.Visible = false;
Label_DiaChi.Text = "";
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objDay.mota);
Button_Map.Visible = false;
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else if (type.Equals(typeof(Tang).Name))
{
objTang = Tang.getById(id);
if (objTang != null)
{
Panel_ThongTinObj.Visible = true;
Label_ThongTin.Text = "Thông tin " + objTang.ten;
Libraries.ImageHelper.LoadImageWeb(objTang.hinhanhs.ToList(), _ucASPxImageSlider_Mobile.ASPxImageSlider_Object);
Label_Ten.Text = objTang.ten;
if (objTang.day != null)
{
if (objTang.day.coso != null)
{
Label_Thuoc.Text = objTang.day.coso.ten + " - " + objTang.day.ten;
}
else
{
Label_Thuoc.Text = "[Cơ sở] - " + objTang.day.ten;
}
}
else
{
Label_Thuoc.Text = "[Cơ sở] - [Dãy]";
}
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Panel_DiaChi.Visible = false;
Label_DiaChi.Text = "";
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objTang.mota);
Button_Map.Visible = false;
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
Panel_TreeViTri.Visible = true;
}
}
else
{
ucThongBaoLoi.Panel_ThongBaoLoi.Visible = true;
ucThongBaoLoi.Label_ThongBaoLoi.Text = "Chưa có vị trí";
}
}
public static double Calculate(List <string> input)
{
Stack <double> numbers = new Stack <double>();
double value = 0.0;
for (int i = 0; i < input.Count; i++)
{
if (input[i][0] >= '0' && input[i][0] <= '9')
{
numbers.Push(double.Parse(input[i]));
}
else if (OperationsCollection.Arithmetics.Contains(input[i]))
{
IArithmeticOperator arithmeticOperator = null;
value = numbers.Pop();
double secValue = numbers.Pop();
double result = 0.0;
switch (input[i])
{
case "+":
arithmeticOperator = new Plus();
result = arithmeticOperator.Calculate(secValue, value);
break;
case "-":
arithmeticOperator = new Minus();
result = (arithmeticOperator.Calculate(secValue, value));
break;
case "*":
arithmeticOperator = new Multiplication();
result = arithmeticOperator.Calculate(secValue, value);
break;
case "/":
arithmeticOperator = new Division();
result = arithmeticOperator.Calculate(secValue, value);
break;
case "%":
arithmeticOperator = new Remainder();
result = arithmeticOperator.Calculate(secValue, value);
break;
case "^":
arithmeticOperator = new Pow();
result = arithmeticOperator.Calculate(secValue, value);
break;;
}
numbers.Push(result);
}
else if (OperationsCollection.Functions.Contains(input[i]))
{
IFunctionOperator functionOperator = null;
value = numbers.Pop();
switch (input[i])
{
case "sin":
functionOperator = new Sin();
break;
case "cos":
functionOperator = new Cos();
break;
case "tang":
functionOperator = new Tang();
break;
case "cotang":
functionOperator = new CoTang();
break;
case "sqrt":
functionOperator = new Sqrt();
break;
case "ln":
numbers.Push(Math.Log(value));
break;
case "log":
numbers.Push(Math.Log10(value));
break;
}
if (functionOperator != null)
{
double result = functionOperator.Calculate(value);
numbers.Push(result);
}
}
}
return(numbers.Pop());
}
private void setDataView()
{
try
{
dxErrorProvider1.ClearErrors();
if (listViTriHienThi.Count > 0)
{
if (treeListViTri.FocusedNode != null && treeListViTri.FocusedNode.GetValue(colloai) != null && !GUID.From(treeListViTri.FocusedNode.GetValue(colid)).Equals(Guid.Empty))
{
if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(CoSo).Name))
{
editGUI("view", typeof(CoSo).Name);
objCoSo = CoSo.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objCoSo.ten;
txtDiaChi.Text = objCoSo.diachi;
txtMoTa.Text = objCoSo.mota;
node = typeof(CoSo).Name;
listHinh = objCoSo.hinhanhs.ToList();
reloadImage();
editGUI2("view", typeof(CoSo).Name);
}
else if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(Dayy).Name))
{
editGUI("view", typeof(Dayy).Name);
objDay = Dayy.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objDay.ten;
txtMoTa.Text = objDay.mota;
node = typeof(Dayy).Name;
listHinh = objDay.hinhanhs.ToList();
ViTri objViTri = new ViTri();
objViTri.coso = objDay.coso;
_ucComboBoxViTri.ViTri = objViTri;
reloadImage();
editGUI2("view", typeof(Dayy).Name);
}
else if (treeListViTri.FocusedNode.GetValue(colloai).ToString().Equals(typeof(Tang).Name))
{
editGUI("view", typeof(Tang).Name);
objTang = Tang.getById(GUID.From(treeListViTri.FocusedNode.GetValue(colid)));
txtTen.Text = objTang.ten;
txtMoTa.Text = objTang.mota;
node = typeof(Tang).Name;
listHinh = objTang.hinhanhs.ToList();
ViTri objViTri = new ViTri();
objViTri.coso = objTang.day.coso;
objViTri.day = objTang.day;
_ucComboBoxViTriChonDay.ViTri = objViTri;
reloadImage();
editGUI2("view", typeof(Tang).Name);
}
}
else
{
editGUI("nothing","");
editGUI2("nothing", "");
}
}
else
{
editGUI("nothing", "");
editGUI2("nothing", "");
}
}
catch (Exception ex)
{
Debug.WriteLine(this.Name + "->setDataView: " + ex.Message);
}
}
private void LoadDataObj(Guid id, int type)
{
switch (type)
{
case 1:
objCoSo = CoSo.getById(id);
if (objCoSo != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objCoSo.ten);
Libraries.ImageHelper.LoadImageWeb(objCoSo.hinhanhs.ToList(), _ucASPxImageSlider_Web.ASPxImageSlider_Object);
_ucASPxImageSlider_Web.urlHinhAnh = string.Format("http://{0}/HinhAnh.aspx?id={1}&type=COSO", HttpContext.Current.Request.Url.Authority, objCoSo.id);
ucViTri_BreadCrumb.Label_TenViTri.Text = Label_Ten.Text = objCoSo.ten;
Label_Thuoc.Text = "[Đại học Sài Gòn]";
Panel_DiaChi.Visible = true;
Label_DiaChi.Text = objCoSo.diachi;
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objCoSo.mota);
if (objCoSo.diachi != null)
{
if (objCoSo.diachi.Length > 0)
{
strSrc = @"https://www.google.com/maps/embed/v1/place?key=AIzaSyB2ryXlc0dNmczXS7O6E5htyRpkR4zvmVo&q=" + objCoSo.diachi;
popup.HeaderText = string.Format("Bản đồ {0}", objCoSo.ten);
LinkButtonBanDo.Text = popup.HeaderText;
LinkButtonBanDo.OnClientClick = string.Format("_ShowMaps('{0}'); return false;", strSrc);
}
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
case 2:
objDay = Dayy.getById(id);
if (objDay != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objDay.ten);
Libraries.ImageHelper.LoadImageWeb(objDay.hinhanhs.ToList(), _ucASPxImageSlider_Web.ASPxImageSlider_Object);
_ucASPxImageSlider_Web.urlHinhAnh = string.Format("http://{0}/HinhAnh.aspx?id={1}&type=DAY", HttpContext.Current.Request.Url.Authority, objDay.id);
Label_Ten.Text = objDay.ten;
Label_Thuoc.Text = objDay.coso != null ? objDay.coso.ten : "[Cơ sở]";
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Panel_DiaChi.Visible = false;
Label_DiaChi.Text = "";
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objDay.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
case 3:
objTang = Tang.getById(id);
if (objTang != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objTang.ten);
Libraries.ImageHelper.LoadImageWeb(objTang.hinhanhs.ToList(), _ucASPxImageSlider_Web.ASPxImageSlider_Object);
_ucASPxImageSlider_Web.urlHinhAnh = string.Format("http://{0}/HinhAnh.aspx?id={1}&type=TANG", HttpContext.Current.Request.Url.Authority, objTang.id);
Label_Ten.Text = objTang.ten;
if (objTang.day != null)
{
if (objTang.day.coso != null)
{
Label_Thuoc.Text = objTang.day.coso.ten + " - " + objTang.day.ten;
}
else
{
Label_Thuoc.Text = "[Cơ sở] - " + objTang.day.ten;
}
}
else
{
Label_Thuoc.Text = "[Cơ sở] - [Dãy]";
}
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Panel_DiaChi.Visible = false;
Label_DiaChi.Text = "";
Label_MoTa.Text = Libraries.StringHelper.ConvertRNToBR(objTang.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
default:
Response.Redirect(Request.Url.AbsolutePath);
return;
}
}
public void LoadData()
{
listViTriHienThi = ViTriHienThi.getAll();
if (listViTriHienThi.Count > 0)
{
ucTreeViTri.CreateTreeList();
ucTreeViTri.ASPxTreeList_ViTri.DataSource = listViTriHienThi;
ucTreeViTri.ASPxTreeList_ViTri.DataBind();
SearchFunction();
treevitri.Visible = true;
if (Request.QueryString["key"] != null)
{
string key = "";
try
{
key = Request.QueryString["key"].ToString();
}
catch
{
Response.Redirect(Request.Url.AbsolutePath);
}
DevExpress.Web.ASPxTreeList.TreeListNode node = ucTreeViTri.ASPxTreeList_ViTri.FindNodeByKeyValue(key);
if (node != null)
{
node.Focus();
ucTreeViTri.FocusAndExpandToNode(node);
Guid id = GUID.From(node.GetValue("id"));
string type = node.GetValue("loai").ToString();
if (type.Equals(typeof(CoSo).Name))
{
objCoSo = CoSo.getById(id);
if (objCoSo != null)
{
info.Visible = true;
Label_ThongTin.Text = "Thông tin " + objCoSo.ten;
Label_Ten.Text = objCoSo.ten;
ucViTri_BreadCrumb.Label_TenViTri.Text = Label_Ten.Text = objCoSo.ten;
Label_Thuoc.Text = "[Đại học Sài Gòn]";
Label_MoTa.Text = StringHelper.ConvertRNToBR(objCoSo.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else if (type.Equals(typeof(Dayy).Name))
{
objDay = Dayy.getById(id);
if (objDay != null)
{
info.Visible = true;
Label_ThongTin.Text = "Thông tin " + objDay.ten;
Label_Ten.Text = objDay.ten;
Label_Thuoc.Text = objDay.coso != null ? objDay.coso.ten : "[Cơ sở]";
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Label_MoTa.Text = StringHelper.ConvertRNToBR(objDay.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else if (type.Equals(typeof(Tang).Name))
{
objTang = Tang.getById(id);
if (objTang != null)
{
info.Visible = true;
Label_ThongTin.Text = "Thông tin " + objTang.ten;
Label_Ten.Text = objTang.ten;
if (objTang.day != null)
{
if (objTang.day.coso != null)
{
Label_Thuoc.Text = objTang.day.coso.ten + " - " + objTang.day.ten;
}
else
{
Label_Thuoc.Text = "[Cơ sở] - " + objTang.day.ten;
}
}
else
{
Label_Thuoc.Text = "[Cơ sở] - [Dãy]";
}
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Label_MoTa.Text = StringHelper.ConvertRNToBR(objTang.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
}
else
{
DevExpress.Web.ASPxTreeList.TreeListNode node = ucTreeViTri.ASPxTreeList_ViTri.FindNodeByKeyValue("");
node.Focus();
}
}
else
{
thongbaoloi.Visible = true;
ucDanger.LabelInfo.Text = "Chưa có vị trí";
}
}
private void LoadDataObj(Guid id, int type)
{
switch (type)
{
case 1:
objCoSo = CoSo.getById(id);
if (objCoSo != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objCoSo.ten);
ucViTri_BreadCrumb.Label_TenViTri.Text = Label_Ten.Text = objCoSo.ten;
Label_Thuoc.Text = "[Đại học Sài Gòn]";
Label_MoTa.Text = StringHelper.ConvertRNToBR(objCoSo.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
case 2:
objDay = Dayy.getById(id);
if (objDay != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objDay.ten);
Label_Ten.Text = objDay.ten;
Label_Thuoc.Text = objDay.coso != null ? objDay.coso.ten : "[Cơ sở]";
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Label_MoTa.Text = StringHelper.ConvertRNToBR(objDay.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
case 3:
objTang = Tang.getById(id);
if (objTang != null)
{
Label_ThongTin.Text = string.Format("Thông tin {0}", objTang.ten);
Label_Ten.Text = objTang.ten;
if (objTang.day != null)
{
if (objTang.day.coso != null)
{
Label_Thuoc.Text = objTang.day.coso.ten + " - " + objTang.day.ten;
}
else
{
Label_Thuoc.Text = "[Cơ sở] - " + objTang.day.ten;
}
}
else
{
Label_Thuoc.Text = "[Cơ sở] - [Dãy]";
}
ucViTri_BreadCrumb.Label_TenViTri.Text = string.Format("{0} ({1})", Label_Ten.Text, Label_Thuoc.Text);
Label_MoTa.Text = StringHelper.ConvertRNToBR(objTang.mota);
}
else
{
Response.Redirect(Request.Url.AbsolutePath);
}
break;
default:
Response.Redirect(Request.Url.AbsolutePath);
return;
}
}
