protected void btnAdd_Click(object sender, EventArgs e) { MBusinessFunctionData model = new MBusinessFunctionData(); MBusinessFunctionBB businessFunctionBB = new MBusinessFunctionBB(); try { if (this.State == "1") { this.SetModel(ref model); businessFunctionBB.AddRecord(model); } else if (this.State == "2") { model = businessFunctionBB.GetModel(this.IdValue); this.SetModel(ref model); businessFunctionBB.ModifyRecord(model); } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",4);", true); return; } finally { businessFunctionBB.Dispose(); } this.ClientScript.RegisterStartupScript(this.GetType(), "CloseSubmit", "CloseSubmit()", true); }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public int AddRecord(MBusinessFunctionData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("set nocount on; "); strSql.Append("insert into MBusinessFunction("); strSql.Append("functionNo,functionNm,functionUrl,acceptEmp,isUseEmpAccept,isUseEmpLeaderAccept,useEmpField,windowheight,windowwidth,isDraw,remark)"); strSql.Append(" values ("); strSql.Append("@functionNo,@functionNm,@functionUrl,@acceptEmp,@isUseEmpAccept,@isUseEmpLeaderAccept,@useEmpField,@windowheight,@windowwidth,@isDraw,@remark)"); strSql.Append("; select @@identity; set nocount off; "); SqlParameter[] parameters = { new SqlParameter("@functionNo", SqlDbType.NVarChar,20), new SqlParameter("@functionNm", SqlDbType.NVarChar,50), new SqlParameter("@functionUrl", SqlDbType.NVarChar,200), new SqlParameter("@acceptEmp", SqlDbType.NVarChar,20), new SqlParameter("@isUseEmpAccept", SqlDbType.Bit), new SqlParameter("@isUseEmpLeaderAccept", SqlDbType.Bit), new SqlParameter("@useEmpField", SqlDbType.NVarChar,50), new SqlParameter("@windowheight", SqlDbType.Int), new SqlParameter("@windowwidth", SqlDbType.Int), new SqlParameter("@isDraw", SqlDbType.Bit), new SqlParameter("@remark", SqlDbType.NVarChar,200) }; parameters[0].Value = model.functionNo; parameters[1].Value = model.functionNm; parameters[2].Value = model.functionUrl; parameters[3].Value = model.acceptEmp; parameters[4].Value = model.isUseEmpAccept; parameters[5].Value = model.isUseEmpLeaderAccept; parameters[6].Value = model.useEmpField; parameters[7].Value = model.windowheight; parameters[8].Value = model.windowwidth; parameters[9].Value = model.isDraw; parameters[10].Value = model.remark; int id = 0; try { object ret = SqlHelper.ExecuteScalar(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ret != null && ret != DBNull.Value) { id = Convert.ToInt32(ret); } } catch (Exception ex) { throw ex; } return id; }
private void ShowInfo(string functionNo) { MBusinessFunctionData businessFunctionData = new MBusinessFunctionData(); MBusinessFunctionBB businessFunctionBB = new MBusinessFunctionBB(); try { businessFunctionData = businessFunctionBB.GetModel(functionNo); this.acceptEmp.Text = businessFunctionData.acceptEmp; } finally { businessFunctionBB.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Request.Params["id"] != null && Request.Params["id"].Trim() != "") { this.IdValue = Request.Params["id"]; } if (Request.Params["state"] != null && Request.Params["state"].Trim() != string.Empty) { this.State = Request.Params["state"].ToString(); switch (this.State) { case "1": //add break; case "2": //update //���ؿؼ� MBusinessFunctionBB businessFunctionBB = new MBusinessFunctionBB(); MBusinessFunctionData businessFunctionData = new MBusinessFunctionData(); try { businessFunctionData = businessFunctionBB.GetModel(this.IdValue); //����й��������˴�Ҫ��֤�Ƿ������� this.ShowInfo(this.IdValue); } finally { businessFunctionBB.Dispose(); } break; default: break; } } } }
private void SetModel(ref MBusinessFunctionData model) { model.functionNo = this.functionNo.Text; model.functionNm = this.functionNm.Text; model.functionUrl = this.functionUrl.Text; model.acceptEmp = this.acceptEmp.Text; model.isUseEmpAccept = this.isUseEmpAccept.Checked; model.isUseEmpLeaderAccept = this.isUseEmpLeaderAccept.Checked; model.useEmpField = this.useEmpField.Text; if (this.windowheight.Text != "") { model.windowheight = Convert.ToInt32(this.windowheight.Text); } else { model.windowheight = 0; } if (this.windowwidth.Text != "") { model.windowwidth = Convert.ToInt32(this.windowwidth.Text); } else { model.windowwidth = 0; } model.isDraw = this.isDraw.Checked; model.remark = this.remark.Text; }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public bool ModifyRecord(MBusinessFunctionData model) { return this.businessFunctionDB.ModifyRecord(model); }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public int AddRecord(MBusinessFunctionData model) { return this.businessFunctionDB.AddRecord(model); }
/// <summary> /// ������Ϣ�� /// </summary> /// <param name="functionNo">��Ϣ���</param> /// <param name="recordValue">����ֵ</param> /// <param name="recordTitle">����</param> /// <param name="useEmpId">������id</param> /// <param name="acceptEmpId">������id</param> public void Send(string functionNo, string recordValue, string recordTitle, int empId, int acceptEmpId) { //д����Ϣ���б����� MBusinessFunctionBB businessFunctionBB = new MBusinessFunctionBB(); HEemployeeBB userBB = new HEemployeeBB(); MBusinessData businessData = new MBusinessData(); MBusinessFunctionData businessFunctionData = new MBusinessFunctionData(); try { businessData.functionNo = functionNo; businessData.recordValue = recordValue; businessData.messageTitle = recordTitle; businessData.empId = empId; businessData.sendTime = DateTime.Now.ToString(); businessData.isRead = false; //�ж���Ϣ��ִ���� if (acceptEmpId != 0) { businessData.acceptEmp = "p___" + acceptEmpId.ToString(); } else { businessFunctionData = businessFunctionBB.GetModel(functionNo); string useEmpId = ""; if (businessFunctionData.isUseEmpAccept || businessFunctionData.isUseEmpLeaderAccept) { //ȡ��ԭʼ���������� string workTableNm; string recordKeyField; bool keyIsInt = false; DataSet ds = new DataSet(); ds = businessFunctionBB.GetVList("functionNo='" + functionNo + "'"); if (ds.Tables[0].Rows.Count == 0) { throw new Exception("�Ҳ�����Ϣ��������¼����������Ϣ��"); } DataRow row = ds.Tables[0].Rows[0]; workTableNm = Convert.ToString(row["tableNm"]); recordKeyField = Convert.ToString(row["recordKeyField"]); if (row["keyIsInt"] != DBNull.Value) { keyIsInt = Convert.ToBoolean(row["keyIsInt"]); } string strSql = "select " + businessFunctionData.useEmpField + " from " + workTableNm; if (keyIsInt) { strSql += " where " + recordKeyField + "=" + recordValue; } else { strSql += " where " + recordKeyField + "='" + recordValue + "'"; } ds.Reset(); ds = this.commBB.Query(strSql); if (ds.Tables[0].Rows.Count == 0) { throw new Exception("��Ϣ���������ò���ȷ����������Ϣ��"); } row = ds.Tables[0].Rows[0]; useEmpId = Convert.ToString(row[0]); } if (businessFunctionData.isUseEmpAccept) { businessData.acceptEmp = "p___" + useEmpId; } else if (businessFunctionData.isUseEmpLeaderAccept) { //ȡ��ԭʼ���������˵IJ��Ÿ����� DataSet ds = new DataSet(); ds = userBB.GetList("empId=" + useEmpId); if (ds.Tables[0].Rows.Count == 0) { throw new Exception("��Ա�����쵼û�����ã���������Ϣ��"); } DataRow row = ds.Tables[0].Rows[0]; //����н�ɫ���壬���ɾ��иý�ɫ�IJ��Ÿ����˽��� if (businessFunctionData.acceptEmp != "") { businessData.acceptEmp = businessFunctionData.acceptEmp.Replace("R_", "R_" + row["nowDepartId"].ToString()); } else { businessData.acceptEmp = "p___" + row["departLeader"].ToString(); } } else { businessData.acceptEmp = businessFunctionData.acceptEmp; } } this.businessBB.AddRecord(businessData); } catch (Exception ex) { throw ex; } finally { businessFunctionBB.Dispose(); userBB.Dispose(); } }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public bool ModifyRecord(MBusinessFunctionData model) { bool ret = false; StringBuilder strSql = new StringBuilder(); strSql.Append("update MBusinessFunction set "); strSql.Append("functionNm=@functionNm,"); strSql.Append("functionUrl=@functionUrl,"); strSql.Append("acceptEmp=@acceptEmp,"); strSql.Append("isUseEmpAccept=@isUseEmpAccept,"); strSql.Append("isUseEmpLeaderAccept=@isUseEmpLeaderAccept,"); strSql.Append("useEmpField=@useEmpField,"); strSql.Append("windowheight=@windowheight,"); strSql.Append("windowwidth=@windowwidth,"); strSql.Append("isDraw=@isDraw,"); strSql.Append("remark=@remark"); strSql.Append(" where functionNo = @functionNo "); SqlParameter[] parameters = { new SqlParameter("@functionNo", SqlDbType.NVarChar,20), new SqlParameter("@functionNm", SqlDbType.NVarChar,50), new SqlParameter("@functionUrl", SqlDbType.NVarChar,200), new SqlParameter("@acceptEmp", SqlDbType.NVarChar,20), new SqlParameter("@isUseEmpAccept", SqlDbType.Bit), new SqlParameter("@isUseEmpLeaderAccept", SqlDbType.Bit), new SqlParameter("@useEmpField", SqlDbType.NVarChar,50), new SqlParameter("@windowheight", SqlDbType.Int), new SqlParameter("@windowwidth", SqlDbType.Int), new SqlParameter("@isDraw", SqlDbType.Bit), new SqlParameter("@remark", SqlDbType.NVarChar,200) }; parameters[0].Value = model.functionNo; parameters[1].Value = model.functionNm; parameters[2].Value = model.functionUrl; parameters[3].Value = model.acceptEmp; parameters[4].Value = model.isUseEmpAccept; parameters[5].Value = model.isUseEmpLeaderAccept; parameters[6].Value = model.useEmpField; parameters[7].Value = model.windowheight; parameters[8].Value = model.windowwidth; parameters[9].Value = model.isDraw; parameters[10].Value = model.remark; try { SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); ret = true; } catch (Exception ex) { throw ex; } return ret; }
/// <summary> /// �õ�һ��model /// </summary> /// <param name="functionNo">����ֵ</param> /// <returns>model</returns> public MBusinessFunctionData GetModel(string functionNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from MBusinessFunction"); strSql.Append(" where functionNo = @functionNo "); SqlParameter[] parameters = { new SqlParameter("@functionNo", SqlDbType.NVarChar,20) }; parameters[0].Value = functionNo; MBusinessFunctionData model = new MBusinessFunctionData(); DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; if (row["functionNo"] != DBNull.Value) { model.functionNo = Convert.ToString(row["functionNo"]); } if (row["functionNm"] != DBNull.Value) { model.functionNm = Convert.ToString(row["functionNm"]); } if (row["functionUrl"] != DBNull.Value) { model.functionUrl = Convert.ToString(row["functionUrl"]); } if (row["acceptEmp"] != DBNull.Value) { model.acceptEmp = Convert.ToString(row["acceptEmp"]); } if (row["isUseEmpAccept"] != DBNull.Value) { model.isUseEmpAccept = Convert.ToBoolean(row["isUseEmpAccept"]); } if (row["isUseEmpLeaderAccept"] != DBNull.Value) { model.isUseEmpLeaderAccept = Convert.ToBoolean(row["isUseEmpLeaderAccept"]); } if (row["useEmpField"] != DBNull.Value) { model.useEmpField = Convert.ToString(row["useEmpField"]); } if (row["windowheight"] != DBNull.Value) { model.windowheight = Convert.ToInt32(row["windowheight"]); } if (row["windowwidth"] != DBNull.Value) { model.windowwidth = Convert.ToInt32(row["windowwidth"]); } if (row["isDraw"] != DBNull.Value) { model.isDraw = Convert.ToBoolean(row["isDraw"]); } if (row["remark"] != DBNull.Value) { model.remark = Convert.ToString(row["remark"]); } return model; } else { return null; } }