/// <summary>
/// 把 DataReader对象转换成 List集合
/// </summary>
protected List <Sundry> ReaderToList(SqlDataReader reader)
{
try
{
List <Sundry> list = new List <Sundry>();
while (reader.Read())
{
Sundry model = new Sundry();
model.ID = reader["ID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["ID"]);
model.TID = reader["TID"] == DBNull.Value ? 0 : Convert.ToInt32(reader["TID"]);
model.str1 = Convert.ToString(reader["str1"]);
model.str2 = Convert.ToString(reader["str2"]);
model.str3 = Convert.ToString(reader["str3"]);
model.str4 = Convert.ToString(reader["str4"]);
model.str5 = Convert.ToString(reader["str5"]);
list.Add(model);
}
return(list);
}
catch { return(null); }
finally
{
if (reader != null)
{
reader.Close();
}
Connection.Close();
}
}
public ActionResult Edit(Sundry model, int id = -1)
{
int count = id == -1 ? Dal.Insert(model) : Dal.Update(model);
if (count == -1)
{
return(Content("操作失败"));
}
else
{
return(Redirect(@Url.Action("List") + Request.Url.Query));
}
}
private void gcLKD_ColumnEdit_EditValueChanged(object sender, EventArgs e)
{
GridView view = sender as GridView;
var varplan = Sundry.GetRowCellValue(Sundry.FocusedRowHandle, Sundry.Columns["VarPlan"]);
string VARPLAN = Convert.ToString(varplan);
var lockplan = Sundry.GetRowCellValue(Sundry.FocusedRowHandle, Sundry.Columns["LockPlan"]);
string LOCKPLAN = Convert.ToString(lockplan);
if (LOCKPLAN == "0.00")
{
Sundry.SetRowCellValue(Sundry.FocusedRowHandle, Sundry.Columns["LockPlan"], VARPLAN);
Sundry.SetRowCellValue(Sundry.FocusedRowHandle, Sundry.Columns["VarPlan"], lockplan);
}
}
/// <summary>
/// 新增，出现异常返回-1
/// </summary>
public int Insert(Sundry model)
{
string sql = "Insert Into Sundry(TID,str1,str2,str3,str4,str5) Values(@TID,@str1,@str2,@str3,@str4,@str5)";
SqlParameter[] param =
{
Parameter("@TID", model.TID),
Parameter("@str1", model.str1),
Parameter("@str2", model.str2),
Parameter("@str3", model.str3),
Parameter("@str4", model.str4),
Parameter("@str5", model.str5),
};
return(ExecuteNonQuery(sql, param));
}
/// <summary>
/// 修改，出现异常返回-1
/// </summary>
public int Update(Sundry model)
{
string sql = "Update Sundry Set TID=@TID,str1=@str1,str2=@str2,str3=@str3,str4=@str4,str5=@str5 Where ID=@ID";
SqlParameter[] param =
{
Parameter("@TID", model.TID),
Parameter("@str1", model.str1),
Parameter("@str2", model.str2),
Parameter("@str3", model.str3),
Parameter("@str4", model.str4),
Parameter("@str5", model.str5),
Parameter("@ID", model.ID)
};
return(ExecuteNonQuery(sql, param));
}
private void rpCopyGrid_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (Convert.ToInt32(activity.EditValue) == 0)
{
Stopping.OptionsSelection.MultiSelect = true;
Stopping.SelectAll();
Stopping.CopyToClipboard();
Stopping.OptionsSelection.MultiSelect = false;
}
if (Convert.ToInt32(activity.EditValue) == 1)
{
Development.OptionsSelection.MultiSelect = true;
Development.SelectAll();
Development.CopyToClipboard();
Development.OptionsSelection.MultiSelect = true;
}
if (Convert.ToInt32(activity.EditValue) == 2)
{
Sundry.OptionsSelection.MultiSelect = true;
Sundry.SelectAll();
Sundry.CopyToClipboard();
Sundry.OptionsSelection.MultiSelect = true;
}
}
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
StringBuilder sb = new StringBuilder();
if (activity.EditValue.ToString() == "0")
{
Stopping.PostEditor();
Stopping.UpdateCurrentRow();
foreach (DataRow r in dt.Rows)
{
string auth;
if (r["Auth"].ToString() != "")
{
if (Convert.ToBoolean(r["Auth"].ToString()) == true)
{
auth = "Y";
}
else
{
auth = "N";
}
}
else
{
auth = "N";
}
if (r.RowState == DataRowState.Modified)
{
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
sb.AppendLine("update PLANMONTH SET Locked='" + r["locked"].ToString() + "',");
sb.AppendLine(" Auth = '" + auth + "'");
sb.AppendLine(" WHERE prodmonth=" + r["prodmonth"].ToString() + " and workplaceid='" + r["workplaceid"].ToString() + "' and Plancode ='LP' and sectionid='" + r["Sectionid"].ToString() + "' ");
_dbMan.SqlStatement = sb.ToString();
_dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
TUserInfo.ActionLog(resWPAS.systemTag, "LOCK PLAN STOPE", UserCurrentInfo.UserID + " : " + r["workplaceid"].ToString() + " LOCKED: " + r["locked"].ToString(), UserCurrentInfo.Connection);
TUserInfo.ActionLog(resWPAS.systemTag, "LOCK PLAN STOPE", UserCurrentInfo.UserID + " : " + r["workplaceid"].ToString() + " AUTH: " + r["Auth"].ToString(), UserCurrentInfo.Connection);
}
}
}
if (activity.EditValue.ToString() == "1")
{
Development.PostEditor();
Development.UpdateCurrentRow();
foreach (DataRow r in dt.Rows)
{
string auth;
if (r["Auth"].ToString() == "" || Convert.ToBoolean(r["Auth"].ToString()) == false)
{
auth = "N";
}
else
{
auth = "Y";
}
bool locked;
var descript = Development.GetRowCellValue(Development.FocusedRowHandle, Development.Columns["description"]);
string DESCRIPT = Convert.ToString(descript);
var LOCKED = Development.GetRowCellValue(Development.FocusedRowHandle, Development.Columns["locked"]);
if (LOCKED == null || LOCKED is DBNull || LOCKED == "")
{
LOCKED = "False";
locked = Convert.ToBoolean(LOCKED);
}
else
{
locked = Convert.ToBoolean(LOCKED);
}
bool Lock;
if (r["locked"].ToString() == "")
{
Lock = false;
}
else
{
Lock = Convert.ToBoolean(r["locked"].ToString());
}
var ab10 = Development.GetRowCellValue(Development.FocusedRowHandle, Development.Columns["Topend"]);
string ab101 = Convert.ToString(ab10);
string workplcid;
string prmonth;
dt.AcceptChanges();
DataRow[] df = dt.Select("description='" + DESCRIPT + "'");
prmonth = df[0]["prodmonth"].ToString();
workplcid = df[0]["workplaceid"].ToString();
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbMan.SqlStatement = "";
//_dbMan.SqlStatement = "update PLANMONTH SET Auth = '" + auth + "', cmkgt = " + r["Lcmkgt"].ToString() + ", Locked=" + Convert.ToInt16(Lock).ToString() + ",metresadvance=" + r["lM"].ToString() + ",ReefAdv=" + r["Lock_On_M"].ToString() + ",WasteAdv=" + r["Lock_Off_M"].ToString() + " WHERE prodmonth=" + prmonth + " and workplaceid='" + r["Workplaceid"].ToString() + "' and Plancode ='LP' and sectionid='" + r["Sectionid"].ToString() + "'";
_dbMan.SqlStatement = "update PLANMONTH SET Auth = '" + auth + "',Locked=" + Convert.ToInt16(Lock).ToString() + " WHERE prodmonth=" + prmonth + " and workplaceid='" + r["Workplaceid"].ToString() + "' and Plancode ='LP' and sectionid='" + r["Sectionid"].ToString() + "'";
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
rpReplanning.Visible = true;
rpPreplanning.Visible = false;
gcLockPlan.Visible = true;
TUserInfo.ActionLog(resWPAS.systemTag, "LOCK PLAN STOPE", UserCurrentInfo.UserID + " : " + r["workplaceid"].ToString() + " LOCKED: " + r["locked"].ToString(), UserCurrentInfo.Connection);
TUserInfo.ActionLog(resWPAS.systemTag, "LOCK PLAN STOPE", UserCurrentInfo.UserID + " : " + r["workplaceid"].ToString() + " AUTH: " + r["Auth"].ToString(), UserCurrentInfo.Connection);
}
gcLockPlan.Visible = false;
rpPreplanning.Visible = true;
rpReplanning.Visible = false;
panelControl1.Visible = false;
//Mineware.Systems.Global.sysNotification.TsysNotification.showNotification("Data Saved", "Development Lock Plan Data was saved successfully", Color.CornflowerBlue);
}
if (activity.EditValue.ToString() == "2")
{
Sundry.PostEditor();
Sundry.UpdateCurrentRow();
foreach (DataRow r in dt.Rows)
{
bool Auth;
if (r["Auth"].ToString() == "")
{
Auth = false;
}
else
{
Auth = Convert.ToBoolean(r["Auth"].ToString());
}
bool Lock;
if (r["Locked"].ToString() == "")
{
Lock = false;
}
else
{
Lock = Convert.ToBoolean(r["Locked"].ToString());
}
if (Convert.ToBoolean(r["hasChanged"].ToString()) == true) // only save data that changed
{
MWDataManager.clsDataAccess _dbMan1 = new MWDataManager.clsDataAccess();
_dbMan1.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan1.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbMan1.SqlStatement = "";
_dbMan1.SqlStatement = "select * from PLANMONTH_SUNDRYMINING WHERE prodmonth=" + r["prodmonth"].ToString() + " and workplaceid='" + r["Workplaceid"].ToString() + "' and Plancode ='LP' and SMID='" + r["SMID"].ToString() + "' and sectionid='" + r["Sectionid"].ToString() + "'";
_dbMan1.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan1.ExecuteInstruction();
DataTable SNDRY = new DataTable();
SNDRY.Clear();
SNDRY = _dbMan1.ResultsDataTable;
if (SNDRY.Rows.Count == 0)
{
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbMan1.SqlStatement = "";
_dbMan.SqlStatement = " insert into PLANMONTH_SUNDRYMINING values(" + r["prodmonth"].ToString() + ",'" + r["SectionID"].ToString() + "','" + r["Workplaceid"].ToString() + "',2,'" + r["SMID"].ToString() + "','LP'," +
" '" + r["OrgunitDay"].ToString() + "', " +
" '" + r["OrgunitNight"].ToString() + "', '" + Convert.ToInt32(r["Units"]) + "','','',0,0.000," + Convert.ToInt16(Lock).ToString() + "," + Convert.ToInt16(Auth).ToString() + ",'') ";
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
rpReplanning.Visible = true;
rpPreplanning.Visible = false;
gcLockPlan.Visible = true;
}
else
{
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbMan.SqlStatement = "";
_dbMan.SqlStatement = "update PLANMONTH_SUNDRYMINING SET Locked= " + Convert.ToInt16(Lock).ToString() + " , Auth= " + Convert.ToInt16(Auth).ToString() + " WHERE prodmonth=" + r["prodmonth"].ToString() + " and workplaceid='" + r["Workplaceid"].ToString() + "' and Plancode ='LP' AND SMID= '" + r["SMID"].ToString() + "' and sectionid='" + r["Sectionid"].ToString() + "'";
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
rpReplanning.Visible = true;
rpPreplanning.Visible = false;
gcLockPlan.Visible = true;
panelControl1.Visible = true;
}
}
}
}
if (activity.EditValue.ToString() == "8")
{
foreach (DataRow r in dt.Rows)
{
if (Convert.ToBoolean(r["hasChanged"].ToString()) == true) // only save data that changed
{
// test if WP was saved
MWDataManager.clsDataAccess _dbMan1 = new MWDataManager.clsDataAccess();
_dbMan1.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan1.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbMan1.SqlStatement = "";
_dbMan1.SqlStatement = "select * from PlanMonth_Oldgold WHERE prodmonth=" + r["prodmonth"].ToString() + " and workplaceid='" + r["workplaceid"].ToString() + "' and Plancode ='LP' AND OGID= '" + r["OGID"].ToString() + "' and sectionid='" + r["Sectionid"].ToString() + "'";
_dbMan1.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan1.ExecuteInstruction();
DataTable oldgold = new DataTable();
oldgold.Clear();
oldgold = _dbMan1.ResultsDataTable;
SweepsVamps.PostEditor();
SweepsVamps.UpdateCurrentRow();
bool Auth;
if (r["Auth"].ToString() == "")
{
Auth = false;
}
else
{
Auth = Convert.ToBoolean(r["Auth"].ToString());
}
bool Lock;
if (r["Locked"].ToString() == "")
{
Lock = false;
}
else
{
Lock = Convert.ToBoolean(r["Locked"].ToString());
}
if (oldgold.Rows.Count == 0) // add
{
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbMan.SqlStatement = "";
_dbMan.SqlStatement = " insert into PLANMONTH_OLDGOLD values(" + r["prodmonth"].ToString() + ",'" + r["SectionID"].ToString() + "','" + r["workplaceid"].ToString() + "',8,'LP','" + r["OGID"].ToString() + "'," +
" '" + Convert.ToInt32(r["Units"]) + "',0,0.00,0,'" + r["OrgunitDay"].ToString() + "','" + r["OrgunitAfterNoon"].ToString() + "', " +
" '" + r["OrgunitNight"].ToString() + "',0," + Convert.ToInt16(Lock).ToString() + "," + Convert.ToInt16(Auth).ToString() + ",'') ";
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
}
else // update
{
MWDataManager.clsDataAccess _dbMan = new MWDataManager.clsDataAccess();
_dbMan.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbMan.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbMan.SqlStatement = "";
_dbMan.SqlStatement = "update PlanMonth_Oldgold SET Locked= " + Convert.ToInt16(Lock).ToString() + " , Auth= " + Convert.ToInt16(Auth).ToString() + " WHERE prodmonth=" + r["prodmonth"].ToString() + " and workplaceid='" + r["workplaceid"].ToString() + "' and Plancode ='LP' AND OGID= '" + r["OGID"].ToString() + "' and sectionid='" + r["Sectionid"].ToString() + "'";
_dbMan.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbMan.ExecuteInstruction();
}
}
}
}
Mineware.Systems.Global.sysNotification.TsysNotification.showNotification("Success", "Data Saved", System.Drawing.Color.CornflowerBlue);
ribbonMenu.Minimized = false;
}
