public C_LINE GetDataObject()
{
C_LINE DataObject = new C_LINE();
DataObject.ID = this.ID;
DataObject.LINE_NAME = this.LINE_NAME;
DataObject.SECTION_ID = this.SECTION_ID;
DataObject.LINE_CODE = this.LINE_CODE;
DataObject.LINE_PCAS = this.LINE_PCAS;
DataObject.DESCRIPTION = this.DESCRIPTION;
DataObject.EDIT_TIME = this.EDIT_TIME;
DataObject.EDIT_EMP = this.EDIT_EMP;
return(DataObject);
}
public int add(C_LINE newline, OleExec DB)
{
string sql = string.Empty;
int result = 0;
Row_C_LINE row = (Row_C_LINE)NewRow();
row.ID = newline.ID;
row.LINE_NAME = newline.LINE_NAME;
row.SECTION_ID = newline.SECTION_ID;
row.LINE_CODE = newline.LINE_CODE;
row.LINE_PCAS = newline.LINE_PCAS;
row.DESCRIPTION = newline.DESCRIPTION;
row.EDIT_EMP = newline.EDIT_EMP;
row.EDIT_TIME = newline.EDIT_TIME;
sql = row.GetInsertString(this.DBType);
result = DB.ExecuteNonQuery(sql, CommandType.Text);
return(result);
}
public C_LINE GetByPcas(string LinePcas, OleExec DB)
{
string sql = string.Empty;
DataTable dt = new DataTable();
C_LINE resultcLine = new C_LINE();
sql = $@"SELECT * FROM C_LINE WHERE LINE_PCAS='{LinePcas}'";
dt = DB.ExecSelect(sql).Tables[0];
if (dt.Rows.Count > 0)
{
resultcLine = CreateLanguageClass(dt.Rows[0]);
}
else
{
resultcLine = null;
}
return(resultcLine);
}
public C_LINE GetByLineName(string LineName, OleExec DB)
{
bool res = false;
string sql = string.Empty;
DataTable dt = new DataTable();
sql = $@"SELECT * FROM C_LINE WHERE LINE_NAME='{LineName}'";
dt = DB.ExecSelect(sql).Tables[0];
C_LINE resultline = new C_LINE();
if (dt.Rows.Count > 0)
{
resultline = CreateLanguageClass(dt.Rows[0]);
}
else
{
resultline = null;
}
return(resultline);
}
public int Update(C_LINE newline, OleExec DB)
{
string sql = "UPDATE C_LINE SET LINE_NAME =:linename,SECTION_ID =:sectionid,";
sql = sql + " LINE_CODE =:linecode,LINE_PCAS =:linepacas,DESCRIPTION =:descs,";
sql = sql + " EDIT_TIME =:edtime,EDIT_EMP =:edemp WHERE ID =:id";
OleDbParameter[] paramet = new OleDbParameter[] {
new OleDbParameter(":linename", newline.LINE_NAME),
new OleDbParameter(":sectionid", newline.SECTION_ID),
new OleDbParameter(":linecode", newline.LINE_CODE),
new OleDbParameter(":linepacas", newline.LINE_PCAS),
new OleDbParameter(":descs", newline.DESCRIPTION),
new OleDbParameter(":edtime", newline.EDIT_TIME),
new OleDbParameter(":edemp", newline.EDIT_EMP),
new OleDbParameter(":id", newline.ID)
};
int result = DB.ExecuteNonQuery(sql, CommandType.Text, paramet);
return(result);
}
public C_LINE GetLineById(string Id, OleExec DB)
{
string sql = string.Empty;
DataTable dt = new DataTable();
C_LINE resultLine = new C_LINE();
sql = $@"SELECT * FROM C_LINE WHERE Id=:id";
OleDbParameter[] paramet = new OleDbParameter[] {
new OleDbParameter(":id", Id)
};
dt = DB.ExecuteDataTable(sql, CommandType.Text, paramet);
if (dt.Rows.Count > 0)
{
resultLine = CreateLanguageClass(dt.Rows[0]);
}
else
{
resultLine = null;
}
return(resultLine);
}
