public static bool AddNewInputModelColumn(string InputModelID, string GroupID, string ColumnName)
{
try
{
using (SqlConnection cn = SqlHelper.OpenConnection())
{
SqlCommand _cmd = new SqlCommand(SQL_AddNewInputModelColumn, cn);
_cmd.Parameters.Add("@IVC_ID", decimal.Parse(SequenceAccessor.GetNewId()));
_cmd.Parameters.Add("@IV_ID", decimal.Parse(InputModelID));
_cmd.Parameters.Add("@COLUMNNAME", ColumnName);
_cmd.Parameters.Add("@DISPLAYNAME", ColumnName);
_cmd.Parameters.Add("@IVG_ID", decimal.Parse(GroupID));
_cmd.ExecuteNonQuery();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
public static bool SaveNewInputModel(string _namespace, MD_InputModel SaveModel)
{
try
{
using (SqlConnection cn = SqlHelper.OpenConnection())
{
SqlCommand _cmd = new SqlCommand(SQL_SaveNewInputModel, cn);
_cmd.Parameters.Add("@IV_ID", SequenceAccessor.GetNewId());
_cmd.Parameters.Add("@NAMESPACE", _namespace);
_cmd.Parameters.Add("@IV_NAME", SaveModel.ModelName);
_cmd.Parameters.Add("@DESCRIPTION", SaveModel.Descript);
_cmd.Parameters.Add("@DISPLAYNAME", SaveModel.DisplayName);
_cmd.Parameters.Add("@DISPLAYORDER", Convert.ToDecimal(SaveModel.DisplayOrder));
StringBuilder _cs = new StringBuilder();
_cs.Append(string.Format("<TABLE>{0}</TABLE>", SaveModel.TableName));
_cs.Append(string.Format("<ORDER>{0}</ORDER>", SaveModel.OrderField));
_cs.Append(string.Format("<TYPE>{0}</TYPE>", SaveModel.ModelType));
_cs.Append(string.Format("<PARAMTYPE>{0}</PARAMTYPE>", SaveModel.ParamterType));
_cs.Append(string.Format("<INITZB>{0}</INITZB>", SaveModel.InitGuideLine));
_cs.Append(string.Format("<GETZB>{0}</GETZB>", SaveModel.GetDataGuideLine));
_cs.Append(string.Format("<NEWZB>{0}</NEWZB>", SaveModel.GetNewRecordGuideLine));
_cmd.Parameters.Add("@IV_CS", _cs.ToString());
_cmd.Parameters.Add("@DELRULE", SaveModel.DeleteRule);
_cmd.Parameters.Add("@DWDM", SaveModel.DWDM);
_cmd.ExecuteNonQuery();
}
return(true);
}
catch (Exception e)
{
LogWriter.WriteSystemLog(e.Message, "ERROR");
return(false);
}
}
public static bool AddNewInputModelSavedTable(string InputModelID, string TableName)
{
using (SqlConnection cn = SqlHelper.OpenConnection())
{
SqlTransaction _txn = cn.BeginTransaction();
try
{
SqlCommand _cmd = new SqlCommand(SQL_AddNewInputModelSavedTable, cn, _txn);
_cmd.Parameters.Add("@ID", decimal.Parse(SequenceAccessor.GetNewId()));
_cmd.Parameters.Add("@TABLENAME", TableName);
_cmd.Parameters.Add("@IV_ID", decimal.Parse(InputModelID));
_cmd.Parameters.Add("@TABLETITLE", TableName);
_cmd.ExecuteNonQuery();
_txn.Commit();
return(true);
}
catch (Exception e)
{
_txn.Rollback();
return(false);
}
}
}