public ReturnValue Update(Province model)
{
OleDbParameter[] parameters = {
new OleDbParameter("@Name", OleDbType.VarWChar,50),
new OleDbParameter("@Code", OleDbType.VarWChar,10),};
parameters[0].Value = model.Name;
parameters[1].Value = model.Code;
return OleDbHelper.ExecuteSql(Update_SQL, parameters);
}
public ReturnValue Add(Province model)
{
OleDbParameter[] parameters = {
new OleDbParameter("@UPDATER_ID", OleDbType.VarWChar,12),
new OleDbParameter("@TERMINAL_CD", OleDbType.LongVarWChar),
new OleDbParameter("@Code", OleDbType.VarWChar,10),
new OleDbParameter("@Name", OleDbType.VarWChar,50)};
parameters[0].Value = model.UPDATER_ID;
parameters[1].Value = model.TERMINAL_CD;
parameters[2].Value = model.Code;
parameters[3].Value = model.Name;
return OleDbHelper.ExecuteSql(Add_SQL, parameters);
}
public ReturnValue Update(Province model)
{
SqlParameter[] parameters = {
new SqlParameter("@UPDATER_ID", SqlDbType.NVarChar,12),
new SqlParameter("@TERMINAL_CD", SqlDbType.NVarChar,255),
new SqlParameter("@Name", SqlDbType.NVarChar,50),
new SqlParameter("@Code", SqlDbType.NVarChar,50),};
parameters[0].Value = model.UPDATER_ID;
parameters[1].Value = model.TERMINAL_CD;
parameters[2].Value = model.Name;
parameters[3].Value = model.Code;
return SqlHelper.ExecuteSql(Update_SQL, parameters);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnValue AddUpdate(Province model)
{
ReturnValue resoult = dalProvince.Search(model.Code);
if (!resoult.ErrorFlag)
{
return resoult;
}
if (resoult.Count > 0)
{
resoult = dalProvince.Update(model);
}
else
{
resoult = dalProvince.Add(model);
}
return resoult;
}
