/// <summary>
/// get table record
/// <summary>
/// <param name=warehouseid>warehouseid</param>
/// <param name=out emsg>return error message</param>
///<returns>get a record detail of warehouselist</returns>
public modWarehouseList GetItem(string warehouseid, out string emsg)
{
try
{
//Execute a query to read the categories
string sql = string.Format("select warehouse_id,warehouse_desc,status,default_flag,update_user,update_time from warehouse_list where warehouse_id='{0}' order by warehouse_id", warehouseid);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modWarehouseList model = new modWarehouseList();
model.WarehouseId = dalUtility.ConvertToString(rdr["warehouse_id"]);
model.WarehouseDesc = dalUtility.ConvertToString(rdr["warehouse_desc"]);
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.DefaultFlag = dalUtility.ConvertToInt(rdr["default_flag"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
emsg = null;
return(model);
}
else
{
emsg = "Error on read data";
return(null);
}
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// get all warehouselist
/// <summary>
/// <param name=validonly>status is valid</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all warehouselist</returns>
public BindingCollection <modWarehouseList> GetIList(bool validonly, out string emsg)
{
try
{
BindingCollection <modWarehouseList> modellist = new BindingCollection <modWarehouseList>();
//Execute a query to read the categories
string getwhere = validonly == true ? "and status=1" : string.Empty;
string sql = "select warehouse_id,warehouse_desc,status,default_flag,update_user,update_time from warehouse_list where warehouse_id<>'ÁÙʱ' " + getwhere + " order by warehouse_id";
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modWarehouseList model = new modWarehouseList();
model.WarehouseId = dalUtility.ConvertToString(rdr["warehouse_id"]);
model.WarehouseDesc = dalUtility.ConvertToString(rdr["warehouse_desc"]);
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.DefaultFlag = dalUtility.ConvertToInt(rdr["default_flag"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
modellist.Add(model);
}
}
emsg = null;
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
private void DBGrid_SelectionChanged(object sender, EventArgs e)
{
if (DBGrid.CurrentRow != null)
{
modWarehouseList mod = (modWarehouseList)DBGrid.CurrentRow.DataBoundItem;
txtWarehouseId.Text = mod.WarehouseId;
txtWarehouseDesc.Text = mod.WarehouseDesc;
cboStatus.SelectedIndex = Convert.ToInt32(mod.Status);
cboDefault.SelectedIndex = Convert.ToInt32(mod.DefaultFlag);
FindText = mod.WarehouseId;
}
}
protected override void Find()
{
for (int i = 0; i < DBGrid.Rows.Count; i++)
{
modWarehouseList mod = (modWarehouseList)DBGrid.Rows[i].DataBoundItem;
if (mod.WarehouseId.CompareTo(FindText) == 0)
{
DBGrid.CurrentCell = DBGrid.Rows[i].Cells[0];
DBGrid_SelectionChanged(null, null);
return;
}
}
}
protected override bool Save()
{
try
{
this.Cursor = Cursors.WaitCursor;
if (string.IsNullOrEmpty(txtWarehouseId.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Warehouse Id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtWarehouseId.Focus();
return(false);
}
modWarehouseList mod = new modWarehouseList();
mod.WarehouseId = txtWarehouseId.Text.Trim();
mod.WarehouseDesc = txtWarehouseDesc.Text.Trim();
mod.Status = cboStatus.SelectedIndex;
mod.DefaultFlag = cboDefault.SelectedIndex;
mod.UpdateUser = Util.UserId;
bool ret = false;
if (_status == 1)
{
ret = _dal.Insert(mod, out Util.emsg);
}
else if (_status == 2)
{
ret = _dal.Update(txtWarehouseId.Text, mod, out Util.emsg);
}
if (ret)
{
Util.ChangeStatus(this, true);
DBGrid.Enabled = true;
LoadData();
FindText = mod.WarehouseId;
Find();
}
return(ret);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
finally
{
this.Cursor = Cursors.Default;
}
}
/// <summary>
/// update a warehouselist
/// <summary>
/// <param name=warehouseid>warehouseid</param>
/// <param name=mod>model object of warehouselist</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Update(string warehouseid, modWarehouseList mod, out string emsg)
{
try
{
string sql = string.Format("update warehouse_list set warehouse_desc='{0}',status={1},default_flag={2},update_user='******',update_time=getdate() where warehouse_id='{4}'", mod.WarehouseDesc, mod.Status, mod.DefaultFlag, mod.UpdateUser, warehouseid);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
/// <summary>
/// insert a warehouselist
/// <summary>
/// <param name=mod>model object of warehouselist</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Insert(modWarehouseList mod, out string emsg)
{
try
{
string sql = string.Format("insert into warehouse_list(warehouse_id,warehouse_desc,status,default_flag,update_user,update_time)values('{0}','{1}',{2},{3},'{4}',getdate())", mod.WarehouseId, mod.WarehouseDesc, mod.Status, mod.DefaultFlag, mod.UpdateUser);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
