public int Add(QMItem model)
{
string sql = "insert into QM_QMItem(QMCId, QMItemCode, QMItemName, cMemo, cMaker, dCreateDate) output inserted.QMItemId ";
sql += "values(@QMCId, @QMItemCode, @QMItemName, @cMemo, @cMaker, @dCreateDate)";
model.dCreateDate = DateTime.Now;
return(conn.ExecuteScalar <int>(sql, model));
}
public void Update(QMItem model)
{
string sql = "update QM_QMItem set QMCId = @QMCId, QMItemCode = @QMItemCode, QMItemName = @QMItemName where QMItemId = @QMItemId";
conn.Execute(sql, model);
}
