/// <summary>
/// 获取指定列指定结果集结果集
/// 作者：
/// </summary>
/// <param name="top">表示前N个记录，小于等于0表示"*"</param>
/// <param name="strWhere">过滤条件组合串，输入字符串中不能包含where关键字，需要排序时在条件后加 order by</param>
/// <param name="columns">表示1个或者多个字段字符串，多个字段之间用","隔开如： "ID,Name,Value,...."</param>
/// <returns>返回结果集</returns>
public DataTable GetColumnDataTable(int top, string strWhere, params string[] columns)
{
return(DataBase.GetColumnList("tMachine", top, strWhere, columns));
}
/// <summary>
/// 部分修改保存
/// </summary>
/// <param name="model">对象clsMachine的一个实例参数</param>
/// <returns></returns>
public int InsertOrUpdate(clsMachine model, bool isAdd, out string sErrMsg)
{
sErrMsg = string.Empty;
int rtn = 0;
sb.Length = 0;
try
{
//sb.AppendFormat("IF Exists(SELECT SysCode FROM tMachine WHERE SysCode='{0}')",model.SysCode);//如果存在进行update操作
if (!isAdd)
{
sb.Append("UPDATE tMachine SET ");
sb.AppendFormat("LinkComNo={0}", model.LinkComNo);
sb.AppendFormat(",MachineName='{0}'", model.MachineName);
sb.AppendFormat(",MachineModel='{0}'", model.MachineModel);
sb.AppendFormat(",Company='{0}'", model.Company);
sb.AppendFormat(",Protocol='{0}'", model.Protocol);
sb.AppendFormat(",IsSupport={0}", model.IsSupport);
sb.AppendFormat(",IsShow={0}", model.IsShow);
sb.AppendFormat(",TestValue={0}", model.TestValue);
sb.AppendFormat(",TestSign='{0}'", model.TestSign);
sb.AppendFormat(",LinkStdCode='{0}'", model.LinkStdCode);
sb.AppendFormat(",OrderId='{0}'", model.OrderId);
sb.AppendFormat(" WHERE SysCode='{0}'", model.SysCode);
}
else
{
//sb.Append(" ELSE ");
sb.Append("INSERT INTO tMachine");
sb.Append("(SysCode,MachineName,MachineModel,Company,Protocol,IsSupport,");
sb.Append("LinkComNo,TestSign,TestValue,LinkStdCode,IsShow,OrderId)");
sb.Append("VALUES(");
sb.AppendFormat("'{0}'", model.SysCode);
sb.AppendFormat(",'{0}'", model.MachineName);
sb.AppendFormat(",'{0}'", model.MachineModel);
sb.AppendFormat(",'{0}'", model.Company);
sb.AppendFormat(",'{0}'", model.Protocol);
sb.AppendFormat(",{0}", model.IsSupport);
sb.AppendFormat(",{0}", model.LinkComNo);
sb.AppendFormat(",'{0}'", model.TestSign);
sb.AppendFormat(",{0}", model.TestValue);
sb.AppendFormat(",'{0}'", model.LinkStdCode);
sb.AppendFormat(",{0}", model.IsShow);
sb.AppendFormat(",{0}", model.OrderId);
sb.Append(")");
}
//string updateSql="update tMachine set "
// + "LinkComNo=" + OprObject.LinkComNo + ","
// + "IsSupport=" + OprObject.IsSupport + ","
// + "TestValue=" + OprObject.TestValue + ","
// + "TestSign='" + OprObject.TestSign + "',"
// + "LinkStdCode='" + OprObject.LinkStdCode + "'"
// + " where SysCode='" + OprObject.SysCode + "' ";
DataBase.ExecuteCommand(sb.ToString(), out sErrMsg);
sb.Length = 0;
rtn = 1;
}
catch (Exception e)
{
sErrMsg = e.Message;
}
return(rtn);
}
/// <summary>
/// 删除操作
/// </summary>
/// <param name="code"></param>
public void Delete(string code, out string sErrmsg)
{
string cmdText = string.Format("DELETE FROM tMachine WHERE Syscode='{0}'", code);
DataBase.ExecuteCommand(cmdText, out sErrmsg);
}
