public KeyWordEditViewModel(KeyWordListViewModel _vm, KeyWordEditView _mw)
{
_KeyWordListVM = _vm;
_Window = _mw;
OperationType = OpType.Add;
KeyWordObj = new KeyWordOR();
Init();
}
public KeyWordEditViewModel(KeyWordListViewModel _vm, KeyWordEditView _mw, KeyWordOR _KeyWordObj)
{
_KeyWordListVM = _vm;
_Window = _mw;
_SourceObj = _KeyWordObj;
OperationType = OpType.Alert;
KeyWordObj = new KeyWordOR();
KeyWordObj.Clone(_KeyWordObj);
Init();
}
/// <summary>
/// 插入t_KeyWord
/// </summary>
public virtual bool Insert(KeyWordOR keyWord)
{
//string sql = "insert into t_KeyWord (KeyWordID, KeyWord, KeyWordName, Replace, IsCustomize) values (@KeyWordID, @KeyWord, @KeyWordName, @Replace, @IsCustomize)";
string sql = "insert into t_KeyWord (KeyWord, KeyWordName, Replace, IsCustomize) values (@KeyWord, @KeyWordName, @Replace, @IsCustomize)";
SqlParameter[] parameters = new SqlParameter[]
{
//new SqlParameter("@KeyWordID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "KeyWordID", DataRowVersion.Default, keyWord.Keywordid),
new SqlParameter("@KeyWord", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "KeyWord", DataRowVersion.Default, keyWord.Keyword),
new SqlParameter("@KeyWordName", SqlDbType.Char, 10, ParameterDirection.Input, false, 0, 0, "KeyWordName", DataRowVersion.Default, keyWord.Keywordname),
new SqlParameter("@Replace", SqlDbType.VarChar, 4000, ParameterDirection.Input, false, 0, 0, "Replace", DataRowVersion.Default, keyWord.Replace),
new SqlParameter("@IsCustomize", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "IsCustomize", DataRowVersion.Default, keyWord.Iscustomize)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public ObservableCollection<KeyWordOR> selectAllDate()
{
string sql = "select * from t_KeyWord";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
ObservableCollection<KeyWordOR> _List = new ObservableCollection<KeyWordOR>();
foreach (DataRow dr in dt.Rows)
{
KeyWordOR obj = new KeyWordOR(dr);
_List.Add(obj);
}
return _List;
}
public KeyWordEditViewModel(KeyWordOR _Sta)
{
OperationType = OpType.Alert;
KeyWordObj = _Sta;
}
public KeyWordOR selectARowDate(string m_id)
{
string sql = string.Format("select * from t_KeyWord where Keywordid='{0}'", m_id);
DataTable dt = null;
try
{
dt = db.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
KeyWordOR m_KeyW = new KeyWordOR(dr);
return m_KeyW;
}
/// <summary>
/// 更新t_KeyWord
/// </summary>
public virtual bool Update(KeyWordOR keyWord)
{
string sql = "update t_KeyWord set KeyWord = @KeyWord, KeyWordName = @KeyWordName, Replace = @Replace, IsCustomize = @IsCustomize where KeyWordID = @KeyWordID";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@KeyWordID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "KeyWordID", DataRowVersion.Default, keyWord.Keywordid),
new SqlParameter("@KeyWord", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "KeyWord", DataRowVersion.Default, keyWord.Keyword),
new SqlParameter("@KeyWordName", SqlDbType.Char, 10, ParameterDirection.Input, false, 0, 0, "KeyWordName", DataRowVersion.Default, keyWord.Keywordname),
new SqlParameter("@Replace", SqlDbType.VarChar, 4000, ParameterDirection.Input, false, 0, 0, "Replace", DataRowVersion.Default, keyWord.Replace),
new SqlParameter("@IsCustomize", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "IsCustomize", DataRowVersion.Default, keyWord.Iscustomize)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public void Clone(KeyWordOR obj)
{
//
Keywordid = obj.Keywordid;
//关键字
Keyword = obj.Keyword;
//关键字名称
Keywordname = obj.Keywordname;
//替换值
Replace = obj.Replace;
//是否自定义
Iscustomize = obj.Iscustomize;
}
public KeyWordEditView(KeyWordListViewModel _List, KeyWordOR _KeyWord)
{
InitializeComponent();
this.DataContext = new KeyWordEditViewModel(_List, this, _KeyWord);
}