/// <summary>
///
/// </summary>
/// <param name="AnalysisID"> </param>
/// <returns></returns>
public static Entity.Monitor GetMonitorByID(int MonitorID)
{
Entity.Monitor entity = null;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from [vMonitor] where MonitorID='" + MonitorID + "'", null);
while (dataReader.Read())
{
entity = new Entity.Monitor();
entity.MonitorID = DataHelper.ParseToInt(dataReader["MonitorID"].ToString());
entity.PositionName = dataReader["PositionName"].ToString();
entity.DateTime = DataHelper.ParseToDate(dataReader["DateTime"].ToString());
entity.AnalysisManID = DataHelper.ParseToInt(dataReader["AnalysisManID"].ToString());
entity.RealName = dataReader["RealName"].ToString();
entity.Status = DataHelper.ParseToInt(dataReader["Status"].ToString());
//entity.CreateDate = DataHelper.ParseToDate(dataReader["CreateDate"].ToString());
//entity.CreateUser = dataReader["CreateUser"].ToString();
//entity.UpdateDate = DataHelper.ParseToDate(dataReader["UpdateDate"].ToString());
//entity.UpdateUser = dataReader["UpdateUser"].ToString();
}
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(entity);
}
public static int PassMonitor(Entity.Monitor entity)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
//IDbDataParameter[] prams = {
// dbFactory.MakeInParam("@AnalysisID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AnalysisID.GetType().ToString()),entity.AnalysisID,32),
// dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()),entity.Status,32)
//};
//iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Analysis_UpdateStatus", prams);
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [Monitor] set Status='"+ entity.Status + "',UpdateDate='" + entity.UpdateDate + "',UpdateUser='******'where MonitorID='" + entity.MonitorID + "'", null);
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
public static int UpdateMonitor(Entity.Monitor entity)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@MonitorID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MonitorID.GetType().ToString()), entity.MonitorID, 32),
dbFactory.MakeInParam("@PositionID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PositionID.GetType().ToString()), entity.PositionID, 32),
dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()), entity.DateTime, 0),
dbFactory.MakeInParam("@AnalysisManID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AnalysisManID.GetType().ToString()), entity.AnalysisManID, 32),
dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32),
dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0),
dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50)
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Monitor_Update", prams);
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
protected void btn_Pass_Click(object sender, EventArgs e)
{
int selectedCount = Grid1.SelectedRowIndexArray.Length;
if (selectedCount == 0)
{
Alert.ShowInTop("请至少选择一项纪录！", MessageBoxIcon.Warning);
return;
}
object[] keys = Grid1.DataKeys[Grid1.SelectedRowIndex];
int MonitorID = int.Parse(HttpUtility.UrlEncode(keys[0].ToString()));
Entity.Monitor entity = DAL.Monitor.GetMonitorByID(MonitorID);
if (entity.Status == 2)
{
Alert.ShowInTop("该记录已经审核通过了！", MessageBoxIcon.Warning);
return;
}
entity.Status = 2;
entity.UpdateDate = DateTime.Now;
entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString();
int BSuccess = DAL.Monitor.PassMonitor(entity);
if (BSuccess == 1)
{
Alert.ShowInTop(" 操作成功！", MessageBoxIcon.Information);
BindGrid();
}
else
{
Alert.ShowInTop(" 操作失败！", MessageBoxIcon.Warning);
}
}
/// <summary>
/// [ISingleGridPage]删除表格数据
/// </summary>
public void DeleteSelectedRows()
{
int selectedCount = Grid1.SelectedRowIndexArray.Length;
if (selectedCount == 0)
{
Alert.ShowInTop("请至少选择一项纪录！", MessageBoxIcon.Warning);
return;
}
object[] keys = Grid1.DataKeys[Grid1.SelectedRowIndex];
Entity.Monitor entity = DAL.Monitor.GetMonitorByID(int.Parse(HttpUtility.UrlEncode(keys[0].ToString())));
if (entity.Status == 2)
{
Alert.ShowInTop("审核通过的不能删除！", MessageBoxIcon.Information);
return;
}
else
{
int BSuccess = DAL.Monitor.DeleteMonitor(int.Parse(HttpUtility.UrlEncode(keys[0].ToString())));
if (BSuccess == 1)
{
Alert.ShowInTop(" 操作成功！", MessageBoxIcon.Information);
BindGrid();
}
else
{
Alert.ShowInTop(" 操作失败！", MessageBoxIcon.Warning);
}
}
}
public static int AddMonitorEntity(Entity.Monitor entity, List <Entity.MonitorResult> results)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@PositionID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PositionID.GetType().ToString()), entity.PositionID, 32),
dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()), entity.DateTime, 0),
dbFactory.MakeInParam("@AnalysisManID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AnalysisManID.GetType().ToString()), entity.AnalysisManID, 32),
dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32),
dbFactory.MakeInParam("@CreateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateDate.GetType().ToString()), entity.CreateDate, 0),
dbFactory.MakeInParam("@CreateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.CreateUser.GetType().ToString()), entity.CreateUser, 50),
dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0),
dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50),
dbFactory.MakeOutReturnParam()
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Monitor_Add", prams);
iReturn = int.Parse(prams[8].Value.ToString());
int MonitorID = int.Parse(prams[8].Value.ToString());
foreach (Entity.MonitorResult result in results)
{
IDbDataParameter[] pramse =
{
dbFactory.MakeInParam("@MonitorID", DBTypeConverter.ConvertCsTypeToOriginDBType(MonitorID.GetType().ToString()), MonitorID, 32),
dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(result.ItemCode.GetType().ToString()), result.ItemCode, 20),
dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(result.Result.GetType().ToString()), result.Result, 10)
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_MonitorResult_Add", pramse);
}
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
private void LoadData(string thisGuid)
{
if (thisGuid != string.Empty)
{
//BindGrid();
Entity.Monitor entity = DAL.Monitor.GetMonitorByID(int.Parse(sGuid));
drop_PositionName.SelectedValue = entity.PositionID.ToString();
txt_Analysis.Text = entity.RealName;
hf_AnalysisID.Text = entity.AnalysisManID.ToString();
if (!string.IsNullOrEmpty(entity.DateTime.ToString()))
{
Date.SelectedDate = entity.DateTime;
}
//BindGrid();
if (entity.Status == 2)
{
drop_PositionName.Readonly = true;
txt_Analysis.Readonly = true;
Date.Readonly = true;
Grid1.Enabled = false;
btn_save.Enabled = false;
}
}
}
public static int UpdateMonitorEntity(Entity.Monitor entity, List <Entity.MonitorResult> Adds, List <Entity.MonitorResult> Deletes, List <Entity.MonitorResult> Updates)
{
int iReturn = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(DAL.Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
IDbDataParameter[] prams =
{
dbFactory.MakeInParam("@MonitorID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MonitorID.GetType().ToString()), entity.MonitorID, 32),
dbFactory.MakeInParam("@PositionID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.PositionID.GetType().ToString()), entity.PositionID, 32),
dbFactory.MakeInParam("@DateTime", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.DateTime.GetType().ToString()), entity.DateTime, 0),
dbFactory.MakeInParam("@AnalysisManID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.AnalysisManID.GetType().ToString()), entity.AnalysisManID, 32),
dbFactory.MakeInParam("@Status", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.Status.GetType().ToString()), entity.Status, 32),
dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateDate.GetType().ToString()), entity.UpdateDate, 0),
dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.UpdateUser.GetType().ToString()), entity.UpdateUser, 50)
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_Monitor_Update", prams);
foreach (Entity.MonitorResult add in Adds)
{
IDbDataParameter[] pramse =
{
dbFactory.MakeInParam("@MonitorID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MonitorID.GetType().ToString()), entity.MonitorID, 32),
dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(add.ItemCode.GetType().ToString()), add.ItemCode, 20),
dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(add.Result.GetType().ToString()), add.Result, 10)
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_MonitorResult_Add", pramse);
}
foreach (Entity.MonitorResult update in Updates)
{
IDbDataParameter[] pramsq =
{
dbFactory.MakeInParam("@ResultID", DBTypeConverter.ConvertCsTypeToOriginDBType(update.ResultID.GetType().ToString()), update.ResultID, 32),
dbFactory.MakeInParam("@MonitorID", DBTypeConverter.ConvertCsTypeToOriginDBType(entity.MonitorID.GetType().ToString()), entity.MonitorID, 32),
dbFactory.MakeInParam("@ItemCode", DBTypeConverter.ConvertCsTypeToOriginDBType(update.ItemCode.GetType().ToString()), update.ItemCode, 20),
dbFactory.MakeInParam("@Result", DBTypeConverter.ConvertCsTypeToOriginDBType(update.Result.GetType().ToString()), update.Result, 10)
};
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_MonitorResult_Update", pramsq);
}
foreach (Entity.MonitorResult delete in Deletes)
{
//IDbDataParameter[] pramsw = {
//dbFactory.MakeInParam("@ResultID", DBTypeConverter.ConvertCsTypeToOriginDBType(delete.ResultID.GetType().ToString()),delete.ResultID,32)
//};
//iReturn = db.ExecuteNonQueryTrans(trans, CommandType.StoredProcedure, "proc_AnalysisResult_Delete", pramsw);
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Delete from [MonitorResult] where ResultID='" + delete.ResultID + "'", null);
}
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
protected void btn_save_Click(object sender, EventArgs e)
{
string msg = checkInput();
if (msg != "")
{
Alert.Show(msg);
return;
}
else
{
int iReturn = 0;
try
{
Entity.Monitor entity = new Entity.Monitor();
entity.PositionID = int.Parse(drop_PositionName.SelectedValue);
entity.CreateDate = DateTime.Now;
entity.UpdateDate = DateTime.Now;
entity.CreateUser = Request.Cookies["Cookies"].Values["UserName"].ToString();
entity.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString();
entity.DateTime = Date.SelectedDate;
entity.AnalysisManID = int.Parse(hf_AnalysisID.Text.Trim());
entity.Status = 1;
if (string.IsNullOrEmpty(sGuid))
{
//Add
//List<Entity.MonitorResult> results = new List<Entity.MonitorResult>();
//foreach (GridRow gr in Grid1.Rows)
//{
// Entity.MonitorResult result = new Entity.MonitorResult();
// result.ItemCode = DAL.MonitorItem.GetItemCodeByName(gr.DataKeys[2].ToString());
// result.Result = decimal.Parse(gr.DataKeys[3].ToString());
// results.Add(result);
//}
List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList();
List <Entity.MonitorResult> Adds = new List <Entity.MonitorResult>();
for (int i = 0; i < newAddedList.Count; i++)
{
Entity.MonitorResult add = new Entity.MonitorResult();
add.Result = decimal.Parse(newAddedList[i]["Result"].ToString());
add.ItemCode = DAL.MonitorItem.GetItemCodeByName(newAddedList[i]["ItemName"].ToString());
Adds.Add(add);
}
iReturn = DAL.Monitor.AddMonitorEntity(entity, Adds);
//iReturn = DAL.Monitor.AddMonitorEntity(entity, results);
}
else
{
//Update
entity.MonitorID = int.Parse(sGuid);
List <int> deletedRows = Grid1.GetDeletedList();
List <Entity.MonitorResult> Deletes = new List <Entity.MonitorResult>();
foreach (int rowIndex in deletedRows)
{
Entity.MonitorResult delete = new Entity.MonitorResult();
delete.ResultID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
Deletes.Add(delete);
}
Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict();
List <Entity.MonitorResult> Updates = new List <Entity.MonitorResult>();
foreach (int rowIndex in modifiedDict.Keys)
{
Entity.MonitorResult update = new Entity.MonitorResult();
update.ResultID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]);
update.ItemCode = DAL.MonitorItem.GetItemCodeByName(Grid1.DataKeys[rowIndex][1].ToString());
update.Result = decimal.Parse(Grid1.DataKeys[rowIndex][2].ToString());
Updates.Add(update);
}
List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList();
List <Entity.MonitorResult> Adds = new List <Entity.MonitorResult>();
for (int i = 0; i < newAddedList.Count; i++)
{
Entity.MonitorResult add = new Entity.MonitorResult();
add.Result = decimal.Parse(newAddedList[i]["Result"].ToString());
add.ItemCode = DAL.MonitorItem.GetItemCodeByName(newAddedList[i]["ItemName"].ToString());
Adds.Add(add);
}
iReturn = DAL.Monitor.UpdateMonitorEntity(entity, Adds, Deletes, Updates);
}
}
catch (Exception ex)
{
}
finally
{
}
if (iReturn == 1)
{
Alert.ShowInTop(" 保存成功！", MessageBoxIcon.Information);
// PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
else
{
Alert.ShowInTop(" 保存失败！", MessageBoxIcon.Warning);
}
}
#endregion
}