/// <summary>
///
/// </summary>
/// <param name="from"></param>
/// <param name="modifier"></param>
public void SaveGoodsFrom(GoodsFrom from, string modifier)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IGoodsFromDAO dao = DAOFactory.Instance.CreateGoodsFromDAO();
dao.UpdateGoodsFrom(from, conn);
}
}
/// <summary>
///
/// </summary>
/// <param name="from"></param>
/// <param name="deleter"></param>
public void DeleteGoodsFrom(GoodsFrom from, string deleter)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IGoodsFromDAO dao = DAOFactory.Instance.CreateGoodsFromDAO();
dao.DeleteGoodsFrom(from.ID, conn);
}
}
/// <summary>
///
/// </summary>
/// <param name="from"></param>
/// <param name="creator"></param>
public void CreateGoodsFrom(GoodsFrom from, string creator)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IGoodsFromDAO dao = DAOFactory.Instance.CreateGoodsFromDAO();
dao.InsertGoodsFrom(from, conn);
}
}
/// <summary>
/// 用于修改
/// </summary>
/// <param name="model"></param>
public FrmGoodsFrom(GoodsFrom model)
{
InitializeComponent();
this._Model = model;
this.Text = string.Format(this.Text, "修改");
this.txtCode.Text = model.Code;
this.txtName.Text = model.Name;
this.txtRemark.Text = model.Remark;
}
public void InsertGoodsFrom(GoodsFrom goodsFrom, IDbConnection conn, IDbTransaction trans)
{
string sql = @"
INSERT INTO MD_GoodsFrom(GoodsFromCode,GoodsFromName,Actived)
VALUES(@GoodsFromCode,@GoodsFromName,@Actived)";
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@GoodsFromCode", goodsFrom.Code));
paramList.Add(new SqlParameter("@GoodsFromName", goodsFrom.Name));
paramList.Add(new SqlParameter("@Actived", goodsFrom.Actived));
DataAccessUtil.ExecuteNonQuery(sql, paramList, (SqlTransaction)trans);
}
public void UpdateGoodsFrom(GoodsFrom goodsFrom, IDbConnection conn, IDbTransaction trans)
{
string sql = @"
UPDATE MD_GoodsFrom SET
GoodsFromCode=@GoodsFromCode,GoodsFromName=@GoodsFromName,
Actived=@Actived
WHERE ID=@ID";
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@GoodsFromCode", goodsFrom.Code));
paramList.Add(new SqlParameter("@GoodsFromName", goodsFrom.Name));
paramList.Add(new SqlParameter("@Actived", goodsFrom.Actived));
paramList.Add(new SqlParameter("@ID", goodsFrom.ID));
DataAccessUtil.ExecuteNonQuery(sql, paramList, (SqlTransaction)trans);
}
public List <GoodsFrom> SelectAllGoodsFroms(IDbConnection conn)
{
string sql = "SELECT ID,GoodsFromCode,GoodsFromName,Actived FROM MD_GoodsFrom";
SqlDataReader reader = DataAccessUtil.ExecuteReader(sql, new List <SqlParameter>(), (SqlConnection)conn);
List <GoodsFrom> list = new List <GoodsFrom>();
while (reader.Read())
{
GoodsFrom sh = new GoodsFrom();
sh.ID = reader.GetInt32(0);
sh.Code = reader.GetString(1);
sh.Name = reader.GetString(2);
sh.Actived = reader.GetBoolean(3);
list.Add(sh);
}
reader.Close();
return(list);
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
//Verify
if (string.IsNullOrEmpty(this.txtCode.Text.Trim()))
{
throw new ApplicationException("编码不能为空");
}
if (string.IsNullOrEmpty(this.txtName.Text.Trim()))
{
throw new ApplicationException("名称不能为空");
}
//Save
ModelService service = new ModelService();
if (this._Model == null) //新建
{
if (service.GetGoodsFromByCode(this.txtCode.Text.Trim()) != null)
{
throw new ApplicationException(string.Format("编码{0}已经被使用，请尝试其他编码。", this.txtCode.Text.Trim()));
}
GoodsFrom newModel = new GoodsFrom();
newModel.Code = this.txtCode.Text.Trim();
newModel.Name = this.txtName.Text.Trim();
newModel.Remark = this.txtRemark.Text.Trim();
newModel.Actived = true;
service.CreateGoodsFrom(newModel, PermissionService.GetCurrentUser().Name);
}
else//修改
{
this._Model.Code = this.txtCode.Text.Trim();
this._Model.Name = this.txtName.Text.Trim();
this._Model.Remark = this.txtRemark.Text.Trim();
service.SaveGoodsFrom(this._Model, PermissionService.GetCurrentUser().Name);
}
//Close dialog
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
ErrorHandler.OnError(ex);
}
}
private List <GoodsFrom> GetSelectedModelList()
{
List <GoodsFrom> selectedModelList = new List <GoodsFrom>();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
DataGridViewCheckBoxCell cell = (DataGridViewCheckBoxCell)row.Cells[0];
if (cell.EditedFormattedValue != null && (bool)cell.EditedFormattedValue == true)
{
GoodsFrom selectedStorehouse = (GoodsFrom)row.Tag;
selectedModelList.Add(selectedStorehouse);
}
}
if (selectedModelList.Count == 0)
{
throw new ApplicationException("请先选择要操作的内容。");
}
return(selectedModelList);
}
public GoodsFrom SelectGoodsFrom(string code, IDbConnection conn)
{
string sql = @"
SELECT ID,GoodsFromCode,GoodsFromName,Actived,Remark
FROM MD_GoodsFrom
WHERE Code=@Code";
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@Code", code));
SqlDataReader reader = DataAccessUtil.ExecuteReader(sql, paramList, (SqlConnection)conn);
GoodsFrom result = null;
while (reader.Read())
{
result = new GoodsFrom();
result.ID = reader.GetInt32(0);
result.Code = reader.GetString(1);
result.Name = reader.GetString(2);
result.Actived = reader.GetBoolean(3);
}
reader.Close();
return(result);
}