protected void GCGrid_RowCommand(object sender, FineUIPro.GridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
object[] key = GCGrid.DataKeys[e.RowIndex];
SqlParameter para = new SqlParameter("@id", key[0].ToString());
if (SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(DB_JOB), CommandType.Text, "delete from web_usr where u_id =@id", para) > 0)
{
Alert.Show(MessageHelper.DELETE_SUCCESS);
BindGrid(GCGrid.PageIndex);
}
else
{
Alert.Show(MessageHelper.DELETE_FAIL, MessageBoxIcon.Error);
}
}
if (e.CommandName == "Up")
{
object[] key = GCGrid.DataKeys[e.RowIndex];
SqlParameter para = new SqlParameter("@id", key[0].ToString());
if (SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(DB_JOB), CommandType.Text, "update web_usr set u_type=1 where u_id =@id", para) > 0)
{
Alert.Show("提升成功");
BindGrid(GCGrid.PageIndex);
}
else
{
Alert.Show("提升失败", MessageBoxIcon.Error);
}
}
}
protected void GridList_RowCommand(object sender, FineUIPro.GridCommandEventArgs e)
{
if (e.CommandName == "EXEC")
{
string menuId = GridList.DataKeys[e.RowIndex][0].ToString();
DbHelperOra.ExecuteSql("update DAT_INFDATA_LOG set flag='Y' where seqno='" + menuId + "' ");
DataSearch();
}
}
protected void gridPic_RowCommand(object sender, FineUIPro.GridCommandEventArgs e)
{
//string gdseq = gridPic.Rows[ComRow()].Values[1].ToString();
//string rowno = gridPic.Rows[ComRow()].Values[2].ToString();
string gdseq = gridPic.Rows[e.RowIndex].DataKeys[0].ToString();
string rowno = gridPic.Rows[e.RowIndex].DataKeys[1].ToString();
if (e.CommandName == "shanchu")
{
int count = DbHelperOra.ExecuteSql(string.Format("delete from doc_goodspicture where gdseq = '{0}' and rowno = '{1}'", gdseq, rowno));
if (count > 0)
{
Alert.Show("删除成功！");
picSearch(gdseq);
DataTable dtt = DbHelperOra.Query(string.Format("select gdseq,rowno,decode(flag,'N','新增','Y','已发布','E','已取消') flag,gdpict,picpath from doc_goodspicture where gdseq='{0}'", hfdGDID.Text)).Tables[0];
if (dtt.Rows.Count == 0)
{
imgBMPPATH.ImageUrl = "~/res/images/model.png";
DbHelperOra.ExecuteSql(string.Format("update doc_goods set isflag4='N' where gdseq='{0}'", gdseq));
}
}
else
{
Alert.Show("删除失败！");
}
}
else if (e.CommandName == "lbfsava")
{
List <CommandInfo> lci = new List <CommandInfo>();
JArray ja = gridPic.GetModifiedData();
foreach (JToken jt in ja)
{
int selectedX;
JObject joValue = (JObject)jt;
selectedX = joValue.Value <Int16>("index");
JObject jo = JObject.FromObject(joValue.Value <JObject>("values"));
string gdseqq = gridPic.DataKeys[selectedX][0].ToString();
string rownoo = gridPic.DataKeys[selectedX][1].ToString();
string str1 = jo.Value <String>("STR1");
lci.Add(new CommandInfo(string.Format("update doc_goodspicture set STR1='{0}' where gdseq='{1}' and rowno='{2}'", str1, gdseq, rowno), null));
}
DbHelperOra.ExecuteSqlTran(lci);
Alert.Show("修改【图片别名】成功！");
picSearch(gdseq);
}
}
protected void GridGoods_RowCommand(object sender, FineUIPro.GridCommandEventArgs e)
{
string strUserID = GridGoods.Rows[e.RowIndex].Values[0].ToString();
string strUserName = GridGoods.Rows[e.RowIndex].Values[1].ToString();
if (e.CommandName == "Delete")
{
//DbHelperOra.ExecuteSql("UPDATE SYS_OPERUSER SET FLAG='-1' WHERE USERGH='" + strUserID + "'");
dataSearch();
}
else
{
FineUIPro.PageContext.RegisterStartupScript(Window1.GetShowReference("~/AppFrame/UserEdith.aspx?id=" + strUserID, "用户【" + strUserName + "】信息修改"));
Window1.Hidden = false;
}
}
protected void Grid1_RowCommand(object sender, FineUIPro.GridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
string seqno = GridList.DataKeys[e.RowIndex][0].ToString();
if (DbHelperOra.ExecuteSql("UPDATE DAT_DO_LIST SET FLAG = 'Y' WHERE FLAG = 'N' AND SEQNO ='" + seqno + "'") > 0)
{
Alert.Show("清理完成");
return;
}
else
{
Alert.Show("清理失败，请刷新页面或确认是否为显示状态");
return;
}
}
}
protected void Grid1_RowCommand(object sender, FineUIPro.GridCommandEventArgs e)
{
object[] key = Grid1.DataKeys[e.RowIndex];
SqlParameter para = new SqlParameter("@id", key[0].ToString());
if (e.CommandName == "Delete")
{
if (SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(DB_JOB), CommandType.Text, "delete web_news where n_id=@id", para) > 0)
{
Alert.Show(MessageHelper.DELETE_SUCCESS);
BindData(0);
}
else
{
Alert.Show(MessageHelper.DELETE_FAIL, MessageBoxIcon.Error);
}
}
}
protected void Grid1_RowCommand(object sender, FineUIPro.GridCommandEventArgs e)
{
}