public BaseLocalModels GetBaseLocalList(BaseLocalModels model) { string errorStr = ""; string listQuery = " SELECT SEQNO , " + string.Join(",", column_BaseLocal) + " FROM conf_local_delivery WHERE 1=1 "; if (!String.IsNullOrEmpty(model.schType)) { listQuery += "AND NATION_CODE = '" + model.schType + "'"; } listQuery += " ORDER BY SEQNO "; DataTable listDt = getQueryResult(listQuery, out errorStr); if (listDt != null && listDt.Rows.Count != 0) { for (int i = 0; i < listDt.Rows.Count; i++) { ConfLocalDelivery temp = new ConfLocalDelivery(); temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim()); temp.NATION_CODE = listDt.Rows[i]["NATION_CODE"].ToString().Trim(); temp.NAME = listDt.Rows[i]["NAME"].ToString().Trim(); temp.HOMEPAGE = listDt.Rows[i]["HOMEPAGE"].ToString().Trim(); temp.COM_ID = listDt.Rows[i]["COM_ID"].ToString().Trim(); temp.MEMO = listDt.Rows[i]["MEMO"].ToString().Trim(); model.Items.Add(temp); } } return(model); }
public ConfLocalDelivery GetBaseLocalView(int SEQNO) { string errorStr = ""; string listQuery = " SELECT SEQNO , " + string.Join(",", column_BaseLocal) + " FROM conf_local_delivery WHERE SEQNO = " + SEQNO; DataTable listDt = getQueryResult(listQuery, out errorStr); ConfLocalDelivery model = new ConfLocalDelivery(); if (listDt != null && listDt.Rows.Count != 0) { model.SEQNO = int.Parse(listDt.Rows[0]["SEQNO"].ToString().Trim()); model.NATION_CODE = listDt.Rows[0]["NATION_CODE"].ToString().Trim(); model.NAME = listDt.Rows[0]["NAME"].ToString().Trim(); model.HOMEPAGE = listDt.Rows[0]["HOMEPAGE"].ToString().Trim(); model.COM_ID = listDt.Rows[0]["COM_ID"].ToString().Trim(); model.MEMO = listDt.Rows[0]["MEMO"].ToString().Trim(); } return(model); }