/**
* 添加台区信息
* @param ref AreaInfo areaInfo：台区信息
* @return int 值为Constant.OK：执行成功，值为Constant.ERROR为执行失败
* @author Rick
**/
public int addAreaInfo(ref AreaInfo areaInfo)
{
string strAdd = "insert into AreaInfo values (" + areaInfo.AreaNo + ",'" + areaInfo.AreaName + "'," + areaInfo.AreaFlag + ", getdate()," + areaInfo.AreaNo + ")";
try
{
SQLUtl.ExecuteSql(strAdd);
return Constant.OK;
}
catch (Exception)
{
return Constant.ERROR;
}
}
/**
* 更新台区信息
* @param string areaNo：台区号
* @param ref AreaInfo areaInfo：台区信息
* @return int 值为Constant.OK：执行成功，值为Constant.ERROR为执行失败
* @author Rick
**/
public int updateAreaInfo(string areaNo, ref AreaInfo areaInfo)
{
string strUpdate = "update AreaInfo set AreaName = '" + areaInfo.AreaName + "', AreaFlag = " + areaInfo.AreaFlag + ", AreaDate = getdate() where AreaNo = " + areaNo;
try
{
SQLUtl.ExecuteSql(strUpdate);
return Constant.OK;
}
catch (Exception)
{
return Constant.ERROR;
}
}
/**
* 添加新台区信息
* @param string areaNo：台区号
* @param ref AreaInfo areaInfo：台区信息
* @return int 值为Constant.OK：执行成功，值为Constant.ERROR为执行失败
* @author Rick
**/
public int getAreaInfoById(string areaNo, ref AreaInfo areaInfo)
{
string strSelect = "select * from AreaInfo where AreaNo = " + areaNo;
try
{
DataSet ds = SQLUtl.Query(strSelect);
DataTable dt = ds.Tables[0];
if (null != dt.Rows[0].ItemArray[0])
{
areaInfo.AreaNo = dt.Rows[0].ItemArray[0].ToString().Trim();
}
else
{
areaInfo.AreaNo = "";
}
if (null != dt.Rows[0].ItemArray[1])
{
areaInfo.AreaName = dt.Rows[0].ItemArray[1].ToString().Trim();
}
else
{
areaInfo.AreaName = "";
}
if (null != dt.Rows[0].ItemArray[2])
{
areaInfo.AreaFlag = dt.Rows[0].ItemArray[2].ToString().Trim();
}
else
{
areaInfo.AreaFlag = "";
}
if (null != dt.Rows[0].ItemArray[3])
{
areaInfo.AreaDate = dt.Rows[0].ItemArray[3].ToString().Trim();
}
else
{
areaInfo.AreaDate = "";
}
return Constant.OK;
}
catch (Exception)
{
return Constant.ERROR;
}
}
