public int Delete(ConferenceManageModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
num = new ConferenceManageBLL().Delete(ObjModel.Code, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
private ConferenceManageModel _DataBind(int Code)
{
ConferenceManageModel model = new ConferenceManageModel();
StringBuilder builder = new StringBuilder();
builder.Append("select * from ConferenceManage ");
builder.Append(" where Code=@Code");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@Code", SqlDbType.Int, 4, Code);
SqlDataReader sqlDataReader = null;
try
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
this.Initialize(sqlDataReader, model);
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(model);
}
protected void InsertButton_Click(object sender, EventArgs e)
{
int conferenceCode;
ConferenceManageBFL cmBFL = new ConferenceManageBFL();
ConferenceManageModel cmModel = new ConferenceManageModel();
AspWebControl.Calendar startDate = (AspWebControl.Calendar)(this.FormView1.FindControl("startDate"));
AspWebControl.Calendar endDate = (AspWebControl.Calendar)(this.FormView1.FindControl("endDate"));
DropDownList ddlType = (DropDownList)(this.FormView1.Row.FindControl("DropDownListType"));
ucDept = (RmsPM.Web.UserControls.InputUnit)(this.FormView1.Row.FindControl("Inputunit1"));
//DropDownList ddlDept = (DropDownList)(this.FormView1.Row.FindControl("DropDownListDept"));
TextBox tbxTopic = (TextBox)(this.FormView1.FindControl("TextBoxTopic"));
TextBox tbxCharter = (TextBox)(this.FormView1.FindControl("TextBoxChaterMember"));
TextBox tbxRemark = (TextBox)(this.FormView1.FindControl("TextBoxRemark"));
TextBox tbxPlace = (TextBox)(this.FormView1.FindControl("TextBoxPlace"));
cmModel.ChaterMember = tbxCharter.Text;
cmModel.Dept = ucDept.Text;
cmModel.EndTime = DateTime.Parse(endDate.Value);
cmModel.Place = tbxPlace.Text;
cmModel.Remark = tbxRemark.Text;
cmModel.StartTime = DateTime.Parse(startDate.Value);
cmModel.State = "未通过";
cmModel.Topic = tbxTopic.Text;
cmModel.Type = ddlType.SelectedItem.Text;
conferenceCode = cmBFL.Insert(cmModel);
this.ucadd = (RmsPM.Web.UserControls.AttachMentAdd)(this.FormView1.Row.FindControl("Attachmentadd1"));
ucadd.SaveAttachMent(conferenceCode.ToString());
this.SaveDataIntoUserList("Attend", conferenceCode);
this.SaveDataIntoUserList("OtherAttend", conferenceCode);
Response.Redirect("ConferenceWeek.aspx");
}
private int _Insert(ConferenceManageModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into ConferenceManage(");
builder.Append("Topic,ChaterMember,Type,Place,Dept,StartTime,EndTime,Remark,State)");
builder.Append(" values (");
builder.Append("@Topic,@ChaterMember,@Type,@Place,@Dept,@StartTime,@EndTime,@Remark,@State) ");
builder.Append("SELECT @Code = SCOPE_IDENTITY()");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@Topic", SqlDbType.VarChar, 500, mObj.Topic);
this._DataProcess.ProcessParametersAdd("@ChaterMember", SqlDbType.VarChar, 50, mObj.ChaterMember);
this._DataProcess.ProcessParametersAdd("@Type", SqlDbType.VarChar, 100, mObj.Type);
this._DataProcess.ProcessParametersAdd("@Place", SqlDbType.VarChar, 100, mObj.Place);
this._DataProcess.ProcessParametersAdd("@Dept", SqlDbType.VarChar, 100, mObj.Dept);
this._DataProcess.ProcessParametersAdd("@StartTime", SqlDbType.DateTime, 4, mObj.StartTime);
this._DataProcess.ProcessParametersAdd("@EndTime", SqlDbType.DateTime, 4, mObj.EndTime);
this._DataProcess.ProcessParametersAdd("@Remark", SqlDbType.VarChar, 0x7d0, mObj.Remark);
this._DataProcess.ProcessParametersAdd("@State", SqlDbType.VarChar, 50, mObj.State);
SqlParameter parameter = this._DataProcess.ProcessParametersAdd("@Code", SqlDbType.Int, 4, null);
parameter.Direction = ParameterDirection.Output;
this._DataProcess.RunSql();
mObj.Code = (int)parameter.Value;
return(mObj.Code);
}
void Insert()
{
int conferenceCode;
ConferenceManageBFL cmBFL = new ConferenceManageBFL();
ConferenceManageModel cmModel = new ConferenceManageModel();
AspWebControl.Calendar startDate = (AspWebControl.Calendar)(this.FormView1.FindControl("startDate"));
AspWebControl.Calendar endDate = (AspWebControl.Calendar)(this.FormView1.FindControl("endDate"));
DropDownList ddlType = (DropDownList)(this.FormView1.Row.FindControl("DropDownListType"));
ucDept = (RmsPM.Web.UserControls.InputUnit)(this.FormView1.Row.FindControl("Inputunit1"));
TextBox tbxTopic = (TextBox)(this.FormView1.FindControl("TextBoxTopic"));
TextBox tbxRemark = (TextBox)(this.FormView1.FindControl("TextBoxRemark"));
HiddenField hidPlace = (HiddenField)(this.FormView1.FindControl("HidRoomCode"));
cmModel.ChaterMember = user.UserCode;
cmModel.Dept = ucDept.Value;
cmModel.Place = hidPlace.Value;
cmModel.Remark = tbxRemark.Text;
cmModel.State = MeetStateType.UnAuthored.ToString();
cmModel.Topic = tbxTopic.Text;
cmModel.Type = ddlType.SelectedItem.Text;
cmModel.StartTime = cmBFL.GetUsefulDate(startDate.Value);
cmModel.EndTime = cmBFL.GetUsefulDate(endDate.Value);
conferenceCode = cmBFL.Insert(cmModel);
this.ucadd = (RmsPM.Web.UserControls.AttachMentAdd)(this.FormView1.Row.FindControl("Attachmentadd1"));
ucadd.SaveAttachMent(conferenceCode.ToString());
this.SaveDataIntoUserList("Attend", conferenceCode);
this.SaveDataIntoUserList("OtherAttend", conferenceCode);
Response.Redirect("XZ_ConferenceWeek.aspx");
}
public void ChangeMeetAuditState(int meetCode)
{
ConferenceManageBFL ebfl = new ConferenceManageBFL();
ConferenceManageModel objModel = new ConferenceManageModel();
objModel.Code = meetCode;
objModel.State = MeetStateType.Authored.ToString();
ebfl.Update(objModel);
}
private int _Update(ConferenceManageModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("update ConferenceManage set ");
if (mObj.Topic != null)
{
builder.Append("Topic=@Topic,");
this._DataProcess.ProcessParametersAdd("@Topic", SqlDbType.VarChar, 500, mObj.Topic);
}
if (mObj.ChaterMember != null)
{
builder.Append("ChaterMember=@ChaterMember,");
this._DataProcess.ProcessParametersAdd("@ChaterMember", SqlDbType.VarChar, 50, mObj.ChaterMember);
}
if (mObj.Type != null)
{
builder.Append("Type=@Type,");
this._DataProcess.ProcessParametersAdd("@Type", SqlDbType.VarChar, 100, mObj.Type);
}
if (mObj.Place != null)
{
builder.Append("Place=@Place,");
this._DataProcess.ProcessParametersAdd("@Place", SqlDbType.VarChar, 100, mObj.Place);
}
if (mObj.Dept != null)
{
builder.Append("Dept=@Dept,");
this._DataProcess.ProcessParametersAdd("@Dept", SqlDbType.VarChar, 100, mObj.Dept);
}
if (mObj.StartTime != DateTime.MinValue)
{
builder.Append("StartTime=@StartTime,");
this._DataProcess.ProcessParametersAdd("@StartTime", SqlDbType.DateTime, 4, mObj.StartTime);
}
if (mObj.EndTime != DateTime.MinValue)
{
builder.Append("EndTime=@EndTime,");
this._DataProcess.ProcessParametersAdd("@EndTime", SqlDbType.DateTime, 4, mObj.EndTime);
}
if (mObj.Remark != null)
{
builder.Append("Remark=@Remark,");
this._DataProcess.ProcessParametersAdd("@Remark", SqlDbType.VarChar, 0x7d0, mObj.Remark);
}
if (mObj.State != null)
{
builder.Append("State=@State,");
this._DataProcess.ProcessParametersAdd("@State", SqlDbType.VarChar, 50, mObj.State);
}
builder.Remove(builder.Length - 1, 1);
builder.Append(" where Code=@Code");
this._DataProcess.ProcessParametersAdd("@Code", SqlDbType.Int, 4, mObj.Code);
this._DataProcess.CommandText = builder.ToString();
return(this._DataProcess.RunSql());
}
private List <ConferenceManageModel> _Select(ConferenceManageQueryModel qmObj)
{
List <ConferenceManageModel> list = new List <ConferenceManageModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from ConferenceManage ");
builder.Append(qmObj.QueryConditionStr);
if (qmObj.SortColumns.Length == 0)
{
builder.Append(" ORDER BY Code desc");
}
else
{
builder.Append(" ORDER BY " + qmObj.SortColumns);
}
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.SqlParameters = qmObj.Parameters;
SqlDataReader sqlDataReader = null;
int num = 0;
try
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1)))
{
ConferenceManageModel model = new ConferenceManageModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
public ConferenceManageModel GetConferenceManage(int Code)
{
ConferenceManageModel model = new ConferenceManageModel();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
model = new ConferenceManageBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(model);
}
private void Initialize(SqlDataReader reader, ConferenceManageModel obj)
{
if (reader.GetValue(0) != DBNull.Value)
{
obj.Code = reader.GetInt32(0);
}
if (reader.GetValue(1) != DBNull.Value)
{
obj.Topic = reader.GetString(1);
}
if (reader.GetValue(2) != DBNull.Value)
{
obj.ChaterMember = reader.GetString(2);
}
if (reader.GetValue(3) != DBNull.Value)
{
obj.Type = reader.GetString(3);
}
if (reader.GetValue(4) != DBNull.Value)
{
obj.Place = reader.GetString(4);
}
if (reader.GetValue(5) != DBNull.Value)
{
obj.Dept = reader.GetString(5);
}
if (reader.GetValue(6) != DBNull.Value)
{
obj.StartTime = reader.GetDateTime(6);
}
if (reader.GetValue(7) != DBNull.Value)
{
obj.EndTime = reader.GetDateTime(7);
}
if (reader.GetValue(8) != DBNull.Value)
{
obj.Remark = reader.GetString(8);
}
if (reader.GetValue(9) != DBNull.Value)
{
obj.State = reader.GetString(9);
}
}
public void SendMsgToUser(int meetCode)
{
ConferenceManageBFL ebfl = new ConferenceManageBFL();
ConferenceManageModel conferenceManage = new ConferenceManageModel();
conferenceManage = ebfl.GetConferenceManage(meetCode);
string strUser = conferenceManage.ChaterMember;
string text2 = string.Format("{0} 会议", conferenceManage.Topic);
string text3 = string.Format("主办单位： <b>{0}</b>\r\n会议地点： <b>{1}</b>\r\n会议时间：<b>{2}</b>\r\n<a href='../RmsOA/XZ_Conference.aspx?Type=Read&Code={3}'>详细内容</a>\r\n<a href='../RmsOA/XZ_ConferenceWeek.aspx'>本周会议</a>", new object[] { conferenceManage.Dept, conferenceManage.Place, conferenceManage.StartTime, meetCode.ToString() });
DateTime now = DateTime.Now;
string code = SystemManageDAO.GetNewSysCode("Notice");
EntityData entity = new EntityData("Standard_Notice");
DataRow newRecord = entity.GetNewRecord();
newRecord["NoticeCode"] = code;
newRecord["Title"] = text2;
newRecord["SubmitPerson"] = strUser;
newRecord["SubmitDate"] = DateTime.Now;
newRecord["UpdateDate"] = DateTime.Now;
newRecord["UserCode"] = strUser;
newRecord["Content"] = text3;
newRecord["Type"] = "1";
newRecord["IsAll"] = "0";
newRecord["status"] = "1";
entity.AddNewRecord(newRecord);
string strTmp = this.UserListString(meetCode);
ArrayList arOperator = new ArrayList();
this.SaveRS(arOperator, StringRule.CutRepeat(strTmp), "", "080104");
this.SaveRS(arOperator, strUser, "", "080102,080103,080104");
if (arOperator.Count > 0)
{
ResourceRule.SetResourceAccessRange(code, "0801", "", arOperator, false);
}
RemindDAO.InsertNotice(entity);
entity.Dispose();
}
public int Update(ConferenceManageModel mObj)
{
return(this._Update(mObj));
}
public List <ConferenceManageModel> GetUserMeet(string userCode, DateTime begin, DateTime end)
{
List <ConferenceManageModel> list = new List <ConferenceManageModel>();
ConferenceManageModel item = new ConferenceManageModel();
this._DataProcess.CommandText = "SELECT Code,Topic,ChaterMember,Type,Place,StartTime,EndTime,Dept\r\nFROM CONFERENCEMANAGE \r\nWHERE (STARTTIME >=@TimeBegin AND STARTTIME <=@TimeEnd)\r\nAND STATE ='AUTHORED'\r\nAND ( CODE IN\r\n(\r\nSELECT CONFERENCECODE FROM CONFERENCEUSERLIST\r\nWHERE USERCODE =@UserCode\r\n) OR CHATERMEMBER =@UserCode\r\n)";
this._DataProcess.ProcessParametersAdd("@UserCode", SqlDbType.VarChar, 50, userCode);
this._DataProcess.ProcessParametersAdd("@TimeBegin", SqlDbType.DateTime, 8, begin);
this._DataProcess.ProcessParametersAdd("@TimeEnd", SqlDbType.DateTime, 8, end);
SqlDataReader sqlDataReader = this._DataProcess.GetSqlDataReader();
using (SqlDataReader reader2 = sqlDataReader)
{
try
{
while (sqlDataReader.Read())
{
item = new ConferenceManageModel();
if (!sqlDataReader.GetValue(0).Equals(DBNull.Value))
{
item.Code = sqlDataReader.GetInt32(0);
}
if (!sqlDataReader.GetValue(1).Equals(DBNull.Value))
{
item.Topic = sqlDataReader.GetString(1);
}
if (!sqlDataReader.GetValue(2).Equals(DBNull.Value))
{
item.ChaterMember = sqlDataReader.GetString(2);
}
if (!sqlDataReader.GetValue(3).Equals(DBNull.Value))
{
item.Type = sqlDataReader.GetString(3);
}
if (!sqlDataReader.GetValue(4).Equals(DBNull.Value))
{
item.Place = sqlDataReader.GetString(4);
}
if (!sqlDataReader.GetValue(5).Equals(DBNull.Value))
{
item.StartTime = sqlDataReader.GetDateTime(5);
}
if (!sqlDataReader.GetValue(6).Equals(DBNull.Value))
{
item.EndTime = sqlDataReader.GetDateTime(6);
}
if (!sqlDataReader.GetValue(7).Equals(DBNull.Value))
{
item.Dept = sqlDataReader.GetString(7);
}
else
{
item.Dept = string.Empty;
}
list.Add(item);
}
}
catch (Exception exception)
{
throw exception;
}
}
return(list);
}
public int Delete(ConferenceManageModel mObj)
{
return(this._Delete(mObj.Code));
}
public int Insert(ConferenceManageModel ObjModel, SqlTransaction Transaction)
{
ConferenceManageDAL edal = new ConferenceManageDAL(Transaction);
return(edal.Insert(ObjModel));
}
public int Update(ConferenceManageModel ObjModel, SqlTransaction Transaction)
{
ConferenceManageDAL edal = new ConferenceManageDAL(Transaction);
return(edal.Update(ObjModel));
}
public int Insert(ConferenceManageModel mObj)
{
return(this._Insert(mObj));
}
