protected void Check_btnSubmit(object sender, AjaxEventArgs e)//提交操作
{
//try
//{
WSS.Model.Tasks n = new WSS.Model.Tasks();
n.F_Title = txtTitle.Text;
n.F_Type = int.Parse(cbType.SelectedItem.Value.ToString());
n.F_Note = e.ExtraParams["fckParameter"].ToString();;
n.F_From = int.Parse(cbFrom.SelectedItem.Value.ToString());
n.F_JinjiLevel = int.Parse(cbJinjiLevel.SelectedItem.Value.ToString());
n.F_GameName = int.Parse(cbGameName.SelectedItem.Value.ToString());
n.F_DateTime = DateTime.Now;
n.F_Telphone = txtTelphone.Text;
n.F_DutyMan = int.Parse(cbDutyMan.SelectedItem.Value.ToString());
// n.F_EditMan = int.Parse(Session["FID"]);
n.F_EditMan = 3;
n.F_Rowtype = 0;
n.F_State = int.Parse(cbstate.SelectedItem.Value.ToString());
switch (GetAction.Text)
{
case "add":
if (n.F_Note.Trim().Length < 1)
{
Ext.Msg.Alert(ConfigurationManager.AppSettings["MsgTitle"], "内容不能为空").Show();
break;
}
AddNewsInfo(n);
break;
case "edit":
string rowid = HF_id.Text;
if (!string.IsNullOrEmpty(rowid))
{
n.F_ID = Convert.ToInt32(rowid);
TList = new WSS.BLL.Tasks().GetModel(n.F_ID);
if (TList != null)
{
n.F_PreDutyMan = TList.F_DutyMan;
}
UpdateNewsInfoByID(n);
}
break;
default:
break;
}
//}
//catch (Exception)
//{
// throw;
//}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WSS.Model.Tasks model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Tasks(");
strSql.Append("F_Title,F_Note,F_From,F_Type,F_JinjiLevel,F_GameName,F_GameZone,F_GUserID,F_GRoleName,F_Tag,F_State,F_Telphone,F_DutyMan,F_PreDutyMan,F_DateTime,F_EditMan,F_Rowtype)");
strSql.Append(" values (");
strSql.Append("@F_Title,@F_Note,@F_From,@F_Type,@F_JinjiLevel,@F_GameName,@F_GameZone,@F_GUserID,@F_GRoleName,@F_Tag,@F_State,@F_Telphone,@F_DutyMan,@F_PreDutyMan,@F_DateTime,@F_EditMan,@F_Rowtype)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@F_Title", SqlDbType.NVarChar, 30),
new SqlParameter("@F_Note", SqlDbType.NVarChar, 500),
new SqlParameter("@F_From", SqlDbType.Int, 4),
new SqlParameter("@F_Type", SqlDbType.Int, 4),
new SqlParameter("@F_JinjiLevel", SqlDbType.Int, 4),
new SqlParameter("@F_GameName", SqlDbType.Int, 4),
new SqlParameter("@F_GameZone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GUserID", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GRoleName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_Tag", SqlDbType.NVarChar, 50),
new SqlParameter("@F_State", SqlDbType.Int, 4),
new SqlParameter("@F_Telphone", SqlDbType.NChar, 16),
new SqlParameter("@F_DutyMan", SqlDbType.Int, 4),
new SqlParameter("@F_PreDutyMan", SqlDbType.Int, 4),
new SqlParameter("@F_DateTime", SqlDbType.DateTime),
new SqlParameter("@F_EditMan", SqlDbType.Int, 4),
new SqlParameter("@F_Rowtype", SqlDbType.TinyInt, 1)
};
parameters[0].Value = model.F_Title;
parameters[1].Value = model.F_Note;
parameters[2].Value = model.F_From;
parameters[3].Value = model.F_Type;
parameters[4].Value = model.F_JinjiLevel;
parameters[5].Value = model.F_GameName;
parameters[6].Value = model.F_GameZone;
parameters[7].Value = model.F_GUserID;
parameters[8].Value = model.F_GRoleName;
parameters[9].Value = model.F_Tag;
parameters[10].Value = model.F_State;
parameters[11].Value = model.F_Telphone;
parameters[12].Value = model.F_DutyMan;
parameters[13].Value = model.F_PreDutyMan;
parameters[14].Value = model.F_DateTime;
parameters[15].Value = model.F_EditMan;
parameters[16].Value = model.F_Rowtype;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 修改操作
/// </summary>
private void UpdateNewsInfoByID(WSS.Model.Tasks n)
{
if (new WSS.BLL.Tasks().Update(n) == true)
{
Ext.Msg.Alert(ConfigurationManager.AppSettings["MsgTitle"], "数据已经修改成功！").Show();
NewsWindow.Hide();
}
else
{
Ext.Msg.Alert(ConfigurationManager.AppSettings["MsgError"], ConfigurationManager.AppSettings["ErrorMessage"]).Show();
}
}
private void AddNewsInfo(WSS.Model.Tasks n)
{
int tid = new WSS.BLL.Tasks().Add(n);
if (tid > 0)
{
WSS.BLL.T_TasksLog a = new WSS.BLL.T_TasksLog();
a.F_ID = tid;
a.F_Title = n.F_Title;
a.F_Note = n.F_Note;
a.F_From = n.F_From;
a.F_Type = n.F_Type;
a.F_JinjiLevel = n.F_JinjiLevel;
a.F_GameName = n.F_GameName;
a.F_GameZone = n.F_GameZone;
a.F_GUserID = n.F_GUserID;
a.F_GRoleName = n.F_GRoleName;
a.F_Tag = n.F_Tag;
a.F_State = n.F_State;
a.F_Telphone = n.F_Telphone;
a.F_DutyMan = n.F_DutyMan;
a.F_PreDutyMan = n.F_PreDutyMan;
a.F_DateTime = n.F_DateTime;
a.F_EditMan = n.F_EditMan;
a.F_Rowtype = n.F_Rowtype;
a.Add();
GridPanelNewsList.Reload();
//Ext.Msg.Confirm(ConfigurationManager.AppSettings["MsgTitle"], "数据已经添加成功,是否继续添加?", new MessageBox.ButtonsConfig
//{
// Yes = new MessageBox.ButtonConfig
// {
// Handler = "#{FormPanelNews}.getForm().reset();var oEditor = FCKeditorAPI.GetInstance('fckHtmlEditor');oEditor.SetHTML('');#{txtTitle}.focus(true);",
// Text = "确 定"
// },
// No = new MessageBox.ButtonConfig
// {
// Handler = "#{FormPanelNews}.getForm().reset();#{NewsWindow}.hide();",
// Text = "取 消"
// }
//}).Show();
Ext.Msg.Alert(ConfigurationManager.AppSettings["MsgAlert"], "数据已经添加成功").Show();
WSS.BLL.AllOther.AddNotify("qq", "qqqqqq");
}
else
{
Ext.Msg.Alert(ConfigurationManager.AppSettings["MsgError"], ConfigurationManager.AppSettings["ErrorMessage"]).Show();
}
}
/// <summary>
/// 提交操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Check_btnSubmit(object sender, AjaxEventArgs e)
{
//try
//{
WSS.Model.Tasks n = new WSS.Model.Tasks();
n.F_Title = txtTitle.Text;
n.F_Type = int.Parse(cbType.SelectedItem.Value.ToString());
n.F_Note = e.ExtraParams["fckParameter"].ToString();;
n.F_From = int.Parse(cbFrom.SelectedItem.Value.ToString());
n.F_JinjiLevel = int.Parse(cbJinjiLevel.SelectedItem.Value.ToString());
n.F_GameName = int.Parse(cbGameName.SelectedItem.Value.ToString());
n.F_DateTime = DateTime.Now;
n.F_Telphone = txtTelphone.Text;
n.F_DutyMan = int.Parse(cbDutyMan.SelectedItem.Value.ToString());
switch (GetAction.Text)
{
case "add":
AddNewsInfo(n);
break;
case "edit":
string rowid = GetSelectRowID();
if (!string.IsNullOrEmpty(rowid))
{
n.F_ID = Convert.ToInt32(rowid);
UpdateNewsInfoByID(n);
}
break;
default:
break;
}
//}
//catch (Exception)
//{
// throw;
//}
}
private void ShowInfo(int F_ID)
{
WSS.BLL.Tasks bll = new WSS.BLL.Tasks();
WSS.Model.Tasks model = bll.GetModel(F_ID);
this.lblF_ID.Text = model.F_ID.ToString();
this.txtF_Title.Text = model.F_Title;
this.txtF_Note.Text = model.F_Note;
this.txtF_From.Text = model.F_From;
this.txtF_Type.Text = model.F_Type;
this.txtF_JinjiLevel.Text = model.F_JinjiLevel;
this.txtF_GameName.Text = model.F_GameName;
this.txtF_GameZone.Text = model.F_GameZone;
this.txtF_GUserID.Text = model.F_GUserID;
this.txtF_GRoleName.Text = model.F_GRoleName;
this.txtF_Tag.Text = model.F_Tag;
this.txtF_DateTime.Text = model.F_DateTime;
this.txtF_State.Text = model.F_State;
this.txtF_Telphone.Text = model.F_Telphone;
this.txtF_DutyMan.Text = model.F_DutyMan;
}
private void AddNewsInfo(WSS.Model.Tasks n)
{
if (new WSS.BLL.Tasks().Add(n) > 0)
{
GridPanelNewsList.Reload();
Ext.Msg.Confirm(ConfigurationManager.AppSettings["MsgTitle"], "数据已经添加成功,是否继续添加?", new MessageBox.ButtonsConfig
{
Yes = new MessageBox.ButtonConfig
{
Handler = "#{FormPanelNews}.getForm().reset();var oEditor = FCKeditorAPI.GetInstance('fckHtmlEditor');oEditor.SetHTML('');#{txtTitle}.focus(true);",
Text = "确 定"
},
No = new MessageBox.ButtonConfig
{
Handler = "#{FormPanelNews}.getForm().reset();#{NewsWindow}.hide();",
Text = "取 消"
}
}).Show();
}
else
{
Ext.Msg.Alert(ConfigurationManager.AppSettings["MsgError"], ConfigurationManager.AppSettings["ErrorMessage"]).Show();
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WSS.Model.Tasks model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WSS.Model.Tasks model)
{
return(dal.Add(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <WSS.Model.Tasks> DataTableToList(DataTable dt)
{
List <WSS.Model.Tasks> modelList = new List <WSS.Model.Tasks>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
WSS.Model.Tasks model;
for (int n = 0; n < rowsCount; n++)
{
model = new WSS.Model.Tasks();
if (dt.Rows[n]["F_ID"].ToString() != "")
{
model.F_ID = int.Parse(dt.Rows[n]["F_ID"].ToString());
}
model.F_Title = dt.Rows[n]["F_Title"].ToString();
model.F_Note = dt.Rows[n]["F_Note"].ToString();
if (dt.Rows[n]["F_From"].ToString() != "")
{
model.F_From = int.Parse(dt.Rows[n]["F_From"].ToString());
}
if (dt.Rows[n]["F_Type"].ToString() != "")
{
model.F_Type = int.Parse(dt.Rows[n]["F_Type"].ToString());
}
if (dt.Rows[n]["F_JinjiLevel"].ToString() != "")
{
model.F_JinjiLevel = int.Parse(dt.Rows[n]["F_JinjiLevel"].ToString());
}
if (dt.Rows[n]["F_GameName"].ToString() != "")
{
model.F_GameName = int.Parse(dt.Rows[n]["F_GameName"].ToString());
}
model.F_GameZone = dt.Rows[n]["F_GameZone"].ToString();
model.F_GUserID = dt.Rows[n]["F_GUserID"].ToString();
model.F_GRoleName = dt.Rows[n]["F_GRoleName"].ToString();
model.F_Tag = dt.Rows[n]["F_Tag"].ToString();
if (dt.Rows[n]["F_State"].ToString() != "")
{
model.F_State = int.Parse(dt.Rows[n]["F_State"].ToString());
}
model.F_Telphone = dt.Rows[n]["F_Telphone"].ToString();
if (dt.Rows[n]["F_DutyMan"].ToString() != "")
{
model.F_DutyMan = int.Parse(dt.Rows[n]["F_DutyMan"].ToString());
}
if (dt.Rows[n]["F_PreDutyMan"].ToString() != "")
{
model.F_PreDutyMan = int.Parse(dt.Rows[n]["F_PreDutyMan"].ToString());
}
if (dt.Rows[n]["F_DateTime"].ToString() != "")
{
model.F_DateTime = DateTime.Parse(dt.Rows[n]["F_DateTime"].ToString());
}
if (dt.Rows[n]["F_EditMan"].ToString() != "")
{
model.F_EditMan = int.Parse(dt.Rows[n]["F_EditMan"].ToString());
}
if (dt.Rows[n]["F_Rowtype"].ToString() != "")
{
model.F_Rowtype = int.Parse(dt.Rows[n]["F_Rowtype"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtF_Title.Text.Trim().Length == 0)
{
strErr += "F_Title不能为空！\\n";
}
if (this.txtF_Note.Text.Trim().Length == 0)
{
strErr += "F_Note不能为空！\\n";
}
if (this.txtF_From.Text.Trim().Length == 0)
{
strErr += "F_From不能为空！\\n";
}
if (this.txtF_Type.Text.Trim().Length == 0)
{
strErr += "F_Type不能为空！\\n";
}
if (this.txtF_JinjiLevel.Text.Trim().Length == 0)
{
strErr += "F_JinjiLevel不能为空！\\n";
}
if (this.txtF_GameName.Text.Trim().Length == 0)
{
strErr += "F_GameName不能为空！\\n";
}
if (this.txtF_GameZone.Text.Trim().Length == 0)
{
strErr += "F_GameZone不能为空！\\n";
}
if (this.txtF_GUserID.Text.Trim().Length == 0)
{
strErr += "F_GUserID不能为空！\\n";
}
if (this.txtF_GRoleName.Text.Trim().Length == 0)
{
strErr += "F_GRoleName不能为空！\\n";
}
if (this.txtF_Tag.Text.Trim().Length == 0)
{
strErr += "F_Tag不能为空！\\n";
}
if (this.txtF_DateTime.Text.Trim().Length == 0)
{
strErr += "F_DateTime不能为空！\\n";
}
if (this.txtF_State.Text.Trim().Length == 0)
{
strErr += "F_State不能为空！\\n";
}
if (this.txtF_Telphone.Text.Trim().Length == 0)
{
strErr += "F_Telphone不能为空！\\n";
}
if (this.txtF_DutyMan.Text.Trim().Length == 0)
{
strErr += "F_DutyMan不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int F_ID = int.Parse(this.lblF_ID.Text);
string F_Title = this.txtF_Title.Text;
string F_Note = this.txtF_Note.Text;
string F_From = this.txtF_From.Text;
string F_Type = this.txtF_Type.Text;
string F_JinjiLevel = this.txtF_JinjiLevel.Text;
string F_GameName = this.txtF_GameName.Text;
string F_GameZone = this.txtF_GameZone.Text;
string F_GUserID = this.txtF_GUserID.Text;
string F_GRoleName = this.txtF_GRoleName.Text;
string F_Tag = this.txtF_Tag.Text;
string F_DateTime = this.txtF_DateTime.Text;
string F_State = this.txtF_State.Text;
string F_Telphone = this.txtF_Telphone.Text;
string F_DutyMan = this.txtF_DutyMan.Text;
WSS.Model.Tasks model = new WSS.Model.Tasks();
model.F_ID = F_ID;
model.F_Title = F_Title;
model.F_Note = F_Note;
model.F_From = F_From;
model.F_Type = F_Type;
model.F_JinjiLevel = F_JinjiLevel;
model.F_GameName = F_GameName;
model.F_GameZone = F_GameZone;
model.F_GUserID = F_GUserID;
model.F_GRoleName = F_GRoleName;
model.F_Tag = F_Tag;
model.F_DateTime = F_DateTime;
model.F_State = F_State;
model.F_Telphone = F_Telphone;
model.F_DutyMan = F_DutyMan;
WSS.BLL.Tasks bll = new WSS.BLL.Tasks();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WSS.Model.Tasks GetModel(int F_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 F_ID,F_Title,F_Note,F_From,F_Type,F_JinjiLevel,F_GameName,F_GameZone,F_GUserID,F_GRoleName,F_Tag,F_State,F_Telphone,F_DutyMan,F_PreDutyMan,F_DateTime,F_EditMan,F_Rowtype from T_Tasks ");
strSql.Append(" where F_ID=@F_ID");
SqlParameter[] parameters =
{
new SqlParameter("@F_ID", SqlDbType.Int, 4)
};
parameters[0].Value = F_ID;
WSS.Model.Tasks model = new WSS.Model.Tasks();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["F_ID"].ToString() != "")
{
model.F_ID = int.Parse(ds.Tables[0].Rows[0]["F_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["F_Title"] != null)
{
model.F_Title = ds.Tables[0].Rows[0]["F_Title"].ToString();
}
if (ds.Tables[0].Rows[0]["F_Note"] != null)
{
model.F_Note = ds.Tables[0].Rows[0]["F_Note"].ToString();
}
if (ds.Tables[0].Rows[0]["F_From"].ToString() != "")
{
model.F_From = int.Parse(ds.Tables[0].Rows[0]["F_From"].ToString());
}
if (ds.Tables[0].Rows[0]["F_Type"].ToString() != "")
{
model.F_Type = int.Parse(ds.Tables[0].Rows[0]["F_Type"].ToString());
}
if (ds.Tables[0].Rows[0]["F_JinjiLevel"].ToString() != "")
{
model.F_JinjiLevel = int.Parse(ds.Tables[0].Rows[0]["F_JinjiLevel"].ToString());
}
if (ds.Tables[0].Rows[0]["F_GameName"].ToString() != "")
{
model.F_GameName = int.Parse(ds.Tables[0].Rows[0]["F_GameName"].ToString());
}
if (ds.Tables[0].Rows[0]["F_GameZone"] != null)
{
model.F_GameZone = ds.Tables[0].Rows[0]["F_GameZone"].ToString();
}
if (ds.Tables[0].Rows[0]["F_GUserID"] != null)
{
model.F_GUserID = ds.Tables[0].Rows[0]["F_GUserID"].ToString();
}
if (ds.Tables[0].Rows[0]["F_GRoleName"] != null)
{
model.F_GRoleName = ds.Tables[0].Rows[0]["F_GRoleName"].ToString();
}
if (ds.Tables[0].Rows[0]["F_Tag"] != null)
{
model.F_Tag = ds.Tables[0].Rows[0]["F_Tag"].ToString();
}
if (ds.Tables[0].Rows[0]["F_State"].ToString() != "")
{
model.F_State = int.Parse(ds.Tables[0].Rows[0]["F_State"].ToString());
}
if (ds.Tables[0].Rows[0]["F_Telphone"] != null)
{
model.F_Telphone = ds.Tables[0].Rows[0]["F_Telphone"].ToString();
}
if (ds.Tables[0].Rows[0]["F_DutyMan"].ToString() != "")
{
model.F_DutyMan = int.Parse(ds.Tables[0].Rows[0]["F_DutyMan"].ToString());
}
if (ds.Tables[0].Rows[0]["F_PreDutyMan"].ToString() != "")
{
model.F_PreDutyMan = int.Parse(ds.Tables[0].Rows[0]["F_PreDutyMan"].ToString());
}
if (ds.Tables[0].Rows[0]["F_DateTime"].ToString() != "")
{
model.F_DateTime = DateTime.Parse(ds.Tables[0].Rows[0]["F_DateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["F_EditMan"].ToString() != "")
{
model.F_EditMan = int.Parse(ds.Tables[0].Rows[0]["F_EditMan"].ToString());
}
if (ds.Tables[0].Rows[0]["F_Rowtype"].ToString() != "")
{
model.F_Rowtype = int.Parse(ds.Tables[0].Rows[0]["F_Rowtype"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WSS.Model.Tasks model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Tasks set ");
strSql.Append("F_Title=@F_Title,");
strSql.Append("F_Note=@F_Note,");
strSql.Append("F_From=@F_From,");
strSql.Append("F_Type=@F_Type,");
strSql.Append("F_JinjiLevel=@F_JinjiLevel,");
strSql.Append("F_GameName=@F_GameName,");
strSql.Append("F_GameZone=@F_GameZone,");
strSql.Append("F_GUserID=@F_GUserID,");
strSql.Append("F_GRoleName=@F_GRoleName,");
strSql.Append("F_Tag=@F_Tag,");
strSql.Append("F_State=@F_State,");
strSql.Append("F_Telphone=@F_Telphone,");
strSql.Append("F_DutyMan=@F_DutyMan,");
strSql.Append("F_PreDutyMan=@F_PreDutyMan,");
strSql.Append("F_DateTime=@F_DateTime,");
strSql.Append("F_EditMan=@F_EditMan,");
strSql.Append("F_Rowtype=@F_Rowtype");
strSql.Append(" where F_ID=@F_ID");
SqlParameter[] parameters =
{
new SqlParameter("@F_Title", SqlDbType.NVarChar, 30),
new SqlParameter("@F_Note", SqlDbType.NVarChar, 500),
new SqlParameter("@F_From", SqlDbType.Int, 4),
new SqlParameter("@F_Type", SqlDbType.Int, 4),
new SqlParameter("@F_JinjiLevel", SqlDbType.Int, 4),
new SqlParameter("@F_GameName", SqlDbType.Int, 4),
new SqlParameter("@F_GameZone", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GUserID", SqlDbType.NVarChar, 16),
new SqlParameter("@F_GRoleName", SqlDbType.NVarChar, 16),
new SqlParameter("@F_Tag", SqlDbType.NVarChar, 50),
new SqlParameter("@F_State", SqlDbType.Int, 4),
new SqlParameter("@F_Telphone", SqlDbType.NChar, 16),
new SqlParameter("@F_DutyMan", SqlDbType.Int, 4),
new SqlParameter("@F_PreDutyMan", SqlDbType.Int, 4),
new SqlParameter("@F_DateTime", SqlDbType.DateTime),
new SqlParameter("@F_EditMan", SqlDbType.Int, 4),
new SqlParameter("@F_Rowtype", SqlDbType.TinyInt, 1),
new SqlParameter("@F_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.F_Title;
parameters[1].Value = model.F_Note;
parameters[2].Value = model.F_From;
parameters[3].Value = model.F_Type;
parameters[4].Value = model.F_JinjiLevel;
parameters[5].Value = model.F_GameName;
parameters[6].Value = model.F_GameZone;
parameters[7].Value = model.F_GUserID;
parameters[8].Value = model.F_GRoleName;
parameters[9].Value = model.F_Tag;
parameters[10].Value = model.F_State;
parameters[11].Value = model.F_Telphone;
parameters[12].Value = model.F_DutyMan;
parameters[13].Value = model.F_PreDutyMan;
parameters[14].Value = model.F_DateTime;
parameters[15].Value = model.F_EditMan;
parameters[16].Value = model.F_Rowtype;
parameters[17].Value = model.F_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void UpdateNewsInfoByID(WSS.Model.Tasks n)//修改操作
{
if (new WSS.BLL.Tasks().Update(n) == true)
{
WSS.BLL.T_TasksLog TLoglist = new WSS.BLL.T_TasksLog();
TLoglist.F_ID = TList.F_ID;
if (n.F_Note.Trim().Length != 0)
{
TLoglist.F_Note = n.F_Note;
}
if (n.F_Title != TList.F_Title)
{
TLoglist.F_Title = n.F_Title;
}
if (n.F_DateTime != TList.F_DateTime)
{
TLoglist.F_DateTime = n.F_DateTime;
}
if (n.F_DutyMan != TList.F_DutyMan)
{
TLoglist.F_DutyMan = n.F_DutyMan;
}
TLoglist.F_EditMan = TList.F_EditMan;
if (n.F_From != TList.F_From)
{
TLoglist.F_From = n.F_From;
}
if (n.F_GameName != TList.F_GameName)
{
TLoglist.F_GameName = n.F_GameName;
}
if (n.F_JinjiLevel != TList.F_JinjiLevel)
{
TLoglist.F_JinjiLevel = n.F_JinjiLevel;
}
if (n.F_PreDutyMan != TList.F_PreDutyMan)
{
TLoglist.F_PreDutyMan = n.F_PreDutyMan;
}
if (n.F_Rowtype != TList.F_Rowtype)
{
TLoglist.F_Rowtype = n.F_Rowtype;
}
if (n.F_State != TList.F_State)
{
TLoglist.F_State = n.F_State;
}
if (n.F_Telphone != TList.F_Telphone)
{
TLoglist.F_Telphone = n.F_Telphone;
}
if (n.F_Type != TList.F_Type)
{
TLoglist.F_Type = n.F_Type;
}
TLoglist.Add();
GridPanelNewsList.Reload();
Ext.Msg.Alert(ConfigurationManager.AppSettings["MsgTitle"], "数据已经修改成功！").Show();
NewsWindow.Hide();
}
else
{
Ext.Msg.Alert(ConfigurationManager.AppSettings["MsgError"], ConfigurationManager.AppSettings["ErrorMessage"]).Show();
}
}
