/// <summary>
/// 绑定单位信息
/// </summary>
/// <param name="dwList"></param>
/// <param name="textContorl"></param>
/// <param name="comType"></param>
public void BindCompanyContorl(IList<Xm_Xmdw> dwList, TextBox textContorl, ItemCompanyType comType)
{
var cQuery = (from item in dwList where item.Type == comType select item);
if (cQuery.Count<Xm_Xmdw>() != 0)
{
textContorl.Text = cQuery.First().Name;
}
}
/// <summary>
/// 保存项目单位信息
/// </summary>
/// <param name="company"></param>
/// <returns></returns>
public void SaveItemCompany(string itemCode, ItemCompanyType comType, Xm_Xmdw itemCompany, ref ArrayList strSql)
{
string tmpSql = string.Empty;
tmpSql = "delete from xm_xmdw where itemCode in ({0}) and type = {1}";
tmpSql = string.Format(tmpSql, itemCode, ((int)comType).ToString());
strSql.Add(tmpSql);
if (itemCompany != null)
{
tmpSql = "insert into xm_xmdw (itemcode, type, name, code, linkphone, linkman)"
+ " values ('{0}','{1}','{2}','{3}','{4}','{5}')";
tmpSql = string.Format(tmpSql, itemCompany.ItemCode, ((int)itemCompany.Type).ToString(),
itemCompany.Name, itemCompany.Code, itemCompany.LinkPhone, itemCompany.LinkMan);
strSql.Add(tmpSql);
}
}
public DataTable QueryXmdw(string itemCode, ItemCompanyType type)
{
StringBuilder sbSql = new StringBuilder();
sbSql.AppendLine("select a.* from xm_xmdw a");
sbSql.AppendLine("where a.itemcode = '{0}' and a.type = '{1}'");
string strSql = string.Format(sbSql.ToString(), itemCode, (int)type);
return OracleHelper.ExecuteDataTable(strSql);
}
/// <summary>
/// 根据项目编号获取项目单位信息
/// </summary>
/// <param name="itemCode"></param>
/// <param name="comType"></param>
/// <returns></returns>
public Xm_Xmdw GetItemCompany(string itemCode, ItemCompanyType comType)
{
Xm_Xmdw company = null;
string strSql = "select * from xm_xmdw where itemCode = '{0}' and type = '{1}'";
strSql = string.Format(strSql, itemCode, ((int)comType).ToString());
DataTable dt = OracleHelper.ExecuteDataTable(strSql);
if (dt.Rows.Count > 0)
{
company = (Xm_Xmdw)new DataTableOperation().ConvertFromDataRowToEntity(dt.Rows[0], typeof(Xm_Xmdw));
}
return company;
}
