/// <summary>
/// 数据操作
/// </summary>
/// <param name="Mess">区别编辑还是新增还是删除</param>
private bool OpreationDB(string Mess, CADS.Model.MessManageInfoList MessManageInfo)
{
try
{
string Error = "";
bool Result = false;
if (Mess == "添加")
{
Result = MessManage.Add(MessManageInfo);
}
if (Mess == "编辑")
{
Result = MessManage.Update(MessManageInfo);
}
if (Mess == "删除")
{
Result = MessManage.Delete(MessManageInfo.MessID);
}
if (Result == true)
{
MessageBox.Show("文电信息" + Mess + "成功");
return(true);
}
else
{
MessageBox.Show("文电信息" + Mess + "失败，请稍后再试！");
return(false);
}
}
catch (Exception e)
{
MessageBox.Show("文电信息" + Mess + "失败:" + e.Message);
return(false);
}
}
private void btn_Edit_Click(object sender, EventArgs e)
{
if (DataView.SelectedRows.Count < 1)
{
MessageBox.Show("请选中一行数据！");
return;
}
CADS.Model.MessManageInfoList MessManageInfo = new CADS.Model.MessManageInfoList();
MessManageInfo.ID = Convert.ToInt32(DataView.CurrentRow.Cells[0].Value);
MessManageInfo.MessID = DataView.CurrentRow.Cells[1].Value.ToString();
MessManageInfo.Receiver = DataView.CurrentRow.Cells[2].Value.ToString();
MessManageInfo.ReceiveOrg = DataView.CurrentRow.Cells[3].Value.ToString();
MessManageInfo.MessType = DataView.CurrentRow.Cells[4].Value.ToString();
MessManageInfo.IsHandle = DataView.CurrentRow.Cells[5].Value.ToString();
MessManageInfo.MessTitle = DataView.CurrentRow.Cells[6].Value.ToString();
MessManageInfo.MessContent = DataView.CurrentRow.Cells[7].Value.ToString();
MessManageInfo.Attachment = DataView.CurrentRow.Cells[8].Value.ToString();
Form_MsSearchAdd addOrEdit = new Form_MsSearchAdd("edit", MessManageInfo);
addOrEdit.ShowDialog();
if (addOrEdit.DialogResult == DialogResult.OK)
{
OpreationDB("编辑", addOrEdit.MessManageInfo);
RefreshDataGridView();
}
}
public Form_MsSearchAdd(string operType, CADS.Model.MessManageInfoList MessManageInfo)
{
InitializeComponent();
this.operType = operType;
if (operType == "add")
{
Title_Label.Text = "文电管理添加";
}
else
{
Title_Label.Text = "文电管理修改";
this.MessManageInfo = MessManageInfo;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CADS.Model.MessManageInfoList DataRowToModel(DataRow row)
{
CADS.Model.MessManageInfoList model = new CADS.Model.MessManageInfoList();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["MessID"] != null)
{
model.MessID = row["MessID"].ToString();
}
if (row["Receiver"] != null)
{
model.Receiver = row["Receiver"].ToString();
}
if (row["ReceiveOrg"] != null)
{
model.ReceiveOrg = row["ReceiveOrg"].ToString();
}
if (row["MessType"] != null)
{
model.MessType = row["MessType"].ToString();
}
if (row["IsHandle"] != null)
{
model.IsHandle = row["IsHandle"].ToString();
}
if (row["MessTitle"] != null)
{
model.MessTitle = row["MessTitle"].ToString();
}
if (row["MessContent"] != null)
{
model.MessContent = row["MessContent"].ToString();
}
if (row["Attachment"] != null)
{
model.Attachment = row["Attachment"].ToString();
}
if (row["mark"] != null)
{
model.mark = row["mark"].ToString();
}
}
return(model);
}
private void btn_Delete_Click(object sender, EventArgs e)
{
if (DataView.SelectedRows.Count < 1)
{
MessageBox.Show("请选中一行数据！");
return;
}
if (MessageBox.Show("确定要删除该行数据？", null, MessageBoxButtons.YesNo) != DialogResult.Yes)
{
return;
}
CADS.Model.MessManageInfoList MessManageInfo = new CADS.Model.MessManageInfoList();
MessManageInfo.MessID = DataView.CurrentRow.Cells[1].Value.ToString();
OpreationDB("删除", MessManageInfo);
RefreshDataGridView();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CADS.Model.MessManageInfoList GetModel(string MessID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" ID,MessID,Receiver,ReceiveOrg,MessType,IsHandle,MessTitle,MessContent,Attachment,mark ");
strSql.Append(" from MessManageInfoList ");
strSql.Append(" where MessID='" + MessID + "' ");
CADS.Model.MessManageInfoList model = new CADS.Model.MessManageInfoList();
DataSet ds = DbHelperOleDb.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(CADS.Model.MessManageInfoList model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.MessID != null)
{
strSql1.Append("MessID,");
strSql2.Append("'" + model.MessID + "',");
}
if (model.Receiver != null)
{
strSql1.Append("Receiver,");
strSql2.Append("'" + model.Receiver + "',");
}
if (model.ReceiveOrg != null)
{
strSql1.Append("ReceiveOrg,");
strSql2.Append("'" + model.ReceiveOrg + "',");
}
if (model.MessType != null)
{
strSql1.Append("MessType,");
strSql2.Append("'" + model.MessType + "',");
}
if (model.IsHandle != null)
{
strSql1.Append("IsHandle,");
strSql2.Append("'" + model.IsHandle + "',");
}
if (model.MessTitle != null)
{
strSql1.Append("MessTitle,");
strSql2.Append("'" + model.MessTitle + "',");
}
if (model.MessContent != null)
{
strSql1.Append("MessContent,");
strSql2.Append("'" + model.MessContent + "',");
}
if (model.Attachment != null)
{
strSql1.Append("Attachment,");
strSql2.Append("'" + model.Attachment + "',");
}
if (model.mark != null)
{
strSql1.Append("mark,");
strSql2.Append("'" + model.mark + "',");
}
strSql.Append("insert into MessManageInfoList(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CADS.Model.MessManageInfoList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MessManageInfoList set ");
if (model.Receiver != null)
{
strSql.Append("Receiver='" + model.Receiver + "',");
}
else
{
strSql.Append("Receiver= null ,");
}
if (model.ReceiveOrg != null)
{
strSql.Append("ReceiveOrg='" + model.ReceiveOrg + "',");
}
else
{
strSql.Append("ReceiveOrg= null ,");
}
if (model.MessType != null)
{
strSql.Append("MessType='" + model.MessType + "',");
}
else
{
strSql.Append("MessType= null ,");
}
if (model.IsHandle != null)
{
strSql.Append("IsHandle='" + model.IsHandle + "',");
}
else
{
strSql.Append("IsHandle= null ,");
}
if (model.MessTitle != null)
{
strSql.Append("MessTitle='" + model.MessTitle + "',");
}
else
{
strSql.Append("MessTitle= null ,");
}
if (model.MessContent != null)
{
strSql.Append("MessContent='" + model.MessContent + "',");
}
else
{
strSql.Append("MessContent= null ,");
}
if (model.Attachment != null)
{
strSql.Append("Attachment='" + model.Attachment + "',");
}
else
{
strSql.Append("Attachment= null ,");
}
if (model.mark != null)
{
strSql.Append("mark='" + model.mark + "',");
}
else
{
strSql.Append("mark= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where MessID='" + model.MessID + "' ");
int rowsAffected = DbHelperOleDb.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}