protected void gvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
string sSc = "<script>\n";
sSc += "alert('Đang tồn tại thông tin khác trong bài này!');\n";
sSc += "</script>\n";
switch (e.CommandName)
{
case "del":
string iddel = e.CommandArgument.ToString();
UpdateData.Delete("tbl_Config", "Config_ID=" + iddel);
FunctionDB.AddLog(Session["DepartID"].ToString(), Session["Username"].ToString(), "Xoá", "Bài: " + FunctionDB.GetName("Content", iddel.ToString()));
BindData();
break;
case "isUse":
string id01 = e.CommandArgument.ToString();
DataSet dsU = UpdateData.UpdateBySql("SELECT Config_Status FROM tbl_Config WHERE Config_ID=" + id01);
DataRowCollection rowsU = dsU.Tables[0].Rows;
bool isUse = false;
isUse = Convert.ToBoolean(rowsU[0]["Config_Status"]);
if (isUse)
{
UpdateData.UpdateOrder("UPDATE tbl_Config SET Config_Status=0 WHERE Config_ID=" + id01);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_Config SET Config_Status=1 WHERE Config_ID=" + id01);
}
BindData();
break;
}
}
protected void lbtDelAll_Click(object sender, EventArgs e)
{
foreach (GridViewRow item in gvData.Rows)
{
CheckBox cbItem = (CheckBox)item.FindControl("cbItem");
if (cbItem.Checked)
{
int id = Convert.ToInt32(gvData.DataKeys[item.RowIndex].Value.ToString());
try
{
if (UpdateData.Delete("tbl_ModsiteUser", "User_ID=" + id))
{
if (UpdateData.Delete("tbl_ModUser", "UserID=" + id))
{
UpdateData.Delete("tbl_User", "User_ID=" + id);
}
}
}
catch (Exception)
{
string sSc = "<script>\n";
sSc += "alert('Đang tồn tại các dữ liệu liên quan đến user này!');\n";
sSc += "</script>\n";
Response.Write(sSc);
}
}
}
BindData();
}
protected void gvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
string sSc = "<script>\n";
sSc += "alert('Đang tồn tại module khác bên trong hoặc đã bài viết của module này!');\n";
sSc += "</script>\n";
switch (e.CommandName)
{
case "del":
string iddel = e.CommandArgument.ToString();
string sql = "SELECT * FROM tbl_ModAdmin WHERE ModAdmin_Parent=" + iddel;
DataSet ds = UpdateData.UpdateBySql(sql);
DataRowCollection rows = ds.Tables[0].Rows;
if (rows.Count > 0)
{
Response.Write(sSc);
}
else
{
UpdateData.Delete("tbl_ModAdmin", "ModAdmin_ID=" + iddel);
FunctionDB.AddLog(Session["DepartID"].ToString(), Session["Username"].ToString(), "Xoá", "Module:" + FunctionDB.GetName("Modadmin", iddel));
}
BindData();
break;
case "isUse":
string id01 = e.CommandArgument.ToString();
DataSet dsU = UpdateData.UpdateBySql("SELECT ModAdmin_Status FROM tbl_ModAdmin WHERE ModAdmin_ID=" + id01);
DataRowCollection rowsU = dsU.Tables[0].Rows;
bool isUse = false;
isUse = Convert.ToBoolean(rowsU[0]["ModAdmin_Status"]);
if (isUse)
{
UpdateData.UpdateOrder("UPDATE tbl_ModAdmin SET ModAdmin_Status=0 WHERE ModAdmin_ID=" + id01);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_ModAdmin SET ModAdmin_Status=1 WHERE ModAdmin_ID=" + id01);
}
BindData();
break;
}
if (e.CommandName == "Order01")
{
foreach (GridViewRow item in gvData.Rows)
{
int order = Convert.ToInt32(((TextBox)item.Cells[3].FindControl("txtOrder01")).Text.ToString());
int id = Convert.ToInt32(gvData.DataKeys[item.RowIndex].Value.ToString());
string sql = "UPDATE tbl_ModAdmin SET ModAdmin_Pos=" + order + " WHERE ModAdmin_ID=" + id;
UpdateData.UpdateOrder(sql);
}
BindData();
}
}
protected void lbtDelAll_Click(object sender, EventArgs e)
{
foreach (GridViewRow item in gvData.Rows)
{
CheckBox cbItem = (CheckBox)item.FindControl("cbItem");
if (cbItem.Checked)
{
int id = Convert.ToInt32(gvData.DataKeys[item.RowIndex].Value.ToString());
UpdateData.Delete("tbl_Config", "Config_ID=" + id);
}
}
BindData();
}
protected void lbtUpdate_Click(object sender, EventArgs e)
{
string sScritp = "<script>";
sScritp += "var b = opener.parent.dhxLayout.cells(\"b\");";
sScritp += "b.attachURL(\"BoxList.aspx\");";
sScritp += "window.close();";
sScritp += "</script>";
int selectedNum = 0;
for (int i = 0; i < cblRight.Items.Count; i++)
{
if (cblRight.Items[i].Selected == true)
{
selectedNum++;
}
}
if (id == "11")
{
if (selectedNum == 3)
{
UpdateData.Delete("tbl_ModBox", "Box_ID=" + id);
for (int i = 0; i < cblRight.Items.Count; i++)
{
if (cblRight.Items[i].Selected == true)
{
string ModID = cblRight.Items[i].Value;
UpdateData.InsertBySql("INSERT INTO tbl_ModBox(Mod_ID,Box_ID) VALUES(" + ModID + "," + id + ")");
}
}
Response.Write(sScritp);
}
else
{
Response.Write("<script>alert(\"Bạn phải chọn 3 mục.\")</script>");
}
}
else
{
UpdateData.Delete("tbl_ModBox", "Box_ID=" + id);
for (int i = 0; i < cblRight.Items.Count; i++)
{
if (cblRight.Items[i].Selected == true)
{
string ModID = cblRight.Items[i].Value;
UpdateData.InsertBySql("INSERT INTO tbl_ModBox(Mod_ID,Box_ID) VALUES(" + ModID + "," + id + ")");
}
}
Response.Write(sScritp);
}
}
protected void gvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
string sSc = "<script>\n";
sSc += "alert('Đang tồn tại module khác bên trong hoặc đã bài viết của module này!');\n";
sSc += "</script>\n";
switch (e.CommandName)
{
case "del":
string iddel = e.CommandArgument.ToString();
string sql = "SELECT * FROM tbl_Documents WHERE Doc_ID=" + iddel;
DataSet ds = UpdateData.UpdateBySql(sql);
DataRowCollection rows = ds.Tables[0].Rows;
if (rows.Count > 0)
{
UpdateData.Delete("tbl_Documents", "Doc_ID=" + iddel);
}
BindData();
break;
case "isUse":
string id01 = e.CommandArgument.ToString();
DataSet dsU = UpdateData.UpdateBySql("SELECT Doc_Status FROM tbl_Documents WHERE Doc_ID=" + id01);
DataRowCollection rowsU = dsU.Tables[0].Rows;
bool isUse = false;
isUse = Convert.ToBoolean(rowsU[0]["DOc_Status"]);
if (isUse)
{
UpdateData.UpdateOrder("UPDATE tbl_Documents SET Doc_Status=0 WHERE Doc_ID=" + id01);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_Documents SET Doc_Status=1 WHERE Doc_ID=" + id01);
}
BindData();
break;
}
if (e.CommandName == "Order01")
{
foreach (GridViewRow item in gvData.Rows)
{
int order = Convert.ToInt32(((TextBox)item.Cells[3].FindControl("txtOrder01")).Text.ToString());
int id = Convert.ToInt32(gvData.DataKeys[item.RowIndex].Value.ToString());
string sql = "UPDATE tbl_Documents SET Doc_Pos=" + order + " WHERE Doc_ID=" + id;
UpdateData.UpdateOrder(sql);
}
BindData();
}
}
protected void gvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
string sSc = "<script>\n";
sSc += "alert('Đang tồn tại các dữ liệu liên quan đến user này!');\n";
sSc += "</script>\n";
switch (e.CommandName)
{
case "del":
string id = e.CommandArgument.ToString();
try
{
if (UpdateData.Delete("tbl_User", "User_ID=" + id))
{
BindData();
}
else
{
Response.Write(sSc);
}
}
catch (Exception)
{
Response.Write(sSc);
}
break;
case "isUse":
string id01 = e.CommandArgument.ToString();
DataSet dsU = UpdateData.UpdateBySql("SELECT User_Status FROM tbl_User WHERE User_ID=" + id01);
DataRowCollection rowsU = dsU.Tables[0].Rows;
bool isUse = false;
isUse = Convert.ToBoolean(rowsU[0]["User_Status"]);
if (isUse)
{
UpdateData.UpdateOrder("UPDATE tbl_User SET User_Status=0 WHERE User_ID=" + id01);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_User SET User_Status=1 WHERE User_ID=" + id01);
}
BindData();
break;
}
}
protected void dgrModtype_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.EditItem)
{
string sSc = "<script>\n";
sSc += "alert('Bạn cần gỡ các module sử dụng định dạng này trước khi xoá!');\n";
sSc += "</script>\n";
string id = dgrModtype.DataKeys[e.Item.ItemIndex].ToString();
switch (e.CommandName)
{
case "del":
string sql = "SELECT * FROM tbl_Mod WHERE Modtype_ID=" + id;
DataSet ds = UpdateData.UpdateBySql(sql);
DataRowCollection rows = ds.Tables[0].Rows;
if (rows.Count > 0)
{
Response.Write(sSc);
}
else
{
UpdateData.Delete("tbl_Modtype", "Modtype_ID=" + id);
}
dgrModtype.EditItemIndex = -1;
BindData();
break;
case "isUse":
DataSet dsU = UpdateData.UpdateBySql("SELECT Modtype_Status FROM tbl_Modtype WHERE Modtype_ID=" + id);
DataRowCollection rowsU = dsU.Tables[0].Rows;
bool isHot = false;
isHot = Convert.ToBoolean(rowsU[0]["Modtype_Status"]);
if (isHot)
{
UpdateData.UpdateOrder("UPDATE tbl_Modtype SET Modtype_Status=0 WHERE Modtype_ID=" + id);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_Modtype SET Modtype_Status=1 WHERE Modtype_ID=" + id);
}
dgrModtype.EditItemIndex = -1;
BindData();
break;
}
}
}
protected void gvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
string sSc = "<script>\n";
sSc += "alert('Đang tồn tại thông tin khác trong bài này!');\n";
sSc += "</script>\n";
switch (e.CommandName)
{
case "del":
string iddel = e.CommandArgument.ToString();
UpdateData.Delete("tbl_File", "File_ID=" + iddel);
FunctionDB.AddLog(Session["DepartID"].ToString(), Session["Username"].ToString(), "Xoá", "Bài: " + FunctionDB.GetName("Content", iddel.ToString()));
BindData();
break;
case "isUse":
string id01 = e.CommandArgument.ToString();
DataSet dsU = UpdateData.UpdateBySql("SELECT File_Status FROM tbl_File WHERE File_ID=" + id01);
DataRowCollection rowsU = dsU.Tables[0].Rows;
bool isUse = false;
isUse = Convert.ToBoolean(rowsU[0]["File_Status"]);
if (isUse)
{
UpdateData.UpdateOrder("UPDATE tbl_File SET File_Status=0 WHERE File_ID=" + id01);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_File SET File_Status=1 WHERE File_ID=" + id01);
}
BindData();
break;
}
if (e.CommandName == "Order01")
{
foreach (GridViewRow item in gvData.Rows)
{
int order = Convert.ToInt32(((TextBox)item.Cells[3].FindControl("txtOrder01")).Text.ToString());
int id = Convert.ToInt32(gvData.DataKeys[item.RowIndex].Value.ToString());
string sql = "UPDATE tbl_File SET File_Pos=" + order + " WHERE File_ID=" + id;
UpdateData.UpdateOrder(sql);
}
BindData();
}
}
protected void lbtUpdate_Click(object sender, EventArgs e)
{
string sScritp = "<script>";
sScritp += "var b = opener.parent.dhxLayout.cells(\"b\");";
sScritp += "b.attachURL(\"UserList.aspx\");";
sScritp += "window.close();";
sScritp += "</script>";
UpdateData.Delete("tbl_RoleUser", "User_ID=" + id);
for (int i = 0; i < cblRole.Items.Count; i++)
{
if (cblRole.Items[i].Selected == true)
{
string RoleID = cblRole.Items[i].Value;
UpdateData.InsertBySql("INSERT INTO tbl_RoleUser(Role_ID,User_ID) VALUES(" + RoleID + "," + id + ")");
}
}
Response.Write(sScritp);
}
protected void lbtUpdate_Click(object sender, EventArgs e)
{
string sScritp = "<script>";
sScritp += "var a = opener.parent.dhxLayout.cells(\"a\");";
sScritp += "a.attachURL(\"Tree.aspx\");";
sScritp += "var b = opener.parent.dhxLayout.cells(\"b\");";
sScritp += "b.attachURL(\"FunctionList.aspx?p=" + p + "\");";
sScritp += "window.close();";
sScritp += "</script>";
UpdateData.Delete("tbl_ModUser", "ModAdmin_ID=" + id);
for (int i = 0; i < cblRight.Items.Count; i++)
{
if (cblRight.Items[i].Selected == true)
{
string UserID = cblRight.Items[i].Value;
UpdateData.InsertBySql("INSERT INTO tbl_ModUser(ModAdmin_ID,UserID) VALUES(" + id + "," + UserID + ")");
}
}
Response.Write(sScritp);
}
protected void lbtUpdate_Click(object sender, EventArgs e)
{
string sScript = "<script>";
sScript += "var b = opener.parent.dhxLayout.cells(\"b\");";
sScript += "b.attachURL(\"UserList.aspx?pbid=" + pbid + "\");";
sScript += "window.close();";
sScript += "</script>";
UpdateData.Delete("tbl_ModSiteUser", "User_ID=" + id);
string ModuleID = "";
for (int i = 0; i < TreeView1.CheckedNodes.Count; i++)
{
if (TreeView1.CheckedNodes[i].Checked == true)
{
ModuleID = this.TreeView1.CheckedNodes[i].Value;
UpdateData.InsertBySql("INSERT INTO tbl_ModSiteUser(Mod_ID,User_ID) VALUES(" + ModuleID + "," + id + ")");
}
}
Response.Write(sScript);
}
protected void lbtDelAll_Click(object sender, EventArgs e)
{
foreach (GridViewRow item in gvData.Rows)
{
CheckBox cbItem = (CheckBox)item.FindControl("cbItem");
if (cbItem.Checked)
{
int iddel = Convert.ToInt32(gvData.DataKeys[item.RowIndex].Value.ToString());
try
{
if (AuthenticationMenu.CheckPermission(iddel, int.Parse(Session["UserId"].ToString())))
{
UpdateData.Delete("tbl_ModSiteUser", "User_Id=" + int.Parse(Session["UserID"].ToString()));
}
UpdateData.Delete("tbl_Mod", "Mod_ID=" + iddel);
}
catch (Exception)
{
Response.Write("<script>alert('Module tại trong 1 module khác hoặc được sở hữu bởi 1 người khác, bạn không thể xóa nó');</script>");
}
}
}
BindData();
}
protected void gvRaovat_RowCommand(object sender, GridViewCommandEventArgs e)
{
string sSc = "<script>\n";
sSc += "alert('Đang tồn tại thông tin khác trong bài này!');\n";
sSc += "</script>\n";
switch (e.CommandName)
{
case "del":
string iddel = e.CommandArgument.ToString();
UpdateData.Delete("tbl_Raovat", "Raovat_ID=" + iddel);
BindRaovat();
break;
case "isUse":
string id01 = e.CommandArgument.ToString();
DataSet dsU = UpdateData.UpdateBySql("SELECT Raovat_Status FROM tbl_Raovat WHERE Raovat_ID=" + id01);
DataRowCollection rowsU = dsU.Tables[0].Rows;
bool isUse = false;
isUse = Convert.ToBoolean(rowsU[0]["Raovat_Status"]);
if (isUse)
{
UpdateData.UpdateOrder("UPDATE tbl_Raovat SET Raovat_Status=0 WHERE Raovat_ID=" + id01);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_Raovat SET Raovat_Status=1 WHERE Raovat_ID=" + id01);
}
BindRaovat();
break;
case "isVIP1":
string idV1 = e.CommandArgument.ToString();
DataSet dsV1 = UpdateData.UpdateBySql("SELECT Raovat_VIP1 FROM tbl_Raovat WHERE Raovat_ID=" + idV1);
DataRowCollection rowsV1 = dsV1.Tables[0].Rows;
bool isVIP1 = false;
isVIP1 = Convert.ToBoolean(rowsV1[0]["Raovat_VIP1"]);
if (isVIP1)
{
UpdateData.UpdateOrder("UPDATE tbl_Raovat SET Raovat_VIP1=0 WHERE Raovat_ID=" + idV1);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_Raovat SET Raovat_VIP1=1 WHERE Raovat_ID=" + idV1);
}
BindRaovat();
break;
case "isVIP2":
string idV2 = e.CommandArgument.ToString();
DataSet dsV2 = UpdateData.UpdateBySql("SELECT Raovat_VIP2 FROM tbl_Raovat WHERE Raovat_ID=" + idV2);
DataRowCollection rowsV2 = dsV2.Tables[0].Rows;
bool isVIP2 = false;
isVIP2 = Convert.ToBoolean(rowsV2[0]["Raovat_VIP2"]);
if (isVIP2)
{
UpdateData.UpdateOrder("UPDATE tbl_Raovat SET Raovat_VIP2=0 WHERE Raovat_ID=" + idV2);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_Raovat SET Raovat_VIP2=1 WHERE Raovat_ID=" + idV2);
}
BindRaovat();
break;
}
}
protected void gvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
string sSc = "<script>\n";
sSc += "alert('Đang tồn tại thông tin khác trong bài này!');\n";
sSc += "</script>\n";
switch (e.CommandName)
{
case "del":
string iddel = e.CommandArgument.ToString();
UpdateData.Delete("tbl_Content", "Content_ID=" + iddel);
FunctionDB.AddLog(Session["DepartID"].ToString(), Session["Username"].ToString(), "Xoá", "Bài: " + FunctionDB.GetName("Content", iddel.ToString()));
BindData();
break;
case "isHot":
string id = e.CommandArgument.ToString();
DataSet ds = UpdateData.UpdateBySql("SELECT Content_Hot FROM tbl_Content WHERE Content_ID=" + id);
DataRowCollection rows = ds.Tables[0].Rows;
bool isHot = false;
isHot = Convert.ToBoolean(rows[0]["Content_Hot"]);
if (isHot)
{
UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_Hot=0 WHERE Content_ID=" + id);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_Hot=1 WHERE Content_ID=" + id);
}
BindData();
break;
case "isUse":
string id01 = e.CommandArgument.ToString();
DataSet dsU = UpdateData.UpdateBySql("SELECT Content_Status FROM tbl_Content WHERE Content_ID=" + id01);
DataRowCollection rowsU = dsU.Tables[0].Rows;
bool isUse = false;
isUse = Convert.ToBoolean(rowsU[0]["Content_Status"]);
if (isUse)
{
UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_Status=0 WHERE Content_ID=" + id01);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_Status=1 WHERE Content_ID=" + id01);
}
BindData();
break;
//case "isHome":
// string id02 = e.CommandArgument.ToString();
// DataSet dsHome = UpdateData.UpdateBySql("SELECT Content_Home FROM tbl_Content WHERE Content_ID=" + id02);
// DataRowCollection rowsHome = dsHome.Tables[0].Rows;
// bool isHome = false;
// isHome = Convert.ToBoolean(rowsHome[0]["Content_Home"]);
// if (isHome)
// UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_Home=0 WHERE Content_ID=" + id02);
// else
// UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_Home=1 WHERE Content_ID=" + id02);
// BindData();
// break;
//case "isOK":
// string id03 = e.CommandArgument.ToString();
// DataSet dsOK = UpdateData.UpdateBySql("SELECT Content_OK FROM tbl_Content WHERE Content_ID=" + id03);
// DataRowCollection rowsOK = dsOK.Tables[0].Rows;
// bool isOK = false;
// isOK = Convert.ToBoolean(rowsOK[0]["Content_OK"]);
// if (isOK)
// UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_OK=0 WHERE Content_ID=" + id03);
// else
// UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_OK=1 WHERE Content_ID=" + id03);
// BindData();
// break;
//case "isRSS":
// string id04 = e.CommandArgument.ToString();
// DataSet dsRSS = UpdateData.UpdateBySql("SELECT Content_RSS FROM tbl_Content WHERE Content_ID=" + id04);
// DataRowCollection rowsRSS = dsRSS.Tables[0].Rows;
// bool isRSS = false;
// isRSS = Convert.ToBoolean(rowsRSS[0]["Content_RSS"]);
// if (isRSS)
// UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_RSS=0 WHERE Content_ID=" + id04);
// else
// UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_RSS=1 WHERE Content_ID=" + id04);
// BindData();
// break;
//case "isShare":
// int id05 = Convert.ToInt32(e.CommandArgument);
// DataSet dsShare = UpdateData.UpdateBySql("SELECT Content_Share FROM tbl_Content WHERE Content_ID=" + id05);
// DataRowCollection rowsShare = dsShare.Tables[0].Rows;
// bool isShare = false;
// isShare = Convert.ToBoolean(rowsShare[0]["Content_Share"]);
// if (isShare)
// UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_Share=0 WHERE Content_ID=" + id05);
// else
// UpdateData.UpdateOrder("UPDATE tbl_Content SET Content_Share=1 WHERE Content_ID=" + id05);
// BindData();
// vn.edu.tdcbachmai.ArticleService service = new vn.edu.tdcbachmai.ArticleService();
// string n = ContentControl.GetContentField("Name", id05);
// string intro = ContentControl.GetContentField("Intro", id05);
// string text = ContentControl.GetContentField("Text", id05);
// service.InsertArticle(n, intro, text);
// break;
}
if (e.CommandName == "Order01")
{
foreach (GridViewRow item in gvData.Rows)
{
int order = Convert.ToInt32(((TextBox)item.Cells[3].FindControl("txtOrder01")).Text.ToString());
int id = Convert.ToInt32(gvData.DataKeys[item.RowIndex].Value.ToString());
string sql = "UPDATE tbl_Content SET Content_Pos=" + order + " WHERE Content_ID=" + id;
UpdateData.UpdateOrder(sql);
}
BindData();
}
}
protected void gvData_RowCommand(object sender, GridViewCommandEventArgs e)
{
string sSc = "<script>\n";
sSc += "alert('Đang tồn tại module khác bên trong hoặc đã bài viết của module này!');\n";
sSc += "</script>\n";
switch (e.CommandName)
{
case "del":
if (TopicID != 1342 && ModControl.GetParent(TopicID) != 1342)
{
string iddel = e.CommandArgument.ToString();
string sql = "SELECT * FROM tbl_Mod WHERE Mod_Parent=" + iddel;
string sqlC = "SELECT * FROM tbl_Content WHERE Mod_ID=" + iddel;
DataSet ds = UpdateData.UpdateBySql(sql);
DataRowCollection rows = ds.Tables[0].Rows;
DataSet dsC = UpdateData.UpdateBySql(sqlC);
DataRowCollection rowsC = dsC.Tables[0].Rows;
if ((rows.Count > 0) || (rowsC.Count > 0))
{
Response.Write(sSc);
}
else
{
try
{
UpdateData.Delete("tbl_Mod", "Mod_ID=" + iddel);
}
catch (Exception)
{
Response.Write("<script>alert('Module đang được sở hữu bởi người khác, bạn không được xóa nó.')</script>");
}
FunctionDB.AddLog(Session["DepartID"].ToString(), Session["Username"].ToString(), "Xoá", "Module:" + FunctionDB.GetName("Mod", iddel));
}
BindData();
}
break;
case "isHot":
string id = e.CommandArgument.ToString();
DataSet dsH = UpdateData.UpdateBySql("SELECT Mod_Hot FROM tbl_Mod WHERE Mod_ID=" + id);
DataRowCollection rowsH = dsH.Tables[0].Rows;
bool isHot = false;
isHot = Convert.ToBoolean(rowsH[0]["Mod_Hot"]);
if (isHot)
{
UpdateData.UpdateOrder("UPDATE tbl_Mod SET Mod_Hot=0 WHERE Mod_ID=" + id);
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_Mod SET Mod_Hot=1 WHERE Mod_ID=" + id);
}
BindData();
break;
case "isUse":
string id01 = e.CommandArgument.ToString();
int idcat = 0;
//if (format == 17 || format == 18 || format == 21)
//{
// idcat = ProductControl.GetShopFromMod(int.Parse(id01)).ShopCatID;
//}
DataSet dsU = UpdateData.UpdateBySql("SELECT Mod_Status FROM tbl_Mod WHERE Mod_ID=" + id01);
DataRowCollection rowsU = dsU.Tables[0].Rows;
bool isUse = false;
isUse = Convert.ToBoolean(rowsU[0]["Mod_Status"]);
if (isUse)
{
UpdateData.UpdateOrder("UPDATE tbl_Mod SET Mod_Status=0 WHERE Mod_ID=" + id01);
if (format == 17 || format == 18 || format == 21)
{
UpdateData.UpdateOrder("UPDATE Shop_Category SET isPublish=0 WHERE ID=" + idcat);
}
}
else
{
UpdateData.UpdateOrder("UPDATE tbl_Mod SET Mod_Status=1 WHERE Mod_ID=" + id01);
if (format == 17 || format == 18 || format == 21)
{
UpdateData.UpdateOrder("UPDATE Shop_Category SET isPublish=0 WHERE ID=" + idcat);
}
}
BindData();
break;
}
if (e.CommandName == "Order01")
{
foreach (GridViewRow item in gvData.Rows)
{
int order = Convert.ToInt32(((TextBox)item.Cells[3].FindControl("txtOrder01")).Text.ToString());
int id = Convert.ToInt32(gvData.DataKeys[item.RowIndex].Value.ToString());
string sql = "UPDATE tbl_Mod SET Mod_Pos=" + order + " WHERE Mod_ID=" + id;
UpdateData.UpdateOrder(sql);
}
BindData();
}
}