protected override void grvRef_RowUpdating(object sender, GridViewUpdateEventArgs e) { LoadHeader(); //_sql = "select NAME,custom_control_name from DMIS_SYS_COLUMNS where TABLE_ID=" + Session["MainTableId"].ToString() + " and ISDISPLAY=1 order by ORDER_ID"; //_dt = DBOpt.dbHelper.GetDataTable(_sql); //for (int i = 0; i < _dt.Rows.Count; i++) //{ // grvRef.Rows[e.RowIndex].Cells[i + 1].Controls[0].ID = _dt.Rows[i][1].ToString(); //} string sql; int tableID, tid; tableID = Convert.ToInt16(Session["MainTableId"]); tid = Convert.ToInt16(grvRef.DataKeys[e.RowIndex].Value); GridViewRow row = grvRef.Rows[e.RowIndex]; sql = GridViewEdit.GetGridViewRowUpdating(ref grvRef, tableID, e.RowIndex, tid); sql = "update t_dd_running_log_type set name='测试' where tid=8"; if (DBOpt.dbHelper.ExecuteSql(sql) > 0) { grvRef.EditIndex = -1; GridViewBind(); } else { JScript.Alert((String)GetGlobalResourceObject("WebGlobalResource", "SaveFailMessage")); return; } }
protected void grv_RowUpdating(object sender, GridViewUpdateEventArgs e) { if (sender == null) { return; } GridView grv = (GridView)sender; int tid, tableID; tid = Convert.ToInt16(grv.DataKeys[e.RowIndex].Value); tableID = Convert.ToInt16(Session["MainTableId"]); _sql = GridViewEdit.GetGridViewRowUpdating(ref grv, tableID, e.RowIndex, tid); if (DBOpt.dbHelper.ExecuteSql(_sql) > 0) { grv.EditIndex = -1; GridViewBind(); } else { //JScript.Alert("数据保存失败!"); return; } }
protected void grv_RowUpdating(object sender, GridViewUpdateEventArgs e) { if (sender == null) { return; } GridView grv = (GridView)sender; int tid, tableID; string shiftDate = wdlDate.getTime().ToString("yyyyMMdd"); tid = Convert.ToInt16(grv.DataKeys[e.RowIndex].Value); tableID = Convert.ToInt16(Session["MainTableId"]); WebDate wdl发生时间, wdl结束时间; wdl发生时间 = (WebDate)grv.Rows[e.RowIndex].FindControl("wdl发生时间"); wdl结束时间 = (WebDate)grv.Rows[e.RowIndex].FindControl("wdl结束时间"); TimeSpan ts = DateTime.Now - DateTime.Now; //不让两个相同时间相减,则会出现未赋局部变量的错误。 string updateSql; if (!(wdl结束时间.getTime() == null || wdl结束时间.getTime().ToString("yyyy") == "1900")) { DateTime dt1, dt2; dt1 = wdl发生时间.getTime(); dt2 = wdl结束时间.getTime(); if (dt1 > dt2) { JScript.Alert("发生时间不能大于结束时间!"); return; } ts = dt2 - dt1; } else { updateSql = "update T_ZDH_自动化值班记事 set 小时数=NULL where TID=" + tid; //取消小时数 DBOpt.dbHelper.ExecuteSql(updateSql); } updateSql = GridViewEdit.GetGridViewRowUpdating(ref grv, tableID, e.RowIndex, tid); if (DBOpt.dbHelper.ExecuteSql(updateSql) > 0) { grv.EditIndex = -1; if (ts.TotalHours > 0) //如果有时间再更新时间 { updateSql = "update T_ZDH_自动化值班记事 set 小时数=" + ts.TotalHours.ToString() + " where TID=" + tid; DBOpt.dbHelper.ExecuteSql(updateSql); } GridViewBind(); } else { JScript.Alert("数据保存失败!"); return; } }
protected virtual void grvList_RowUpdating(object sender, GridViewUpdateEventArgs e) { string sql; int tableID, tid; tableID = Convert.ToInt16(Session["MainTableId"]); tid = Convert.ToInt16(grvList.DataKeys[e.RowIndex].Value); sql = GridViewEdit.GetGridViewRowUpdating(ref grvList, tableID, e.RowIndex, tid); if (DBOpt.dbHelper.ExecuteSql(sql) > 0) { grvList.EditIndex = -1; grvList_DataBind(); } else { JScript.Alert((String)GetGlobalResourceObject("WebGlobalResource", "SaveFailMessage")); return; } }